Skip to content

Data Efficiency in SQL Server: DATETIME

This is the first in a short series of posts about how I assign efficient data types when designing a new table or database. Use less space with DATETIME2 We all know that the DATETIME column… 

Lazy Loading and Tries

  • by

This post has nothing to do with SQL Server, but if you like performance tuning, stick around. I learn technology by using it, pushing it to its limits, finding out how it breaks. I jokingly… 

Update to Azure Blob Storage Sync and Restore

  • by

Blob Storage Sync tool updated During a SQL Server migration this month, I found some inconsistencies in my Azure Blob Storage Sync tool, so I made several improvements, and fixed an outstanding bug. As you… 

Survey: Light or Dark

  • by

This week I am continuing with the simple survey series. Today my question is, do you prefer using a dark or light background when writing code? I like a light background with dark text (usually… 

Survey: Tabs or Spaces

  • by

This is my second survey for the month of December. Last week I asked about join predicate order. This week, it’s a simple question: Do you prefer tabs or spaces to indent your T-SQL, and… 

Pre-Announcement Announcement

On Saturday, 27 June 2015, I will be presenting at SQLSaturday #407 in Vancouver BC. The session is titled “Restoring a SQL Server Database from Azure Blob Storage”. I will be releasing some new content… 

SQLSaturday #407 in Vancouver

I have been selected to speak at SQLSaturday #407 in Vancouver, on 27 June 2015. My topic is about restoring SQL Server backups from Azure Blob Storage, and how to make this process easier (and… 

Loyalty can be bought

This piece was originally written some years ago, and never published. It is a report and analysis of the largest project I had worked on as a developer / DBA up to that point in my career. I have published it here for any of you who are interested.

sharpened pencil resting on a notebook

Where Do I Start With A Run Book?

  • by

On SuperUser.com, a question came up about how to do a proper Linux backup, including the applications installed, and associated configurations. In light of a previous post I wrote about backups and run books, I… 

My brain hurts

Kimberly Tripp has a very neat series of stored procedures on her blog which are rewrites of sp_helpindex. Unfortunately for those of us with customers still using SQL Server 2000, these scripts are useless, because…