Thursday 30 July 2015

Introduction of MS SQL Server

What is MS SQL Server...?

MS Sql Server is a Microsoft Sql server or MSSQL ,it is a Microsoft Database Management product, SQL Server is Microsoft's relational database management system (RDBMS), data in RDBMS is stored in database as a objects called tables, tables also stored the definition and structured of database.



Microsoft Lunch several editions of SQL Server with set of different feature and pricing of user needs, following editions:
  • Enterprise:
This edition for large enterprises with complicated data requirements, it include all the features of SQL Server, and its license pricing is very High. 
  • Standard:
This edition is use for medium and small organizations, and it is included future of support data warehousing and e-commerce.
  • Workgroup:
This edition is use For small organizations. It is used as the backend database for small network Web servers or branch offices like VPN.
  • Express:
This edition is use as a Free license for distribution with limited features, it is use for best replacement of MS Access database.free version Download from Microsoft...... site



Microsoft SQL Server Version and Year Wise List

MS SQL Server 1.0 (16 bit) [1989]

MS SQL Server 1.1 (16 bit) [1991]

MS SQL Server 4.21 [1993]

MS SQL Server 6.0 [1995]

MS SQL Server 6.5 [1996]

MS SQL Server 7.0 [1998]

MS SQL Server 7.0 OLAP Tools [1999]

MS SQL Server 2000 [2000]

MS SQL Server 2000 64 bit Edition [2003]

MS SQL Server 2005 [2005]

MS SQL Server 2008 [2008]

MS Azure SQL Server DB [2010] (For Cloud Database Management)

MS SQL Server 2008 R2 [2010]

MS SQL Server 2012 [2012]

MS SQL Server 2014 [2014]

MS SQL Server 2016[2015]


(Every New MS Sql Server version come with new functionality, options, module and features)


Thanks

Krunal Patel
(Software Developer)

:-) :-)

My Popular post click on Link to view


9 comments:

  1. This is my first Blog regarding SQL Server

    ReplyDelete
  2. Nice blog budy good introduction of sql server

    From : Rahul

    ReplyDelete
  3. great post i like it,please tell me how to find current version of sql server ...?

    ReplyDelete
    Replies
    1. Go to help menu and select about display all the details of current version

      Delete
  4. Very nice cool introduction of sql server

    ReplyDelete