Thursday, May 5, 2011

1G, 2G, 2.5G, 3G, Pre-4G and 4G


Difference Between Image and Picture

IMAGE - An image of your self or anyone (Usually taken through Camera)
PICTURE - A Picture is to draw something in the computer/real life.

Difference Between 1G, 2G, 2.5G, 3G, Pre-4G and 4G

1G is the first generation celullar network that existed in 1980s. It transfer data (only voice) in analog wave, it has limitation because there are no encryption, the sound quality is poor and the speed of transfer is only at 9.6kbps. 

2G is the second one, improved by introducing the concept of digital modulation, which means converting the voice(only) into digital code(in your phone) and then into analog signals(imagine that it flys in the air). Being digital, they overcame some of the limitations of 1G, such as it omits the radio power from handsets making life more healthier, and it has enhanced privacy.

2.5G is a transition of 2G and 3G. In 2.5G, the most popular services like SMS (short messaging service), GPRS, EDGE, High Speed Circuit switched data, and more had been introduced.

3G is the current generation of mobile telecommunication standards. It allows simultaneous use of speech and data services and offers data rates of up to 2 Mbps, which provide servcies like video calls, mobile TV, mobile Internet and downloading.   There are a bunch of technologies that fall under 3G, like WCDMA, EV-DO, and HSPA and others.  

In telecommunications, 4G is the fourth generation of cellular wireless standards. It is a successor to the 3G and 2G families of standards. In 2008, the ITU-R organization specified the IMT-Advanced (International Mobile Telecommunications Advanced) requirements for 4G standards, setting peak speed requirements for 4G service at 100 Mbit/s for high mobility communication (such as from trains and cars) and 1 Gbit/s for low mobility communication (such as pedestrians and stationary users)

A 4G system is expected to provide a comprehensive and secure all-IP based mobile broadband solution to laptop computer wireless modems, smartphones, and other mobile devices. Facilities such as ultra-broadband Internet access, IP telephony, gaming services, and streamed multimedia may be provided to users.

PRE-4G technologies such as mobile WiMAX and Long term evolution (LTE) have been on the market since 2006 and 2009 respectively, and are often branded as 4G. The current versions of these technologies did not fulfill the original ITU-R requirements of data rates approximately up to 1 Gbit/s for 4G systems. Marketing materials use 4G as a description for LTE and Mobile-WiMAX in their current forms.

Wednesday, April 20, 2011

COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 with Excel

http://technoblogy.net/retrieving-the-com-class-factory-for-component-with-clsid-00024500-0000-0000-c000-000000000046-failed-due-to-the-following-error-80040154/

Thursday, April 7, 2011

SQL SERVER CODE NAME

  • 1993 – SQL Server 4.21 for Windows NT
  • 1995 – SQL Server 6.0, codenamed SQL95
  • 1996 – SQL Server 6.5, codenamed Hydra
  • 1999 – SQL Server 7.0, codenamed Sphinx
  • 1999 – SQL Server 7.0 OLAP, codenamed Plato
  • 2000 – SQL Server 2000 32-bit, codenamed Shiloh (version 8.0)
  • 2003 – SQL Server 2000 64-bit, codenamed Liberty
  • 2005 – SQL Server 2005, codenamed Yukon (version 9.0)
  • 2008 – SQL Server 2008, codenamed Katmai (version 10.0)
  • 2010 – SQL Server 2008 R2, Codenamed Kilimanjaro (aka KJ)
  • Next – SQL Server 2011, Codenamed Denali

Monday, March 28, 2011

To get the Host Name and IP address in C#

using System.Net;
string getHost = System.Net.Dns.GetHostName();
string getIP = System.Net.Dns.GetHostByName(getHost).AddressList[0].ToString();

To Findout the Port no. , Server name of sql server.

DECLARE @SqlServerName VARCHAR(255)
        , @SqlVersion VARCHAR(255)
        , @PortNumber VARCHAR(10)

DECLARE @Result TABLE(ServerName VARCHAR(255), Version VARCHAR(255), Port VARCHAR(10))

SELECT @SqlServerName = @@ServerName,  @SqlVersion = LEFT(@@Version, 38)

EXEC xp_regread
    @rootkey = 'HKEY_LOCAL_MACHINE',
    @key = 'SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP',
    @value_name = 'TcpPort',
    @value = @PortNumber output

Select @PortNumber,@SqlServerName ,@SqlVersion

Monday, January 10, 2011

What Means of CMM Level ?

Hi,
Any company which has been started new comes under CMMiLevel1 which says that they are not using any documents or following any processes.
CMMi - means Capability Maturity Model integrated.
CMMi is newly introduced. So most of the companies will have CMM certification only and not the CMMi. Only few companies at present are CMMi level.
Actually this certification is given by the Software Engineering Institute by USA.

CMM software Maturity Levels:

Level1:Initial: The s/w development process at this level are adhoc and often chaotic.The project's success depends on heroes and luck.There are no general practices for planning monitoring or Controling the process.It's impossible to predict the time and cost to develop the software.The test process is just as adhoc as the rest of the process.

Level2:Repeatable: This maturity level is best describled as project level thinking.Basic project management processes are in place to track the cost shedule functionality and quality of the product.Lessions learned from previous similar projects are applied.There is a scense of descipline.Basic software testing practices such as test plans and test cases are used.

Level3:Defined:
Organizational not just project specific thinking comes in to play at this level.Common management and engineering activities are standerdized and documented.These standerds are adapted and approved for use on different projects.The rules are not thrown out when things get stressfull.Test documents and plans are reviewed and approved before testing begins.The test group is independent form developers.The test results are used to determine when the s/w is ready.

Level4:Managed: At this maturity level the organizations process is under statistical control.Product quality is specified quantitatively beforehand (for example this product wont release until it has fewer than 0.5 defects per 1 000 lines of code) and the s/w isn't released untill that goal is met.details of the development process and the s/w quality are collected over the projects development and adjustments are made to correct deviations and to keep the project on plan.

Level5:Optimizing: This level is called optimizing (not optimized )because it's continually improving from level 4. new technologies and processes are attempted the results are measured and both incremental and revolutionary changes are instituted to achieve even better quality levels.Just when everyone thinks the best has been obtained.the crank is turned one more time and the next level of improvement is obtained.

Thanks.

Thursday, January 6, 2011