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

Importance of Best Practices in database programming

For any programming language, just writing the code is not well enough. It should be written using the best practices. This article will try to explain the disadvantages of...

Importance of Best Practices in database programming

For any programming language, just writing the code is not well enough. It should be written using the best practices....

Outlier Detection with SQL Server, part 3.4: Dixon’s Q-Test

By Steve Bolton
…………In the last three installments of this amateur series of mistutorials on finding outliers using SQL Server, we...