Azure Backup Storage Options

As a database administrator, I am very conscious of how data is being backed up.  Up until SQL Server 2012,...

Fun time Friday - A week is a long time in....

A week is a long time in...

SQL Server Land
A week is a long time in SQL Server land. This week...

Fun time Friday - A week is a long time in....

A week is a long time in...

SQL Server LandA week is a long time in SQL Server land. This week I have been busy working on a version migration...

SQL Server Guide To NULL Handling

Every language handles null equality differently and understanding this is crucial as a misunderstanding here can lead to some quite...

Synonyms in SQL Server – Good and Bad

When SQL Server 2005 was released, a nifty little feature was included called synonyms.  Despite being around since SQL Server...

Synonyms in SQL Server – Good and Bad

How you use a synonym can be a huge asset or it can be a significant dampener to performance.  There are benefits and uses for these nifty little things....

The Year in Review Webinar–Dec 18

Join me for our Year in Review Webinar next week, Dec 18, at 4pm GMT. I’ll be joining Kendra and...

Things I Learned at Summit v20 - Trace Flag 4199

Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this first post...

Change Tracking Inserts Require SELECT Permission

I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions...

Difference Between Restore with Recovery & Restore with Norecovery

Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the...