SQL Server – Calculating elapsed time from DATETIME

Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...

SQL Server Pro Community Choice Awards

I’m a bit late posting this, but it’s worth a couple minutes to check out the Community Choice awards, might...

SSMS Shortcuts and more

I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs....

Symmetric Keys

One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people...

The Night Before Upgrade

I originally wrote this in December 2011. It’s been one of my most popular posts, so reposting it has become...

Tribal Awards: Vote Now!

The #tribalawards voting is now online. Get over there and get it done.
I honestly don’t care who you vote for...

Android is better than iOS

Not in many ways, and certainly not in enough for me to stick with Android over iOS, but here are...

Assign SQL Service Account with Group Policy

How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy?
The answer...

Case-Sensitive Updates in a Case-Insensitive World

Assuming you're in a case-insensitive ("CI" in the collation name) column, this UPDATE statement:

UPDATE tablefoo
set foo = 'Z'
where foo = 'z'

will just...

Friday Followup For December 20, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...