Back To (Security) Basics

Security is very much on our minds these days. Scarcely a day goes by without hearing of a yet another...

File This Under File Groups (Part 1)

I never had cause to give much consideration to storage when I was a SQL developer. The companies I worked...

Spaced-Out Strings

I came across this in a code review not long ago:

Three things pop into my head when I see this...

A View On Views

In my experience, there are few database objects more poorly understood, misunderstood, misused, and outright abused, than the humble view....

It’s All About The Joins

One of the most common mistakes I see made when creating tables (and I’ve been guilty of this myself too...

Welcome to The Monday Morning DBA

I started my IT career twenty years ago as a VB and C developer, wandered into C++ for a bit,...