Things You Can Find In The Plan Cache

Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server...

Vote of our next SSIS Webinar

Our sessions were not chosen for neither SQLSaturday nor SQLBits but if you were interested; nothing is lost as now...

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