Soft Delete

How to delete without deleting

TDE – Regenerating the Database Encryption Key

As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1

(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...

Why Projects Fail...Free Session, Free Beer and Free Food

Why Projects Fail...Free Session, Free Beer and Free Food 

Mark Williams and myself will delivering a seminar called #Not the GDPR news in...

AT TIME ZONE: The easy way to deal with time zones and daylight savings time

Many people think daylight savings time was created to help align the hours that the sun is up with our...

Buggy Whips 2.0

I recently found myself rereading a very old blog post of mine, from the very beginning of this blog, discussing...

Free Webinar – DBAs vs. SysAdmins in Cloud Availability April 19

SIOS and I are proud to host a joint free webinar entitled “DBAs vs. SysAdmins in Cloud Availability” on Thursday,...

How SQL Compilation Can Prove the Server CPU

It is relatively easy to spot CPU-bound system. But, the source of CPU pressure is not always easy to pinpoint....

Imposter syndrome

Last week I posted the following “joke” on twitter: –

I’ve called it a “joke” but I wasn’t really joking. This...

Jacksonville, South Florida, and Houston

Just crossed off my quarterly goal of planning SQLSaturday attendance for the next quarter (I’m writing this on March 31st!)....