Webcast “Value of Performing Wait Analysis” This Week with Pragmatic Works

Ever have your SQL Server slow down for reasons that you can’t explain?  Or did you spend all night tuning...

A Month of PowerShell – Day 17 (Databases: Views)

Welcome to Day 17 of my “A Month of PowerShell” series. This series will use the series landing page on...

A year of SQL Lunchs

Time does fly, and happy birthday SQL Lunch UK.

It has been a year since the first SQLLunch UK, and over...

Fun with dates

Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it...

Inserting Binary Data

There are a number of articles on dealing with the insertion of binary data into SQL Server using BULK INSERT,...

Using Foreign Keys to Determine Table Insertion Order

Here's a script to determine, based on your database's foreign key relationships, what the insertion order would be for, say,...

A Month of PowerShell – Day 16 (Databases: Triggers)

Welcome to Day 16 of my “A Month of PowerShell” series. This series will use the series landing page on...

I’m dropping the book project

Update:
This book project got its second life. I am now collaborating with another author to bring this book to completion....

23 Pieces of News and Fluffery (Feb 9-15)

I have a news segment on DBAs@Midnight (our live weekly webshow, tune in tonight at 11pm Central time), but there’s...

A Month of PowerShell – Day 15 (Databases: Adding Foreign Keys)

Welcome to Day 15 of my “A Month of PowerShell” series. This series will use the series landing page on...