Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!

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!

:{>

Published Tuesday, March 06, 2012 2:03 PM by andyleonard

Filed under: SQL Server 2012

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

	Eric Moreau said: April 1st! There is a bad smell to it! March 6, 2012 1:41 PM
	pavan said: Cool ! Finally into real world March 6, 2012 3:30 PM
	Matt said: 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 March 7, 2012 12:39 PM
	Adam Machanic said: "The official book on SQL Server?" You mean Books Online? March 8, 2012 10:32 AM
	Matt said: 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 March 8, 2012 1:45 PM
	D Itshak said: 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. www.slideshare.net/.../fast-transition-to-sql-server-2012-from-mssql-2005-2008-for-developers-david-yitzhak March 11, 2012 10:12 AM