Friends of Redgate 2015

Reading Time: 2 minutes
It’s official, I am in Friends Of Redgate for 2015!
Ok, the last few months have been an...

Identify Primary Keys That Are Not Identity Columns

Reading Time: 3 minutesPrimary Keys help keep your database in balance
Continuing the thoughts of knowing what is going on in...

Have We Devalued SQL Server Consulting?

Reading Time: 3 minutes
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training...

Have We Devalued SQL Server Consulting?

Have we given too much away?
SQL Server has an amazing community. It freely provides information and training of SQL Server...

12 Things To Check With SQL Server To Prepare For Winter

Reading Time: 8 minutesWinter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts...

12 Things To Check With SQL Server To Prepare For Winter

Winter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts are predicting massive...

Versioning In Your SQL Database

What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking about version control,...

Versioning In Your SQL Database

Reading Time: 4 minutes
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking...

Find all triggers in a SQL Server Database

What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce business rules or...

When Things Align Unexpectedly

Reading Time: 4 minutesThings are happening

or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have...