Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason or another this query directive (yes I am calling it a directive* and not a […]
Tag: SQL Server
Ghosts – an eXtrasensory Experience
Really, at this point what is there that hasn’t been done about the ghosts? Well, if you are well tuned to these apparitions, you may have received the urge to explore them with Extended Events – sometimes called XE for short.
Database Ghosts
Recently you may have seen my first article on this topic over at SQL Solutions Group. If not, here is the link so you can read that article first before proceeding here. This article is […]
Microsoft, Me and the MVP
October 1st is one of the quarterly dates that Microsoft announces all of the new people into the MVP program. It is also a day in which Microsoft recognizes many already in the program and […]
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different forms, including a standing R2 cake one year for my birthday. So when I cam […]
MCM on Life Support
Good news everybody. October 1st is no longer the day that the MCM was prescribed to die. The Microsoft Certified Master is now on life support until December 31st, 2013. Which means that the Jan […]
Rare Species, Extinction and the MCM
As of 11:04 PM MST ( -6 UTC ), the Microsoft Certified Master along with the other certifications in the Advanced certification series at Microsoft joined the ranks of the Panda on the Rare and […]
Lost that Single-User Connection?
You have changed your database to single_user mode to do a task. As you go about your business, you lose track of which connection was the single_user connection. You start closing connections and mistakenly close […]
Lions and Tigers and Bears…
Last Thursday I found myself on a journey of sorts. There weren’t any lions or tigers or bears, but there were plenty of “Oh My”‘s. It all began on a dark and gloomy night. Well, […]
Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here. Granted, it has been a month and I still have been slacking. I am […]