Microsoft – SQLServer – What is in a name – Denali
Well Denali sounds like Sonali; an East Indian name for a girl. It means Golden.
But, to most people that google for it, they will be directed to the Wikipedia page.
That page has it noted as a very high mountain:
Mount McKinley, or Denali (Koyukon Athabaskan for “The High One”, Dghelaayce’e in Ahtna), in Alaska, is the highest mountain peak in the United States and in North America, with a summit elevation of 20,320 feet (6,194 m) above sea level. Measured base-to-peak, it is the tallest mountain on land. Measured by topographic prominence, it is the third most prominent peak in the world after Mount Everest and Aconcagua. It is the centerpiece of Denali National Park and Preserve.
Microsoft borrowed the same name as a code name for MS SQL Server v2012.
MS SQL Server 2012 comes with many new functionalities and code fixes.
Here are some of them; most I have yet to use, but through the generosity of others thinking “out loud” and sharing it (for all).
Starting with Microsoft SQL Server v2005, Transact SQL has a much better and polished tooling for Exception Handling.
Prior to v2005, one has to go the way of Visual Basic 3.0 and check for Error Numbers via @@Error.
So basically one would :
declare @iErrorNumber int set @iErrorNumber = @@Error if (@iErrorNumber 0) begin print 'Error Number ' + convert(varchar(30), @iErrorNumber) return end
Thankfully, MS SQL Server v2005, introduced a much more modern and elegant “pattern” for handling exceptions.
Transact SQL’s Implementation of Try\catch is available via http://msdn.microsoft.com/en-US/library/ms175976(v=sql.90).aspx
More generally purpose programming languages allow one to “re-throw” the captured exception. Thus, availing the exception to upper level SQL Modules and the calling Application.
SQL Server v2012 implementation is aptly named “Throw”. It is referenced in http://msdn.microsoft.com/en-us/library/ee677615.aspx
And, a good write-up is available @ “Using the New Throw Keyword in SQL Server Denali” (http://msdn.microsoft.com/en-us/library/ee677615.aspx)