Get Out There and Challenge Yourself

It’s been almost five months since I posted my last article, and so much has changed since then. I have...

TSQL Tuesday #63 – How do you manage security?

Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...

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