Deleting a Package from the SSIS Catalog

Among the new features of SSIS 2016, one of my favorite is incremental package deployment. This new functionality allows the...

Fischer’s Exact Test – with T-SQL and R

This post is a long overdue second part to the post on Chi Square Test that I did a few months...

How to write an INSERT query

My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....

Implementing Fuzzy Sets in SQL Server, Part 10.2: Measuring Uncertainty in Evidence Theory

By Steve Bolton                                                                                                                      
…………To avoid overloading readers with too many concepts at once, I split my discussion of Dempster-Shafer Evidence...

SQL Server Parameter Sniffing In Depth

If you’ve ever searched for SQL Server parameter sniffing you’ve probably read all sorts of bad things about it. In...

Angular 2 FAQs

1. What is angular module?
NgModule helps to organize an application into organized blocks of functionality. @NgModule decorator takes metadata that...

Columnstore Indexes – part 106 (“Memory Requirements for Rebuild & Reorganize”)

Continuation from the previous 105 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
One of the most important and recurring...

Decrease Stored Proc Execution Time By Limiting the Table Size

Hi Guys,

Hope everyone is doing well. Last week, I was working on the most exciting task on which any database...

How I Became a...SQL Server DBA

Kevin Hill mentioned this idea/series on a SQL community slack channel back in April and I thought it would be a good way to get back to blogging. The timing...

How To Roll-Back Data in a Temporal Table

Watch this week's video on YouTube
So you've started using temporal tables because they make your point-in-time analysis queries super easy.
Your manager is happy because you're getting historical data to...