No thrills about spills

Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a...

Simple Merges KDiff3 at SQL in the City

One of the hassles of working in a development team is that you will have conflicts between your code and...

XML Attribute VS Element Assignment when working with SQL

XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...

Speaking at SQLSaturday #446, Oregon 2015

I have spoken a number of times at different SQLSaturdays around the world, including some rather rare editions, such as...

Predicates and Event Data

A predicate is a filtering mechanism used in SQL Server to target specific data when either querying or updating rows.
Related Posts:

Short Circuiting Your Session January 5, 2019

How To:...

Predicates and Event Data

At one time or another, a predicate has been the best friend or worst enemy of the data professional. If...

Where is my data stored?

Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...

Where is my data stored?

Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...

Zombie AD Groups

I spent something like 2 hours today trying to figure out how a particular user had access to one of...

Why I hate Pie Charts

The pie chart should be avoided at all costs. Why?
you can only display a limited number of slices (although that...