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...

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 process of backup. In case of SQL Server, restoration...

Maintenance Plan Owner – Back to Basics

We all inherit things from time to time through our profession.  Sometimes we inherit some good things, sometimes we inherit...