DBA News & Scripts

SQL server techniques, how-to's and other random ramblings

Announcing SQL Server 2017 Cumulative Update 14

What comes after a baker’s dozen of cumulative updates? CU14, that’s what, and it includes a really long list of...

Announcing SQL Server 2016 SP2 CU6: The Update You’ll Remember Forever

I’ll always remember where I was on Tuesday, March 19th, 2019 at 6:55PM. I was sitting in the Seattle airport,...

Announcing SQL Server 2014 SP3 CU2 and SP2 CU16

I’m gonna be honest, dear reader: there isn’t a lot of meat on these bones (and that’s a great thing,...

Announcing SQL Server 2016 SP2 CU5, SP1 CU13

Microsoft went on holiday vacation, and they came back with a vengeance. There are one heck of a lot of...

Why Is SQL Server So Slow?

It’s the perennial question: Why is my SQL server so slow? What was once a finely tuned system has become...

10 Things Every Project Manager Must Know When Deploying a SQL Server

As someone who lives and breathes SQL servers, let me tell you they are complicated beasts. With as many moving...

How to Configure SQL Server Auditing

With the GDPR requirements rattling quite a few trees in the industry, there's been a renewed interest in SQL Server's...

How outsourcing is changing the way you do business!

Outsourcing, it almost used to be a dirty word, evoking images of offshore call centers. Thanks to the rise of...

How to Attach a Database MDF Only

For databases with single log files, the sp_attach_single_file_db stored procedure will work to attach the DB file and create a...

SQL Server 2000 health check script in CVS

For those of you unfortunate enough to still be running legacy applications from the cretaceous period, the below SQL 2000 Health...

How to Split a Database Across Multiple Files / Disks

There’s a lot that can be said about what the correct ways are to split up a database over multiple...

How to Manually Remove Log Shipping

Removing log shipping via SQL Management studio is as simple as un-selecting the log shipping check box under the database...

Contact Us

We typically respond within minutes.