Microsoft SQL-Server 2012 New Features
SQL-Server 2012 Upgrades and Enhancements of NoteAs any of my tech-blog readers know, I am a huge fan of Microsoft SQL-Server for my own database applications as well as for software I develop for others. And, it is that time again: a major update of SQL-Server is available and I am busy upgrading my existing databases while also experimenting with the latest features that SQL 2012 has to offer.
Microsoft SQL-Server 2012 continues the SQL-Server line of enterprise-class databases by extending the SQL Server 2008 & 2008R2 through additional modern features and functionality, including the following items that I considered noteworthy enough to mention here (*Note: keep in mind that some features may not be available in all versions of the product):
I really look forward to putting some of the new programming features to use! The windowing enhancements to the OVER clause are very interesting to me, since I have previously written custom code to perform moving-averages, running subtotals, and other interesting algorithms that should now be MUCH easier to implement using the new abilities of the OVER clause.
If you happen to need "windowing" functions but are unable to upgrade to SQL-Server 2012, see my online library of free source code for SQL-Server which includes those moving-averages, running-subtotals, and so on: implemented as pure SET-BASED algorithms too!!
I have not yet tried the LocalDB version of SQL-Server 2012, but I definitely can think up some uses for it. And, it's free, which is always a good thing, though it does have somewhat low limits for memory and total database size.
Breaking Changes in SQL-Server 2012As with any major version upgrade, there is the potential for "breaking changes" that will affect your existing SQL-Server code base (Transact-SQL) and/or your database designs, options, and the like. Obsolete features are the most critical, but you should also consider deprecated features, since it is much easier to get ahead of the curve with regards to planning for future releases.
Enjoy the new SQL-Server 2012 features! Download the free trial editions and/or consider the Developer version once it is available.