Sunday, February 27, 2011

An Introduction to Sql Server 2011 (Code Name Denali)

Table of Content

  • Introduction
  • Background
  • Installation
  • Launch Screen
  • SSMS Enhancements
  • Object Undocking /Multi Monitor Support
  • Cycle Clipboard Ring
  • Task List
  • Zoom/Magnify
  • Inclusion of Sequence Nodes
  • Surrounded With
  • Code Snippets
  • References
  • Conclusion


Introduction
One of the hottest and awesome developments by Microsoft in the technology field was come into picture on 8th November, 2010 when they released the Community Technology Preview 1 (CTP 1) version of Sql Server 2011(Code name Denali). The CTP1 is available both in 32-bit and 64-bit versions
As expected, Denali has brought some new features for Sql lovers may that be developers, Administrators or Business Intelligence (BI) professionals. In this series we will explore on the enhancements and new features of SSMS. About the rest of the features will look into the subsequent series.

Background
In the last few years, Microsoft has brought many technologies under the developers’ hood. A drastic change has been made in the Sql Server jargon with the advent of Sql Server 2005(code name Yukon) and in the subsequent releases like Sql Server 2008(code name Katmai) and Sql Server 2011(code name Denali), the same pace has been kept with introduction to new features and enhancements as well as improvements.
In this article we will explore more on the new features that Denali has already offer us from a SSMS perspective. The subsequent articles will focus on the enhancements made in the TSql, Administrators and BI areas.

Installation
As this article will focus on the Denali’s SSMS feature, henceforth, this is beyond the scope of this article to give a complete description of the installation. However, kindly refer to the article for the same. It gives a detailed approach of how to install Denali, the hardware and software requirements.
Launch Screen
The launch screen looks as under