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

Simplified Session Backups

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

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

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

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

Indexed views on any core SQL server edition-The video

A few months back I created a blog post showing that you can indeed create and use indexed views on...

Indexed views on any core SQL server edition-The video

A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to...

Indexed views on any core SQL server edition–The video

A few months back I created a blog post showing that you can indeed create and use indexed views on...