Microsoft Announces SQL Server 2012 RTM!

Earlier today, Microsoft announced SQL Server 2012 has been released to manufacturing! General availability of the cool, new database platform is scheduled for 1 April 2012.

I’ve been working with pre-release versions of the software while writing SSIS Design Patterns. While I have focused mostly on new Integration Services features, I have been most impressed with improvements to the User Experience working with SQL Server Management Studio and SQL Server Data Tools. In sum, SQL Server 2012 is a game-changer!

:{>

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>

8 thoughts on “Microsoft Announces SQL Server 2012 RTM!

  1. For some time, other DBMSs such as Oracle, Sybase and DB2 have had support for window functions. SQL Server has had only a partial implementation up to now. SQL Server 2012 enhances support for windows aggregate function by introducing windows order and frame clause, support for offset functions, and support for distribution function. In this article I will show you advanced use of those function. The interesting thing is that the examples were taken from other RDBMS (ORACLE, SYBASE). Also I will demonstrate what is still missing and needed in SQL SERVER 2012 and how I would accept Microsoft to implement it, in next version Maybe.
    This article is accompanied by the script fast_transition_to_mssql_2012.sql  which demonstrates Programmability Enhancements (Database Engine) SQL 2012   as well as the material covered in this article.
    http://www.slideshare.net/…/fast-transition-to-sql-server-2012-from-mssql-2005-2008-for-developers-david-yitzhak

  2. For some time, other DBMSs such as Oracle, Sybase and DB2 have had support for window functions. SQL Server has had only a partial implementation up to now. SQL Server 2012 enhances support for windows aggregate function by introducing windows order and frame clause, support for offset functions, and support for distribution function. In this article I will show you advanced use of those function. The interesting thing is that the examples were taken from other RDBMS (ORACLE, SYBASE). Also I will demonstrate what is still missing and needed in SQL SERVER 2012 and how I would accept Microsoft to implement it, in next version Maybe.
    This article is accompanied by the script fast_transition_to_mssql_2012.sql  which demonstrates Programmability Enhancements (Database Engine) SQL 2012   as well as the material covered in this article.
    http://www.slideshare.net/…/fast-transition-to-sql-server-2012-from-mssql-2005-2008-for-developers-david-yitzhak

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.