XQuery – Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t...

‘Twas 4:45 Friday

‘Twas 4:45 Friday, and all through the office

not a creature was stirring, not even the bosses.

The code was checked in,...

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

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

Transaction Isolation Level Blues

Have you ever had a mental block in one particular area when learning something? It might be the simplest thing,...

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

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

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

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