DBA News & Scripts

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

How to Temporarily Disable Check Constraints and Database Triggers

Sometimes you will need to change / update / restore some data in a table without the hassle of check...

How to Find SQL Agent Tasks and Schedules

The below script is a convenient way to check on your SQL Server Agent tasks, frequency in which they run,...

How to Find Longest Running Queries

The following DMV query returns the creation time, last execution time, physical and logical reads / writes, as well as...

How to update DB File Growth Settings for ALL Databases at the same time

SQL Server’s default filegrowth settings grow a database in only 1MB increments. For larger databases this can lead to additional...

How to Find the Up-Time of a SQL Server Instance

Your DMV stats are only as good as the amount of data they’ve managed to collect since the last SQL...

How to Fix Very Large MSDB Database

The MSDB database houses your maintenance plan information and job histories (amongst a few other things). For the most part...

How Healthy is your SQL Server?

Let’s not beat around the bush, SQL is complex. There are few “experts” out there that deal with the intricacies...

Surround Yourself with Smart People

Tips for Success from Successful People Love him or hate him, Robert Kiyosaki of “Rich Dad, Poor Dad” fame is...

5 Reasons NOT to Hire a DBA…

Hiring someone to look after your business critical data can be a scary prospect. Maybe you’ve managed to get this...

When’s the Last Time you Serviced your SQL Servers?

When was the last time you looked under the bonnet of your SQL Server? We often have this image in...

Gettin’ Techie SET STATISTICS TIME

Today we’re going to be getting down and dirty with some good, old-fashioned techno-babble. I’m going to be discussing the...

Contact Us

We typically respond within minutes.