Friday, 1 February 2013

Something About SQL Server

      SQL Server 2012 is the latest version of a database server product that has been evolving since the late 1980's. Microsoft SQL Server originated at Sybase SQL Server in1987. In 1988, Microsoft, Sybase, and Aston-Tate ported the product to OS/2. Later Aston-Tate dropped out of the SQL Server development picture, and Microsoft and Sybase signed a co-development agreement to port SQL Server to Windows NT. The co-development effort cumulated in the release of SQL Server 4.0 for Windows NT. After the 4.0 release, Microsoft and Sybase split on the development of SQL Server, Microsoft continued forward with future targeted on Windows NT platform while Sybase moved ahead with releases targeted for the UNIX platform, which they still market today. SQL Server 6.0 was the first release of SQL Server that was developed completely by Microsoft, In 1996, Microsoft updated SQL Server with the 6.5 release. After a 2 year development cycle Microsoft released the vastly updated SQL Server 7.0 release in 1998.
           SQL Server embodied many radical changes in the underlying storage and database engine technology used in SQL Server, SQL Server 2000, the accumulation of another 2 year effort, was released in September,2000. The move from SQL Server 7.0 to SQL Server 2000 was more than an evolutionary move that dint entail the same kind of massive  changes that were made in the move from 6.5 to 7.0. Instead, SQL Server 2000 was build incrementally on the new code base that was established in 7.0 release. Starting with SQL Server 2000, Microsoft began releasing updates to the basic release of SQL Server in the following year starting with XML for SQL server web release 1, which added several XML features including the ability to receive the result set  as an SQL document.
             The next year they renamed the web release to the more succinctly title SQLXML 2.0, which among other thing added the ability to update the SQL Server database using XML updategrams. This was quickly followed by the SQLXML 3.0 web release which included the ability to expose stored procedures as web services. 2 years later, Microsoft SQL Server release history accumulates with the release of SQL Server 2005. SQL Server 2005 uses the same basic architecture that was established with SQL Server7 and it adds to this all the features introduced with SQL Server 2000.

The following timeline summarizes the developmental history of SQL Server
  • 1987 Sybase releases SQL Server for UNIX.
  • 1988 Microsoft, Sybase and Aston-Tate port SQL Server to OS/2
  • 1989 Microsoft, Sybase and Aston-Tate release SQL Server 1.0 for OS/2
  • 1990 SQL Server 1.1 is released with support for Windows 3.0 clients.                           Aston-Tate drops out of SQL Server development.
  • 1991 Microsoft and IBM end join development of OS/2.
  • 1992 Microsoft SQL Server 4.2 for 16 bit O/S 2 1.3 is released.
  • 1992 Microsoft and Sybase port SQL Server to windows NT.
  • 1993 Windows NT 3.1 is released.
  • 1993 Microsoft and Sybase release version 4.2 of SQL Server for windows NT.
  • 1994 Microsoft and Sybase code development of SQL Server officially ends. Microsoft continues to develop the Windows version of SQL Server. Sybase continues to develop the UNIX version of SQL Server.
  • 1995 Microsoft releases version 6.0 of SQL Server.     
  • 1996 Microsoft releases version 6.5 of SQL Server.    
  • 1998 Microsoft releases version 7.0 of SQL Server. 
  • 2000 Microsoft releases SQL Server 2000
  • 2001 Microsoft releases XML for  SQL Server web release 1.  
  • 2002 Microsoft releases SQLXML 2.0 ( renamed from XML for  SQL Server).
  • 2002 Microsoft releases SQLXML 3.0.
  • 2005  Microsoft releases SQL Server 2005 on November 7th,2005.
  • 2008 Microsoft releases SQL Server 2008 on August 6th,2008.
  • 2012  Microsoft releases SQL Server 2012 on March 7th,2012.                                     

What is .Net Framework

.Net Framework

It is a software which masks the functionality of an OS and executes the .NET languages, compile IL code under its control providing the features like :
  • Portability
  • Security
  • Automatic Memory Management
If we wanted to run the IL code on any machine it is must to install .NET framework on that machine.
In case of platform dependent languages like C,C++ etc the compiled code(machine code) runs directly under OS.
The code which runs under the framework is known as managed code and the code which runs under the OS is known as Un-managed code, where managed code provides features like portability, security, automatic memory management etc.

Development of .Net Framework 
  • Microsoft has started the development of software in late 90's originally under the name NGWS.
  • To develop this framework: A set of specification have been prepared knows as CLI(Commom Language Infrastructure) specification.
  • CIL specifications are open specification standardize under organization ISO and ECMA.
The CIL specification talks about four inportant things like :
  • CLS(Comman Language Specification)
  • CTS(Comman Type System)
  • BCL(Base Class Library)
  • VES (Virtual Execution System) or CLR(Common Language Run-time)
1.Common Language Specification(CLS)

It is a set of base rules all the .Net languages has to adopt to inter operate with each other. Most importantly after compilation of any .Net language program they should give the same output code i.e CIL code.

2. Conman Type System(CTS)

According to this all languages of .Net has to adopt uniform data type structure i.e similar data types must be same in size under all languages of .Net so that if any two languages want to communicate with each other size problems with same data type will not come. As most of the .Net laguages or extensions to some existing laguages like COBOL.NET extension to COBOL, VB.NET extension to VB etc. so the data types names will be different from language to language but even if names are different similar types will be uniform in size.

3.Base Class Library(BCL)

A libraby is a set of reusable funtionalities where each and every programming langauge has built-in libraries to it like header files in C,C++, Pacages in JAVA etc. Same as the above >net laguage are also provided with built-in libraries known as class libraries.
Base class libraries are best example for langauge interoperability because those libraries are developed in c# language and can be consumed from any .Net language.

4.VES os CLR

All .Net language once after compilation will generate the same type of IL code knows as CIL code is what we install on the client machines for execution. To run the CIL code on a machine, the machine should be installed with .Net framework and inside the  .Net framework we have CLR or VES which converts CIL code into machine code accoeding ti he operating system  and microprocessor.

.Net framework Versions

 The development of .Net has been started in late 90's ant the first version of framework has been launched in the year 2000 as 1.0 beta(trial version) and officially it is launched into the market as with 1.0 RTM(Release to Manufacturer) in 2002.

2000       -               .Net framework 1.0 (beta)
2002       -               .Net framework 1.0 (trial)
2003       -               .Net framework 1.1
2005       -               .Net framework 2.0
2006       -               .Net framework 3.0
2007       -               .Net framework 3.5
2009       -               .Net framework 4.0
2012       -               .Net framework 4.5


Birthday Blast !!

Yesterday we had a Birthday celebration in the office itself of all the Employees working over here whose birthday fall in the month of January. This is an interesting trend over here, wherein at the end of every month we use to celebrate in combine.It was fun,we enjoyed and we had a cake and snacks. Felt quit relaxed at the end of the day.

Wednesday, 30 January 2013

Experiences In Hyderabad

        We are students of M.C.A. final yr (6th Semester) studied in 'G.H.Raisoni of Information Technology' in Nagpur (Maharashtra). After we finished our 5th semester we often wondered in which place we would get a chance to do our 6th Semester Live Project. We always had a very keen interest to come to Hyderabad because it is known as a good I.T. city where one could learn and start a career in a professional field. We tried with Inforica and now we are very lucky that we were able to get a chance to work with Inforica and probably we have taken "THE FIRST STEP TOWARDS THE CORPORATE WORLD".
      The Experiences in Hyderabad so far has been quite good. The hostel is good, with North-Indian food sometimes, good room-mates particularly who know Hindi and English because we don't know Telugu.. We haven't yet gone anywhere accept the company so we yet don't know much about Hyderabad. Hopefully after 6 months when we will go back to Nagpur we would have learned a lot and we will work hard and will surely make our decision of coming to Hyderabad a great success.

Experiences With Inforica






Since we are doing our Internship with Inforica, I would like to share about Inforica.

About INFORICA

Operating since 2000, Inforica is one of the leading Integration and Professional services firms in Canada. With a team of over 100 highly experienced professionals, is offering the capabilities of a large firm and the entrepreneurial zeal of a start-up.
There value proposition is simple – They offer deep capability with a track record of 100% project success at highly competitive prices. They have extensive business and technical experience with Fortune 500 clients across diverse industries. Inforica focuses on the following Enterprise Solutions.
Business Communications Management
Provides an advanced, all-IP communication solution for multichannel contact centers and contact-intensive, multisite organizations. Here are some of the areas they cover:

1.Contact Centre Solutions - A communications platform should make your contact center a service powerhouse.
2.IP Telephony Solutions - support voice over IP (VoIP), open standards like SIP, mobile workers and the unified voice and data communications business now demands.
3.Communications Based Process Automation - Processes are what make organizations tick. Some processes are horizontal (apply to all-types of organizations) and some are vertical (industry‐specific) in nature.
4.Process Automations - Focuses on delivering Business Process Automation through real-time data acquisition, process monitoring and reporting for the Healthcare, Hospitality, Campus and Energy and Facility Management Solutions.
Enterprise Resource Planning
5.PeopleSoft
6.Microsoft Dynamics AX

CRM Solutions
CRM is an integrated approach to acquiring, retaining and deepening customer relationships.CRM enables organizations to leverage the value of every customer interaction.

Business Intelligence Solutions
There Business Intelligence practice focuses on Reporting and Data Warehousing. Working with industry-leading technologies their solutions can help you achieve business intelligence objectives.

Industry Solutions
Energy Management - focuses on delivering holistic solutions to effectively and efficiently monitor and manage in real time energy and utilities consumption within a single or multiple dwelling units.

HealthCare Solutions- Delivering integrated communications that optimizes workflow, decreases cost-of-care and leverages investment in current systems.

Education Solutions - Delivering web based hosted Elementary report card solutions, Web portals for schools and Student Information
Systems

Global Sourcing
Ifusion -Designed from the ground up, iFusion™ offers you the best of both worlds by combining the immediacy and trust of a local consulting partner with tangible cost savings (30%—40%) of an offshore development model.

WHAT INFORICA DOES

• Business Intelligence Solutions
• Business Communications Management
• Business Process Outsourcing
• CRM Solutions
• Enterprise Resource Planning
• Global Sourcing

So it was all about Inforica, now I would like to share some of our Experiences from the first day of Internship.
At the beginning we were quite afraid to join here for a Live Project but at the same time we were excited to come to Hyderabad and found ourselves lucky to join a company like Inforica. It was a pleasure to join here. From the first day we learnt a lot from Sudeep (our Guide). He is very kind and a Good coach. Now it’s been one week and we probably got habitual to this environment. And believe me it’s a Great feeling for a fresher’s like us TO ENTER TO A CORPORATE WORLD with such a great Company.

Monday, 28 January 2013



// Write a program to print the area of a circle.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace areaofcircle
{
    class Program
    {
        static void Main(string[] args)
        {
            int r;
            double a, p;
            p = 3.14;
            Console.WriteLine("Enter the value of radius");
            r = Convert.ToInt32(Console.ReadLine());
            a = p * r * r;
            Console.WriteLine("area" + a);
            Console.ReadLine();

        }
    }
}


// Write a program to print the fibonacci series

using System
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace fibo
{
    class Program
    {
        static void Main(string[] args)
        {
            int n, i, pre = 0;
            int next = 1;
            Console.WriteLine("Enter the value of n:  ");
            n = Convert.ToInt32(Console.ReadLine());
            for (i = 2; i <= n; i++)
            {
                int a = pre + next;
                Console.WriteLine(" " + a);
                pre = next;
                next = a;
            }
            Console.ReadKey();
            }
        }
    }