By Ginger Daniel | Intermediate , SQL Administration , SQL Server
— By Ginger Keys Once upon a time there was an organization that depended on very accurate data entry rules. For various reasons, some of the employees who were responsible for inputting and updating records were not very diligent about following rules to keep the data clean and uniform, reasoning that IT would go behind […]
Continue readingBy Lori Brown | Expert , Performance Tuning , SQL Administration , SQL Server
Sometimes it is good to have some queries in your toolkit that give you information on how things are running that includes the actual execution plan. While looking at Glenn Berry’s diagnostic query scripts (http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-september-2015/), which are very good btw, I found queries that will list stored procedure statistics but none had the execution plan […]
Continue readingBy 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 readingBy Lori Brown | Beginner , SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah Any login that is a member of the sysadmin role can reset the SA password. But, what if you have a hostile takeover by an application or for some strange reason don’t have any other logins as members of the sysadmin role? Don’t laugh! I have actually run into both […]
Continue readingBy Lori Brown | Beginner , SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah What are the critical aspects of SQL Server that a DBA should check on a daily basis? How about on a weekly or monthly basis? Daily Checklist Backups: Check your backups (Full, Differential, Transaction Logs) to validate that they were successfully created per your company’s policies. Nightly Processing: Review the nightly or […]
Continue readingBy 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 readingBy Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server
Beginning with SQL Server 2012 and beyond, Microsoft has developed a new feature in all editions of SQL Server that allows us to create databases independent of the instance hosting that database. In this article I will cover some of the features, pros and cons, and how to create a contained database. What is it? […]
Continue readingBy Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah After reading up on AlwaysOn Monitoring and Alerting (http://blog.sqlrx.com/2015/08/27/alwayson-monitoring-and-alerting/), I was asked to come up with a way to automatically enable jobs that may only need to run on the primary replica of an availability group. Requirements were that on failover of an AlwaysOn Availability Group some jobs should be […]
Continue readingBy Lori Brown | SQL Administration , SQL Server , Tip of the Month
— By Lori Brown @SQLSupahStah Available in SQL Server 2014 Enterprise Edition and Standard Edition x64 only Buffer Pool Extension is a way to use solid state disks (SSD) as nonvolatile RAM (NvRAM) instead of memory. It reduces latency. It stores clean or committed pages only so there is no risk of data loss and […]
Continue reading