.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles


Posted By:shiv chandra       Posted Date: June 12, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

Brief about new features of SQL SERVER DENALI

1. SQL Server is "AlwaysOn"

"AlwaysOn" feature includes to high-availability environments and maximize hardware investments. One of these features is support for multi-site clustering, also referred to as multi-subnet clustering. Windows Server Core support is also included. It attempts to reduce SQL Server downtime by eliminating 50 to 60% of the reboots required by OS patching.

2. Code Snippets

Within SSMS is a new feature to add code snippets.  Tools --> Code Snippets Manager.

Within this dialog, you can add a new folder that contains code snippets.  The good news is that it appears folder does not have to be on your local computer, it can be on a shared drive so you can share code with your team.


Example of Code Snippets:

Select the t-sql statement which you want to enclose. After pressing Surround With or Ctrl + K, Ctrl + S it will appear with code snippets. Now double click on selected code snippets.

For example click on "If" code snippets at black area following output will be generated:

More about code snippets at http://msdn.microsoft.com/en-us/library/ff878185%28v=sql.110%29.aspx


3. Zoom (or Magnify)

As simple as any Microsoft product like Word, Excel etc you can change the size of your display by changing the zoom percentage in the lower left corner (same as in Word).


Two of the TSQL enhancements I have covered are the ability to Paginate result sets using ORDER BY.  And the ability to transform column names and datatypes returned from a stored procedure using the WITH RESULT SETS clause.


5. HADR (High Availability and Disaster Recovery)

This new model of HADR replaces the database mirroring setups in the past by using Windows Clustering technology.  Groups can be setup now that contain multiple databases.  These multiple databases (or group) can be failed over at once.


6. FileTable

The new FileTable feature takes storing blob data to a whole new level. With Denali, you can now define a whole table as a FileTable and point it to a folder on a file system. When files are written to that folder, they are available within that FileTable. They can be queried, backed up, and restored right along with the rest of your application data.


7. Spatial Features

SQL Server spatial features have been greatly expanded with this new release. Highlights include new CircularArc subtypes, support for objects bigger than a logical hemisphere (including a new FULLGLOBE data type), new methods for the geography type, spatial index improvements, Nearest Neighbor Query Plan, and support for persisted computes columns.

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend