Jun 18 2010
Last week while I at TechEd I had a conversation with one of my Application Analysts back in the shop about a problem database from an ISV that we have been dealing with for over a month. A patch had been put in place and I was reviewing the results of some queries against the sys.dm_os_wait_stats [...]
Jun 8 2010
My Magic On Whiteboard Greetings from New Orleans: where the air is thick with edumacation inside the convention center and just plain thick outside. I’ll confirm for you that this is the perfect place to hold a technical conference. No one wishes to go outside in this weather. As is usually the case [...]
May 14 2010
Paul Randal recently streaked through the the family picnic and tossed-down a hornet’s nest on the dessert table by starting a meme on which five things Microsoft should drop from their SQL Server product. I came to this party late – and uninvited – but I’m going to go ahead and drop my junk in [...]
May 6 2010
Paul Randal identified an issue in the SQL Server Missing Index DMVs (pre-SQL 2008R2) wherein they will, under the right wrong circumstances, recommend indexes that do already exist. This means that either missing is a subjective term or there is a bug in SQL Server 2005 and 2008. With the right people involved a great idea [...]
May 3 2010
That’s right. We’re on a boat and Autotune is forbidden. So is Auto_Growth. But SQLCruise? What is SQLCruise? Is it a SQL Saturday afterparty? Is it a Tweet-up at sea? Is it a new training event unlike anything else that you’ve ever heard of? Kind of, sort of, and oh yes indeed! SQL Saturday [...]
Apr 27 2010
The MidnightDBA (web|twitter) version of phone sex involves dental floss. If you mention that you’ve never used Powershell Aaron Nelson (web|twitter) will offer to purchase, mix, and deliver to your door any and all Powershell Kool-Aid necessary to get you to drink. Allen White (web|twitter) is now on Twitter. (Also note this occurred just in time [...]
Apr 23 2010
I give you exhibit A: The Last Straw: Yes, Third Party Software vendors out there are still trying to ruffie our SQL Servers. I encountered these instructions yesterday when reviewing a pending installation process. What you don’t see here though are items 1-11 in their instructions (one being a requirement for [...]
Apr 20 2010
Jason Strate (Web|Twitter) sings like the worst drunken office Santa ever William Shatner; dances like Seth Rogan after a debilitating and permanent head injury Dr. Stephen Hawking. Unfortunately Jes Borland (Web|Twitter) gets caught in the crossfire. Companies still continue to make money selling products developed on 32-bit Windows, running 32-bit SQL Server 2005. Some software [...]
