Building My Next Workstation–Part 1

It’s been four years – maybe more – since I last bought a workstation to use for development and lab work. It’s...

Get Data Warehouse Training and Help a Neat School

If you're located relatively near the Atlanta, Georgia area, I wanted to bring your attention to data warehousing training on...

Configuring PerformancePoint Data Source for Time Intelligence

PerformancePoint provides functionality to map several time dimensions across multiple data sources to a ‘Master Time Dimension’.  Data sources that...

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

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