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.
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
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.
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.
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.