SQL SERVER 2012 INTRODUCTION

2.SQL SERVER 2012

MS SQL SERVER is a database management system developed and marketed by Microsoft. The SQL SERVER database system was originally developed and implemented by Sybase Inc. Microsoft licensed this DBMS in 1988 for OS/2 operating system and began implementing it for Windows operating system in the early 1990s. At almost the same time, the further development of SQL SERVER for OS/2 was canceled.

In April 1994, Microsoft ended their cooperative agreement with Sybase Inc.

MS SQL SERVER runs exclusively under Microsoft operating systems windows 2000, 2003 Server and XP.

SQL SERVER was, from the beginning, designed as a client/server DBMS. The Client/Server architecture has been developed to manage a large number of different computers, which are connected using a network. The functionality of SQL Server is divided between clients and server. A client provides one or more different requests to Server. The Server processes this request and sends the result back to the client.

Versions SQL SERVER

1. SQL Server 4.0

2. SQL Server 4.2

3. SQL Server 6.0

4. SQL Server 6.5

5. SQL Server 7.0

6. SQL Server 8.0 or SQL Server 2000

7. SQL Server 9.0 or SQL Server 2005

8. SQL Server 10.0 or SQL Server 2008

Editions of SQL Server

1. Enterprise Edition
2. Standard Edition
3. Developer Edition
4. Workgroup Edition
5. Mobile Edition or Compact Edition
6. Express Edition  (Free Edition we can download it from www.microsoft.com)

SQL Server Enterprise Edition. This edition is the complete SQLServer offering for any organization. The Enterprise Edition offers the advanced scalability and reliability features that are necessary for mission-critical line-of business and Internet scenarios, including Distributed Partitioned Views, log shipping, and enhanced failover clustering. This edition also takes full advantage of the highest-end hardware, with support for up to 32 CPUs and 64 GB of RAM. In addition, the SQL Server 2000 Enterprise Edition includes advanced analysis features.

 SQL Server Standard Edition. This edition is the affordable option for small- and medium-sized organizations that do not require advanced scalability and availability features or all of the more advanced analysis features of the SQL Server 2000 Enterprise Edition. You can use the Standard Edition on symmetric multi-processing systems with up to four CPUs and 2 GB of RAM.

¡ SQL Server  Expess Edition. This edition includes a full set of management tools and most of the functionality of the Standard Edition, but it is optimized for personal use. In addition to running on Microsoft’s server operating systems, the Personal Edition runs on non-server operating systems, including Windows 2000 Professional, Windows NT Workstation 4.0, and Windows 98. Dual-processor systems are also supported. While this edition supports databases of any size, its performance is optimized for single users and small workgroups and degrades with workloads generated by more than five concurrent users.

¡ SQL Server Developer Edition. This SQL Server offering enables developers to build any type of application on top of SQL Server. This edition includes all of the functionality of the Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment.

¡ SQL Server  Desktop Engine (MSDE). This edition has the basic database engine features of SQL Server 2000. This edition does not include a user interface, management tools, analysis capabilities, merge replication support, client access licenses, developer libraries, or Books Online. This edition also limits the database size and user workload. Desktop Engine has the smallest footprint of any edition of SQL Server 2000 and is thus an ideal embedded or offline data store.

¡ SQL Server  Windows CE Edition. This edition is the version of SQL Server 2000 for devices and appliances running Windows CE. This edition is programmatically compatible with the other editions of SQL Server 2000, so developers can leverage their existing skills and applications to extend the power of a relational data store to solutions running on new classes of devices.

FEATURES OF SQL SERVER:

1.      Security: Provides login and password to interact with data in database

2.      Data Redundancy: Less Data reputation

3.      Data Integrity: Data validation/Data Checking Process facility

4.      Backup and Recovery(Restore)

5.      Introducing support for XML

6.      User defined function are introduced.

7.      OLAP (online analytical process) services available in SQL server 7.0 are now called as SQL server 2005 analysis services

8.      Repository components available in SQL server now called Meta data services.

Requirements To Install SQL Server 2005 in your work station

• Operating System: Windows Xp, Windows 2000/NT/Professional,Vista
• Primary Memory:  512 MB Ram or above
• Secondary memory: 1GB or above
• Processor: 500 Mhz or above
• Internet explorer: 5.0 or above
• Windows Installer 3.1
• .Net Framework 2.o