New and Enhanced Features - SQL Server 2012 (What's New in SQL Server 2012) - Part 8

Few More…. New Features

Few other Enhancement and new features added in SQL 2012, which we are describing below:

Summary of T-SQL Enhancement: T-SQL received a lot of improvements in SQL Server 2012. We already discussed almost all the new features, here just have a look and recollect again as summary.

1.     OBJECT ID of #TEMP tables: One of the breaking changes added in SQL Server 2012 is related to the creation of #TEMP tables. SQL Server 2012 assigns a negative value as the OBJECT ID of the #TEMP tables.

2.       SQL Server Express LocalDB - SQL Server Express LocalDB is a new lightweight edition of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites.

The LocalDB edition of SQL Server is targeted to program developers. LocalDB installation copies a minimal set of files necessary to start the SQL Server Database Engine. Developer Tools can provide developers with a SQL Server Database Engine that lets them write and test Transact-SQL code without having to manage a full server instance of SQL Server.

An instance of SQL Server Express LocalDB can be managed by using the SqlLocalDB.exe utility. SQL Server Express LocalDB should be used in place of the SQL Server Express user instance feature which is deprecated.

3.       Native XML Web Services (SOAP/HTTP endpoints) is removed: Beginning in SQL Server 2012, you can no longer use CREATE ENDPOINT or ALTER ENDPOINT to add or modify SOAP/HTTP endpoints.

4.       SQL Server PowerShell: SQL Server 2012 supports Windows PowerShell, which is a powerful scripting shell that lets administrators and developers automate server administration and application deployment. The Windows PowerShell language supports more complex logic than Transact-SQL scripts, giving SQL Server administrators the ability to build robust administration scripts. Windows PowerShell scripts can also be used to administer other Microsoft server products. This gives administrators a common scripting language across servers.