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!
:{>
April 1st! There is a bad smell to it!
Cool ! Finally into real world
Cool ! Finally into real world
In case anyone is interested, here’s a nice blog post discussing the new features in SQL Server 2012, along with video commentary from the author of the official book on SQL Server, Tyler Graham
http://www.profisee.com/Blog/tabid/335/Default.aspx
"The official book on SQL Server?" You mean Books Online?
Microsoft SQL Server 2008 R2 Master Data Services
By: Tyler Graham, Suzanne Selhorn
http://www.amazon.com/Microsoft-Server-2008-Master-Services/dp/007175623X/ref=sr_1_1?ie=UTF8&qid=1331232205&sr=8-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
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