Synchronous vs Asynchronous

You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we...

Reading a SharePoint 2007 List from SSIS 2016

It's been a while, but since I now get to play with SQL 2016 full time, I have new things to talk about!  One of major difficulties that any technology...

Reading a SharePoint 2007 List from SSIS 2016

It's been a while, but since I now get to play with SQL 2016 full time, I have new things...

Seattle SQL Pro Workshop 2016

Free workshop on SQL Server leading up to Summit 2016 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:

Seattle SQL Pro Workshop...

Seattle SQL Pro Workshop 2016

Seattle SQL Pro Workshop 2016
You may be aware of an event that some friends and I are putting together during...

Query Store – Part 2 - Configuration Settings

Introduction to Query Store covered here.
Now for the second part on “How to Configure?”

Query Store is configured at the...

Master Data Services error – Cannot read configuration file due to insufficient permissions

In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...

How DATEDIFF_BIG a new feature of SQL SERVER 2016 Can Keep You Out of Trouble

In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and...

Columnstore Indexes – part 88 (“Minimal Logging in SQL Server 2016”)

Continuation from the previous 87 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Getting Data into the Database is one...

Fixing Untrusted Foreign Key or Check Constraint

Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.If...