Category Archives for "Tip of the Month"

Dec 02

How to connect using the Dedicated Administrator Connection

By SQLRx Admin | Intermediate , SQL Administration , SQL Server , Tip of the Month

The SQL dedicated administrator connection(DAC) has been around since SQL 2005 and is a diagnostic connection that is designed to allow an administrator to troubleshoot SQL Server when the instance is having problems.  Only members of the sysadmin role can connect using the DAC.  You can connect using the DAC both through SQLCMD (SQLCMD –A […]

Continue reading
Nov 04

SQL 2014 Backup Encryption

By SQLRx Admin | Beginner , SQL Administration , SQL Server , Tip of the Month

Available in SQL Server 2014 Enterprise Edition and Standard Edition Backup encryption has been introduced in SQL 2014 to allow encrypting backups without being forced to encrypt the entire database. Several encryption algorithms are supported, including Advanced Encryption Standard (AES) 128, AES 192, AES 256, and Triple DES. You can also compress the encrypted backup. […]

Continue reading
Sep 03

Tip of the Month: WAIT_AT_LOW_PRIORITY option for Index Rebuilds

By Lori Brown | SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

— By Lori Brown  @SQLSupahStah Available in SQL Server 2014 Enterprise Edition since can only be done using ONLINE rebuilds. Index rebuilds have been enhanced with the WAIT_AT_LOW_PRIORITY option. It is used to set the duration in minutes to wait as well as behavior when blocking happens. When setting WAIT_AT_LOW_PRIORITY you also must set MAX_DURATION […]

Continue reading
Jun 03

Changes to System Views in SQL 2014

By Lori Brown | Helpful Scripts , Miscellaneous , Performance Tuning , SQL Server , Tip of the Month

There are two new system views and two system views that have new columns added in SQL 2014. Most notable is sys.databases since this is widely used.   sys.xml_indexes – Has 3 new columns: xml_index_type, xml_index_type_description, and path_id. https://msdn.microsoft.com/en-us/library/ms176003.aspx sys.databases – Has 3 new columns: is_auto_create_stats_incremental_on, is_query_store_on, and resource_pool_id. https://msdn.microsoft.com/en-us/library/ms178534.aspx sys.column_store_row_groups – New view.  Provides clustered […]

Continue reading
>