Resource Governor in SQL Server – Workload Throttling

Resource Governor in SQL Server provides CPU, Memory and I/O throttling. In SQL Server 2014 and earlier, CPU throttling works only for similar kind of workloads and not for...

Data Compression in SQL Server – Pros and Cons

SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...

SQL Server Command Timeout – Application Timeout – Attention

When you use ODBC or SqlClient to access data from SQL Server, by default the query will be cancelled if there is no response from the server within a...

SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour

My Best Blog Posts from 2015

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...

My Best Blog Posts from 2015

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour

Universal SQL Installations Framework (Script review and Demo)

House Price Predictions @ PASS 2015

The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...