POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!

UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11...

The most recent backup problem

When I first began this blog, back at the beginning of my DBA career, it was purely a place for...

Parsing SQL Saturday Data – Getting the Titles

I wrote about downloading the SQL Saturday data with Powershell, and that has worked well. However, I also need to...

PowerPoint Slides Available for Download

I promised that I would post the slide decks for my presentations, and now I have finally followed through on...

Blame it on Connect

Some weeks ago I blogged about the discouraging signals coming from Connect and my post started a discussion that didn’t...

T-SQL – Query to get Distinct,Sorted, Comma Separated values in to a variable

CREATE TABLE #temp(name char(3))

INSERT INTO #temp VALUES ('CD')
,('AB')
,('LM')
,('BC')
,('GH')
,('KJ')
,('AB')

DECLARE @cols AS NVARCHAR(MAX);

SELECT @COLS = substring(list, 1, len(list) - 1)
FROM (SELECT list =
(SELECT DISTINCT...

How to Rebuild MSDB database?

I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then...

How to Rebuild MSDB database?

I suggest to have regular full backup of your system database along with user database. But if you do not...

Mentor blog

I have been following a few blogs for a number of years now, and one of the most enjoying blog...

Uploading a Source Folder to Azure File Storage

Azure File Storage enables you to present an Azure Storage Account to your IaaS VMs as a share using SMB....