SQL Server 2011 (Code named Denali)


SQL Server Management Studio introduces the following features in CTP1:

· The Database EngineQuery Editor introduces enhanced functionality for Transact-SQL debugging and IntelliSense.

· The Transact-SQL debugger introduces the following new features:

· You can now debug Transact-SQL scripts running on instances of SQL Server 2005 Service Pack 2 (SP2) or later.

· Transact-SQL breakpoints now support the following functionality:

· A breakpoint condition is a Transact-SQL expression whose evaluation determines whether the breakpoint is invoked.

· A breakpoint hit count specifies the number of times a breakpoint is encountered before it is invoked.

· A breakpoint filter limits the breakpoint to operating only on specified computers, processes, or threads.

· A breakpoint action specifies a custom task that is performed when the breakpoint is invoked.

· You can edit a breakpoint location to move a breakpoint from one Transact-SQL statement to another.

· The Watch window and Quick Watch now support watching Transact-SQL expressions.

· When you move the cursor over a Transact-SQL identifier, a Quick Info pop up displays the name of the expression and its current value.

· Transact-SQL IntelliSense introduces the following new features:

· Breakpoint validation prevents setting a breakpoint in an invalid location.

· Transact-SQL code snippets are templates you can use as starting points when building Transact-SQL statements in batches and scripts.

· Transact-SQL Surround with snippets are templates you can use as staring points when enclosing sets of Transact-SQL statements in a BEGIN, IF, or WHILE block

Microsoft made a number of improvements on this new release “Denali“. These are some of the key improvements

Manageability Enhancements

· TSQL Enhancements : The Database Engine Query Editor introduces enhanced functionality for Transact-SQL debugging and IntelliSense

· Contained Databases: Users can connect to the database without authenticating a login at the Database Engine level. Moving databases from one instance of the SQL Server Database Engine to another instance of the Database Engine is simplified by introducing contained databases.

· Changed Startup Options : Changing SQL Services Startup Parameters is very easy in SQL Server Denali, No need to remember syntax and where to place (;)

Programmability Enhancements

· Full-Text Search : In Denali,you can configure a full-text index to support property-scoped searching on properties, such as Author and Title, which are emitted by IFilters.. Adding to this, you can also customize a proximity search by using the new custom NEAR option of the CONTAINS predicate or CONTAINSTABLE function

· Introduction to Sequence : SQL Server finally has the concept of a “sequence” that Oracle has had for years

· Circular Arc Segment Support for Spatial Types : There are new methods for geometry and geography data types that work with circular arc segments.

· Extend Order by Clause functionality : You can specify a range of rows returned by a SELECT statement based on row offset and row count values that you provide.

· Extend Execute Statement functionality : SQL Server extends the EXECUTE statement so that it can be used to send pass-through commands to linked servers.

· New Collation Support : A new family of supplementary characters (SC) collations can be used with the data types nchar, nvarchar and sql_variant.

· Metadata Discovery : The SET FMTONLY option for determining the format of a response without actually running the query is replaced with sp_describe_first_result_set, sp_describe_undeclared_parameters, sys.dm_exec_describe_first_result_set, and sys.dm_exec_describe_first_result_set_for_object.

Security Enhancements

· New Role Management : Now we can create User defined Server level Roles

· Added New Encryption Algorithms : The HASHBYTES function now supports the SHA2_256, and SHA2_512 algorithms for encryption.

· Contained Databases: Users can connect to the database without authenticating a login at the Database Engine level. Moving databases from one instance of the SQL Server Database Engine to another instance of the Database Engine is simplified by introducing contained databases.

· New Permissions : Denali Added new Permissions like New GRANT, REVOKE, and DENY permissions to a SEARCH PROPERTY LIST are available. , New GRANT, REVOKE, and DENY permissions to CREATE SERVER ROLE and ALTER ANY SERVER ROLE.

Contained Database

A contained database includes all database settings and metadata required to define the database and has no configuration dependencies on the instance of the SQL Server Database Engine where the database is installed. Users can connect to the database without authenticating a login at the Database Engine level. Isolating the database from the Database Engine makes it possible to easily move the database to another instance of SQL Server. Including all the database settings in the database enables database owners to manage all the configuration settings for the database.

SQL Server powershell

SQL Server 2008 introduces support for Windows PowerShell. Windows PowerShell 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.

SQL Server provides two Windows PowerShell snap-ins that implement:

· A SQL Server provider, which enables a simple navigation mechanism similar to file system paths. You can build paths similar to file system paths, where the drive is associated with a SQL Server management object model, and the nodes are based on the object model classes. You can then use familiar commands such as cd and dir to navigate the paths similar to the way you navigate folders in a command prompt window. You can use other commands, such as ren or del, to perform actions on the nodes in the path.

· A set of cmdlets, which are commands used in Windows PowerShell scripts to specify a SQL Server action. The SQL Server cmdlets support actions such as running a sqlcmd script containing Transact-SQL or XQuery statements.

Ref : Microsoft.com, SQLserver-Training.com

Advertisements

Comment please...

Fill in your details below or click an icon to log in:

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