Script Out Foreign Keys With Multiple Keys

It's easy enough to use sys.foreign_keys and sys.foreign_key_columns to identify foreign keys.  But what if you want to script out your foreign...

SQL Server Naming Standards

Want to start a fight between a bunch of DBAs or database developers? Ask them where the comma should be...

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