‘Twas 4:45 Friday

‘Twas 4:45 Friday, and all through the office

not a creature was stirring, not even the bosses.

The code was checked in,...

Load Balanced IIS Machines

I noticed a contest this week while working on the Database Weekly newsletter. It’s the Cloud Hero contest, with the...

WordPress, Project NAMI, and Azure

I’ve been running WordPress for years now and find it to be a solid solution for what I want to...

ROW_NUMBER SQL Server

Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL.  One of these is the Row_Number()...

SQL Server Developer Tips that Can Save Your XXX

Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for...

RegEx Those Dates

Recently I was working on transforming some dates, and wanted to generate a large n number of dates for testing....

Transaction Isolation Level Blues

Have you ever had a mental block in one particular area when learning something? It might be the simplest thing,...

Last Weeks Top “Reading” Links #113

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Why You Should Benchmark Your Storage

You should benchmark your storage immediately. If you are a database administrator, you should benchmark it yesterday. And today. And...

Create a clustered index and a primary key on existing tables

It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes...