This post is not long enough to be a fully-fleshed out post on my technical blog, so I'm putting it here. Understanding Optimizer Timeout and how Complex queries can be Affected in SQL Server by Joseph Pilov is a worthy read if you're at all interested in how query plans are built.
(Originally posted on my technical blog.) For the last six months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind, which is hopefully going to culminate in an actual technical book that I can point to and say “Yes, that’s the name I invented … Continue reading SQL Server 2017 Administration Inside Out
(Originally posted on my SQL Server blog.) Next week, while blog posts are scheduled as expected, I will be attending my third PASS Summit. Summit 2014 In my first year, I attended every single event I could. The Monday night started with Steve Jones' regular Networking Dinner. When I arrived, there were already over a hundred people there, … Continue reading What to do at PASS Summit 2016
I've been remiss in keeping my followers up to date on what's happening this year. In the beginning of the year I worked on a student film called Joy To The World, in which I played the boss of a Mall Santa agency, which refuses to hire the actual Santa Claus, because his résumé isn't … Continue reading Theatre, film, web series and voice acting updates
This post was originally published on my SQL Server blog. I worked on four films in 2015, three shorts and one feature-length movie, all shot in Calgary where I live. That has resulted in seven IMDb credits for me, someone who earns a living as a DBA. If nothing else, that experience has scratched an … Continue reading Filmmaking as a Metaphor for the DBA
As of last Saturday, I'm now on the conference circuit as a speaker. It feels really weird to say that, because it was thrilling and terrifying at the same time. This was the room I spoke to (photos taken during setup, which is why it's empty). This all started because Argenis Fernandez (twitter | blog) … Continue reading I’m a presenter now
Normally I like to keep my SQL Server blog separate to my personal one, but this is too good not to share. I've been selected to speak at SQLSaturday in Vancouver, on 27 June 2015. My topic is related to Azure Blob Storage and restoring SQL Server backups. More information will follow. Stay tuned!
I'm taking the plunge to write all five SQL Server 2012 exams that are currently available, on my track to obtain the MCSM qualification (previously known as MCM, or Microsoft Certified Master). By going public with my plan, I hope to motivate myself to spend some time preparing properly for it. But in true Randolph … Continue reading SQL Server 2012 Exams
For the next two weeks, I'll be spending time with the SQLskills.com gang again, this time for IEDev and IE4. It's all very exciting! The hotel has even put me on the ground floor so that I don't have any stairs to contend with.
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 thought this would be useful information to share. I answered with a link to the original run book I have … Continue reading Where do I start with a Run Book?