Scaling Azure VM’s

There are so many benefits to the cloud, but one of the major features is the ease of use in...

SQL Server PerfMon Counters Not Listed in dm_os_performance_counters

Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older...

SQL Server Service Broker – Conversation Architecture

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...

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

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected...

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

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them...

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

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

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

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

Views and Simplification

I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to...