Name the schema when you create an object (or else)

This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...

SSIS Trick: Adding Multiple Packages to a Project

A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing...

TSQL– Search for Strings in Object Definitions

I have been  working nn an environment  that had multiple copies of a database on the same SQL server instance....

Tools of the trade

I’ve been meaning to write this post for a while now, nice and simple, just want to list the tools...

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

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...