Microsoft – SQLServer – What is in a name – Denali

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:

http://en.wikipedia.org/wiki/Mount_McKinley
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).

Re-Throw Errors

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)

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s