MSc Telecom Technology(Sikkim Manipal University)

Very good course for busy telecom professionals (both experienced BSS/OSS)

Syllabus given below

Semester 1
========
Computer Basics
C & OOP
Basic Electronics for Telecom
Java Programming
Basic Principles of Networking

Semester 2
========

Principles of Digital Telecom
Broadband communication network
Wireless communication system
mathematics for Telecommunication
Database management
Software Engineering

Semester 3
========

Overview of Telecom Technology
Switching & Transmission Fundamentals
New Generation Networks(optical based)
Signalling System Number - 7 (SS-7)
WML Scripts & WAP
Client Server Architecture

Semester -4
=========
Voice over IP (VOIP)
Geographical Information System (GIS)
Artificial Intelligence & Remote Communications
Billing & Customer Care
Telecommunication Regulation, Market & Service
Project

Shama (Prayer of Jews)

Happy New Year dear blog readers,

Shema Yisrael Shema Eloheinu Shema Eḥad. (Hear, O Israel, the Name is our God, the Name is One.)

This is jew belief as we Christians believe that God is Holy Trinity(Father, Son and Holy Spirit)

Excel function to convert date "2011-11-04-23.22.10.446908" to "2011-11-04"

=MID(A2,SEARCH("2011",A2,1),10)

Excel Function to change date in "2011-02-10 19:18:11" format to "10/02/2011 19:18:11" format

=CONCATENATE(MID(N2,SEARCH("-",N2)+4,2),"/",MID(N2,SEARCH("-",N2)+1,2),"/",MID(N2,SEARCH("-",N2)-4,4)," ",MID(N2,SEARCH(":",N2)-2,2),":",MID(N2,SEARCH(":",N2)+1,2),":",
,MID(N2,SEARCH(":",N2)+4,2))

Meaning of name LLoyd

Lloyd \ll(o)-yd\ as a boy's name is pronounced loyd. It is of Welsh origin, and the meaning of Lloyd is "gray-haired; sacred". From Llwyd. The name may originally allude to experience and wisdom, and probably denoted a person entitled to respect. Actor Lloyd Bridges; Senator Lloyd Bentsen.

Lloyd has 2 variant forms: Floyd and Loyd.

Baby names that sound like Lloyd are Ladd, Lad, Laud and Lot.

View a list of the 6 names that reference Lloyd.
Popularity of Lloyd

Lloyd is a very popular first name for men (#160 out of 1220) and also a very popular surname or last name for all people (#470 out of 88799). (1990 U.S. Census)
Displayed below is the baby names popularity of the name Lloyd for boys. (2010 statistics) Compare Lloyd with its variant forms and related boy baby names.

Source Courtesy : http://www.thinkbabynames.com/meaning/1/Lloyd

It is a very good website for baby name meanings

How to Kill an Oracle SQL query if SQL text and Oracle User are known

select
b.sid,b.SERIAL#,b.username,a.sql_text
from
v$sqltext a,
v$session b,
v$process c
where
b.username='ORACLEUSER'
and
c.addr = b.paddr
and
b.sql_address = a.address and b.status='ACTIVE'
order by b.sid

alter system kill session '45,20' immediate

Excel function for advanced Date manipulation

Excel Function to change date in "2011-02-10 19:18:11" format to "10/02/2011 19:18:11" format


=CONCATENATE(MID(N2,SEARCH("-",N2)+4,2),"/",MID(N2,SEARCH("-",N2)+1,2),"/",MID(N2,SEARCH("-",N2)-4,4)," ",MID(N2,SEARCH(":",N2)-2,2),":",MID(N2,SEARCH(":",N2)+1,2),":",
,MID(N2,SEARCH(":",N2)+4,2))