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

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

Fun with dates

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

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

Reblog: February 8 to February 14

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

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