Bin the unwanted to reap the rewards !

Looking through some of my databases this past week, theres a lot of data there which over time has become...

Mix & Match – Day 1

I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...

T-SQL Tuesday #008: Gettin’ Schooled

 T-SQL Tuesday #008: Gettin’ Schooled

“Thank you fans and friends & odds and ends. And now for you gals and guys, a...

A Special Belated Happy Canada Day to Leader of the Official Opposition

 
Dearest Michael Ignatieff, Leader of the Liberal Party of Canada, Official Leader of the Opposition,
First of all, 'appy appy Birthday...

Database Configuration Checklist

This is number four in a series of checklists that I am putting together for a new book I am...

Extracurricular Activities

Extracurricular Activities
Recently I presented two sessions at SQL Saturday #43 in Redmond, WA. The night prior to the event, many...

PAL 2.0 Beta Released

Back in 2008, I wrote a blog post about version 1 of the Performance Analysis of Logs (PAL) tool. This...

SQL Blog (Basic)

1. SQL Objects
a. Stored Procedures : a bunch of SQL statement which can be stored under one name.
Adventages :
can be used...

Taking Time Off

I’m trying to better manage my workload. When I owned this site, I struggled to find time off, and typically...

The Raw Bloopers

A raw dump of stuff from Memorial Day 2010 until July 4, 2010
Since Community Server has trouble with this,...