Yesterday at SQLSaturday #407 in Vancouver, I announced availability of a free tool to synchronise and restore your SQL Server backups using Azure Blob Storage. It can work alongside your existing backup process, and leverages… Announcing Azure Blob Storage Sync and Restore
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… Pre-Announcement Announcement
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… SQLSaturday #407 in Vancouver
Steve Stedman has been running a contest over on his site, the Database Corruption Challenge, which I discovered last week quite by chance through Twitter. Not to brag, but I’ve been the fastest to solve… Database Corruption Challenge
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.Loyalty can be bought
This is the final entry in my #SQLNewBlogger challenge. You can read the previous entries here: Part 1: The Intersection of Art and Science Part 2: The Art of Improvisation Part 3: What Motivates You?… Total Recall
In this, the third part of my series on the intersection of art and science, I hit that crossroad. I can cross over into the creative, art side, where this post has been written, or… What motivates you?
This is the second post in my four part series for the #SQLNewBlogger Challenge. You can read the first part here. On Saturday, 28 March 2015, I moved three servers and various networking equipment from… The Art of Improvisation
This is the first post in a series of four, where Ed Leighton-Dick, via Brent Ozar, is proposing that we SQL Server folks participate in the #SQLNewBlogger Challenge. I write a fair number of words… The Intersection of Art and Science
Your production environment needs Date and Number tables, to help you Get Stuff Done in sets instead of RBAR*. Doug Lane has a video on Why You Simply Must Have a Date Table. I really… Do it now: Date and Number tables
Today we went live with a product we’ve been working on for A Long Time, in which a team of five has put in A Lot Of Work. During the walk-through with the customer, loading… Assumption Sandwich
I’ve been privileged to attend the 2014 Summit in Seattle this year, which has been a great experience thus far. More importantly, I’ve been speaking to the members of the SQL Server family, getting to… SQL PASS Summit 2014
I was perusing the headers of some databases on my SQL Server 2012 instance, and came across an interesting typo after running DBCC DBINFO: dbi_ContianmentState In my CTP of SQL Server 2014, it has been… dbi_ContianmentState
Five months from now, Microsoft will stop supporting Windows XP. As Tim Rains points out, running Windows XP after this date will effectively be an open invitation for attack. XP will, in his words, be… End of Life for Microsoft Windows XP and Server 2003: Six-One or Up