Here Come New Ideas for DROP IF EXISTS in SQL SERVER

In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a...

Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014

A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of...

Thursday Night Networking Dinner Meetup at Summit 2016

This year PASS announced that Thursday night would be an open night at the PASS Summit, with no events scheduled....

Searching SQL Servers & Saving Results, with Write-SqlTableData

The other day I was chatting with my friend Tom Roush ( B | T ) and he mentioned needing to scan every database on every SQL Server instance...

Searching SQL Servers & Saving Results, with Write-SqlTableData

Just a quick blog today to show you something which is possible with a handful of lines of code. I...

Mastering Index – Unique Index

This article is the part of series Mastering Index, in this particular article we will be exploring Unique Index. Take a...

What’s new in SSRS 2016 – Session Contents

The 2016 edition of the Belgian SQL Server Days is over. It was a blast – as usual – and it was...

Control Flow Package Parts in SSIS 2016

Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server Integration Services packages.  The intent is great, but like...

Control Flow Package Parts in SSIS 2016

Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server...

In-memory tables in 60 seconds

As a SQL Server DBA or developer here is what you should know about memory-optimized tables (in-memory tables):

Introduced in SQL Server 2014
Primary store is main memory, second copy maintained on...