Easy to read CHECKDB

If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC...

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

A Better Way to Execute SSIS Packages with T-SQL

There are several ways to execute SSIS packages that have been deployed to the SSIS catalog, and my favorite way...

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

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

Bree's first blog post... Amazing training deals

Gethyn will be getting me to update this every week, there are some awesome training deals available for £750 + VAT....

A DBA’s Developer Experience and After-Thoughts

After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a...

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

Data Channel - Launch

Dear All,

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