Tag Archives for " Microsoft SQL Server "

Good DBA! Tasks that all DBA’s should do to have a Stable SQL Server

By 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 reading

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

Find and Remove Duplicate Records

By Ginger Daniel | Beginner , Miscellaneous , SQL Development , SQL Server

— by Ginger Keys Having duplicate records in a database is an age-old problem that almost every organization has to deal with. Duplicates can appear because of careless data input, merging records from old systems into new systems, uploading leads from purchased lists, and multiple other reasons. Identifying these duplicate records can also be tricky. […]

Continue reading

Contained Databases – Pros and Cons

By 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 reading

Using Common Table Expressions to Improve Query Performance

By Jeffry Schwartz | Advice , Intermediate , Performance Tuning , SQL Development , SQL Server

-by Jeffry Schwartz Queries with multiple join clauses create particularly difficult issues when they perform poorly. Join ordering is extremely important because if a join creates a huge interim result set at the beginning of the query execution, SQL Server must continue to handle this result set until it can be trimmed down with filtering […]

Continue reading

AlwaysOn Availability Groups – Enable or Disable Jobs on Failover

By 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 reading

Tip of the Month: Buffer Pool Extension

By 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

Troubleshooting SQL Server CPU

By Ginger Daniel | Advice , Miscellaneous , Perfmon , SQL Administration , SQL Server

–by Ginger Keys Recently, a client of mine contacted me in a panic because CPU was running at 99-100% over an extended period of time, which was affecting everything on the machine. We’ve all seen it at one time or another. And there are several reasons this could be happening. It could be SQL consuming […]

Continue reading

New or Changed Table Alert with DDL Triggers

By Lori Brown | Helpful Scripts , SQL Administration , SQL Server

— By Lori Brown  @SQLSupahStah If you are the usual DBA, you are often the last person to know when something new has been added to the databases you are managing. After finding that some people in an organization were abusing their access to a certain database, I decided to create a TSQL DDL trigger […]

Continue reading