How to backup local SQL database and restore to Azure SQL database

Hi friends, recently I was finding a way on taking backup of local database and restore that database to Azure...

How to Change an Analysis Services Instance to Tabular Mode

One of my client accidentally set up an SQL Server Analysis Services in multi-dimensional mode instead of Tabular mode. In this...

Monday Coffee 2016-11-28

MCSA SQL Server 2016
The new SQL 2016 MCSA exams are out and joy of joys, the DBA path no longer...

Notes From SQLSaturday Orlando 2016

This year we held our 10th SQLSaturday, a very nice milestone to hit. I’ll reflect in a separate post on...

Query Data Store Data

The data in the Query Data Store is what makes all the magic happen. From collecting the aggregate performance metrics...

Reload a table quickly.

Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload....

Columnstore Indexes – part 92 (“Lobs”)

Continuation from the previous 91 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of the...

Why Do People Think Dynamic Data Masking is a Good Idea? - SQL SERVER 2016 #5

Data security is always one of the important points which can not be ignored. Nowadays if you are working for...

Change the Collation Setting for Clustered SQL Server 2014 Instance

One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are...

Data Channel - Launch

Dear All,

I am starting a YouTube channel for SQL Server and Microsoft Data Platform Technologies called "Data Channel". What this...