Low Power SQL Server Test Lab on Windows Server 8 Hyper-V / ESXi5

Windows Server 8 Beta is released, if you are looking to build a low cost, Low power PC which can...

Goodbye Microsoft, Hello World

Goodbye Microsoft, Hello World
Goodbye Microsoft, Hello World

The cowboy’s job is done here, and it’s time for him to move on...

Extract CLR Assemblies from SQL Server

I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to do a comparison between two versions to make sure...

Extract CLR Assemblies from SQL Server

I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to...

Running a script on multiple servers

 One of my favorite features of SQL Server Management Studio (SSMS) is the ability to run a script on multiple...

Want to write for Microsoft?

Edit: The group I’m speaking to is the Content Team, not the Books Online (BOL) team!
Edit: Updated with FAQs and...

Re-blog – February 24 – March 1

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

SQL Server 2012 (“Denali”): Database Recovery Advisor

Database Recovery Advisor is a new feature in SQL Server 2012 that introduces significant user experience enhancements to the ways DBAs...

A Script A Day - Day 29 - The Importance of Being Idle

Today’s script is also one I used in my migration on Wednesday.  It again uses string manipulation to generate a...

A Script A Day - Day 28 - String Manipulation

Today’s script is one that I used earlier this week.  On Thursday I migrated a server from SQL Server 200...