DR drill - Part 2: Log Shipping

Welcome back to DR drill series!

In the last post (here), we have highlighted a number of ways to setup disaster...

Columnstore Indexes – part 67 (“Clustered Columstore Isolation Levels & Transactional Locking”)

Continuation from the previous 66 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing from the last couple of blog...

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