Estimating Memory Requirements in SQL Server 2014

Estimating Memory Requirements in SQL Server 2014

SQL Server 2014 has a lot of shiny new features. One of the brightest is In-Memory OLTP Hekaton, something I have been optimistic about (get the pun?) ever since I saw it at the PASS Summit in 2012. These days there is no shortage of information available to day regarding how Hekaton is full of(…)

Microsoft Azure SQL Database Data Compression

Microsoft Azure SQL Database Data Compression

Back in March there was an announcement that data compression was available for Microsoft Azure SQL Database (MASD). This was met with much rejoicing. You can read more about the announcement here. Oh, wait…that’s right…Microsoft pulled the announcement back for some reason. Three months later, and I still don’t see an announcement regarding data compression.(…)

Performance Metrics for SQL Server 2014

Performance Metrics for SQL Server 2014

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(…)

Upgrading to SQL Server 2014: A Dozen Things to Check

Upgrading to SQL Server 2014: A Dozen Things to Check

Here we go again! It seems that it was only yesterday we were talking about all the things you want to look out for when upgrading to SQL Server 2012. Now, just two years since SQL Server 2012 was released, we have a shiny new version with SQL Server 2014. And that means, of course,(…)

What’s Worse Than a NULL? An Incorrect NULL

What’s Worse Than a NULL? An Incorrect NULL

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(…)

Load More