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

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

SSRS or a Custom Web Form – Pros & Cons

In response to a post I made on an unrelated topic, a reader said "I’m not really a fan of...

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

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

Clearing Job Notifications - HELP!

I have inherited a SQL 2005 server with SQL Agent job notifications in place, and a request to clear the...

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

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

Introducing SQL Roundup

Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...

MDX SSRS Parameter Values

<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all...