SQLSaturday#380 NYC Event Update - Precons, Speakers....

Just wanted to blog a quick update on SQLSaturday#380 in NYC, happening on May 30, 2015.  As you are hanging...

Tracing call stacks in SQL Server – Introduction

At this fall’s SQLIntersection conference in Las Vegas I attended, Paul Randal’s (t|b)“Performance Troubleshooting Using Latches and Waits” precon. Where at he asked for some assistance compiling data for a...

Tracing call stacks in SQL Server – Introduction

At this fall’s SQLIntersection conference in Las Vegas I attended, Paul Randal’s (t|b)“Performance Troubleshooting Using Latches and Waits” precon. Where at...

WordPress, Project NAMI, and Azure

I’ve been running WordPress for years now and find it to be a solid solution for what I want to...

Playing with the log – VLF order while growing the log

The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...

SQL – How to Find Missing Sequence in a table

Problem statement:-
 A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted?
Download code...

SSIS #118–Is it an OLEDB or an SMO Server Connection?

OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every...

Twas 2 Days Before Xmas or Thank you SQLFamily

Twas 2 days before Xmas & all through the office,

not a creature was stirring not even old Maurice.

With merriment going on...

Blink – Year is gone

As the door begins to knock I start to wonder who it can be. As I begin to open it...

Formatting Durations in SSAS: Caveat

I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read...