Attending PASS Summit? Take a great Tuesday precon!

We’re just two weeks away from the PASS Summit in Seattle,  and there is most definitely still time to get...

Argenis Without Borders: Fun For a Good Cause

This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we...

Thank You for Attending my #SQLSatOrlando Session! Slides, Resources, Recording

SQL Saturday #442 in Orlando, FL has come and gone but what a turn out! The event was excellent, we...

Simplified Session Backups

I have demonstrated how to backup a deployed session to a script previously. In this article I demonstrate how to create Simplified Session Backups.
Related Posts:

PowerShell to Backup XE Session...

Simplified Session Backups

PowerShell exposes scads of information and provides the professional with a formidable tool for the tool-belt. Over the past several...

How to create a database on a network share

If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...

How to create a database on a network share

If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...

How to create a database on a network share

If for any reason you need to place the database on a network share and by default this option is...

Columnstore Indexes – part 68 (“Data Loading, Delta-Stores & Vertipaq Compression Optimisation”)

Continuation from the previous 67 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on some...

Hekaton Part 8 - Hash Collisions - Hash_Index_Stats DMV

Continuing from previous post , this post will discuss a few scenarios on hash collisions.
 The following "in memory" table with a hash...