We all crave routine in our life, from the time we are babies through adulthood. Routine and familiarity. This extends to how we do performance monitoring and troubleshooting. Everyone has their favorite set of tools to help get the job done, tools that have a familiar routine involved to make them work best for us. Over the … Read more
I’ve witnessed many novice administrators make the common mistake of believing that the SQL Server upgrade process for a database server is as easy as pressing a few buttons.
Recently it was brought to my attention that the query_hash and query_plan_hash columns inside of sys.dm_exec_requests were returning NULL values. I think everyone knows how I feel about NULLs already, but this was slightly more concerning. See, I work for a company that makes this wonderful tool called Database Performance Analyzer (DPA), and we rely … Read more
I like having a routine. Most people do, I suppose. There’s some comfort in knowing what lies ahead, what comes next. The same holds true for restoring the master database in SQL Server 2014, because it’s the same routine as what I posted for SQL Server 2012. For those of you too lazy to click … Read more
Last week during TechEd North America Microsoft announced that SQL Server 2014 was coming…soon-ish. No release date has been set as of yet, and we have been told we *may* expect a preview in the next few weeks. Click here to be notified when the bits are ready. I’m very excited to get my hands … Read more
