Cumulative Update – 5 for SQL Server 2014 RTM Is Now Available !

The 5th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site....

Monitoring Geo-Replication in SQL Azure using DMV's

Monitoring Geo-Replication in SQL Azure using DMV's
DECEMBER 26, 2014

Azure SQL Database comes with a host of disaster recovery options. The most robust of these options involves replicating the database...

Monitoring Geo-Replication in SQL Azure using DMV's

Monitoring Geo-Replication in SQL Azure using DMV'sDECEMBER 26, 2014Azure SQL Database comes with a host of disaster recovery options. The...

Dev Tools: XYplorer (review #1) - Catalog.1

currently on version 14.60
I'm a big fan of finding tools that help automate and streamline things that should are routine...

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

PowerPivot Saga 2: DAX OR function (OR there is something better)

I didn't realize that the DAX OR function only accepts 2 arguments compared with the similar function in Excel where a limit of...

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

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

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