Batting twelfth, two new string and formatting functions.Batting eleventh, the new THROW statement to throw an error.Batting tenth (yes, I realize there are only 9 players on a team), a set of new date and DateTime functions.Batting ninth, the new TRY…CONVERT feature.Batting seventh, the new EXECUTE…WITH RESULTS for extending the use of stored procedure result sets.Batting sixth, the new Fetch language feature for paging result sets.Batting fifth, the Baker’s Dozen Potpourri: the new Percentile window functions.Batting fourth, the new Lag and Lead functions.Batting third, the new sequence generator object.Batting second, the new SSDT environment. Leading off, the Baker’s Dozen Spotlight: The new Columnstore index in SQL Server 2012, which can provide dramatic performance improvements in many data warehousing scenarios.Normally, in Baker’s Dozen tradition, I say, “What’s on the menu?” This time I’m saying, “The starting lineup is as follows!” The “night-cap” in the next issue will be 13 new features in SQL Server Integration Services and the new Business Intelligence Semantic Model. The first part of this “twin-bill” (yes, expect a few baseball analogies!) will be 13 new T-SQL and database engine features in SQL Server 2012. So, I’m penning a two-part Baker’s Dozen. There are so many of them that I can’t list them in a single article. And right now, happiness means seeing all the cool new features in SQL Server 2012. I’m still a kid at heart and I still love baseball - and I also love SQL Server. In the summertime, happiness meant a pickup game during the day and a Phillies doubleheader at night.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |