A Script A Day - Day 22 - Database Backup

Today’s script follows on from Day 16’s script which was about database restores.  In a backwards way the script is...

A Script A Day - Day 21 - The HAVING Clause

Today’s post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is...

Trello: An agile style kan-ban web app that really works

I am no different to many others where I am being asked to work on various projects concurrently and expected...

High Availability 9's

This is very important to understand what is high availability 9's, This is a measurement of high availability  where you can tell...

Detect Worst Performing SQL Queries - Part 3

Detect Worst Performing SQL Queries - Part 3

Detect Worst Performing SQL Queries - Part 3

Detect Worst Performing SQL Queries - Part 3

Detect Worst Performing SQL Queries – Part 3

Best way to tune production server is to find out what are the queries executed in a particular duration and...

New Article: Exploiting SQL Server via CONTROL SERVER permissions

I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...