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

Backup Deployed Sessions

There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth...

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

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

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

Updating a view

I was recently asked how to update views. Specifically the question was about using triggers to update a view.
So...

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