June 2017

T-SQL 2016 NEW FEATURES

Stolen  Copied from Adam Machanic’s blog (http://sqlblog.com/blogs/adam_machanic/archive/2017/01/13/sql-server-2016-hidden-gems-resources.aspx) STRING_SPLIT https://msdn.microsoft.com/en-us/library/mt684588.aspx Aaron Bertrand’s performance tests: https://sqlperformance.com/2016/03/sql-server-2016/string-split Session Context https://msdn.microsoft.com/en-us/library/mt605113.aspx   Time Zone Support sys.time_zone_info: https://msdn.microsoft.com/en-us/library/mt612790.aspx AT TIME ZONE: https://msdn.microsoft.com/en-us/library/mt612795.aspx   HASHBYTES https://msdn.microsoft.com/en-us/library/ms174415.aspx   Session Wait Stats https://msdn.microsoft.com/en-us/library/mt282433.aspx   Live Query Statistics https://msdn.microsoft.com/en-us/library/dn831878.aspx Ability to attach to other sessions’ Live Queries!  https://blogs.msdn.microsoft.com/sql_server_team/query-progress-anytime-anywhere/   Actual Query Plan Data Enhancements …

T-SQL 2016 NEW FEATURES Read More »

T-SQL 2016 NEW FEATURES

Stolen  Copied from Adam Machanic’s blog (http://sqlblog.com/blogs/adam_machanic/archive/2017/01/13/sql-server-2016-hidden-gems-resources.aspx) STRING_SPLIT https://msdn.microsoft.com/en-us/library/mt684588.aspx Aaron Bertrand’s performance tests: https://sqlperformance.com/2016/03/sql-server-2016/string-split Session Context https://msdn.microsoft.com/en-us/library/mt605113.aspx   Time Zone Support sys.time_zone_info: https://msdn.microsoft.com/en-us/library/mt612790.aspx AT TIME ZONE: https://msdn.microsoft.com/en-us/library/mt612795.aspx   HASHBYTES https://msdn.microsoft.com/en-us/library/ms174415.aspx   Session Wait Stats https://msdn.microsoft.com/en-us/library/mt282433.aspx   Live Query Statistics https://msdn.microsoft.com/en-us/library/dn831878.aspx Ability to attach to other sessions’ Live Queries!  https://blogs.msdn.microsoft.com/sql_server_team/query-progress-anytime-anywhere/   Actual Query Plan Data Enhancements …

T-SQL 2016 NEW FEATURES Read More »

AT TIME ZONE (T-SQL)

New time functions in SQL 2016 Converts an inputdate to the corresponding datetimeoffset value in the target time zone. If inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate value is provided in the target time zone. If inputdate is provided as a datetimeoffset value, than …

AT TIME ZONE (T-SQL) Read More »

AT TIME ZONE (T-SQL)

New time functions in SQL 2016 Converts an inputdate to the corresponding datetimeoffset value in the target time zone. If inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate value is provided in the target time zone. If inputdate is provided as a datetimeoffset value, than …

AT TIME ZONE (T-SQL) Read More »

SQL Server Backup Encryption

To encrypt a backup we need to configure an encryption algorithm (supported encryption algorithms are: AES 128, AES 192, AES 256, and Triple DES) and an encryptor (a certificate or asymmetric key). So if you don’t have a Database Master Key defined you need to create one.

SQL Server Backup Encryption

To encrypt a backup we need to configure an encryption algorithm (supported encryption algorithms are: AES 128, AES 192, AES 256, and Triple DES) and an encryptor (a certificate or asymmetric key). So if you don’t have a Database Master Key defined you need to create one.

DAC

Dedicated Administrative Connection: How to Enable the DAC for Remote Connections and Clusters EXEC sp_configure ‘remote admin connections’, 1; GO RECONFIGURE GO

DAC

Dedicated Administrative Connection: How to Enable the DAC for Remote Connections and Clusters EXEC sp_configure ‘remote admin connections’, 1; GO RECONFIGURE GO

SQL 2016 SP1 – Consistent Programming Surface Area

On 16th Nov 2016, Microsoft announced the support for ‘Consistent Programming Surface Area’ across all editions of SQL Server with few exceptions. Please refer to the https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released. The key value proposition is that it allows customers to use the same code base independent of the editions in SQL Server.

SQL 2016 SP1 – Consistent Programming Surface Area

On 16th Nov 2016, Microsoft announced the support for ‘Consistent Programming Surface Area’ across all editions of SQL Server with few exceptions. Please refer to the https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released. The key value proposition is that it allows customers to use the same code base independent of the editions in SQL Server.