Columnstore Indexes – part 99 (“Merge”)

Continuation from the previous 98 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focused on the...

Friday Reading 2017-02-24

Wow that week absolutely flew by! Here’s what I’ve been reading…
Seatbelt learning with Uncle Buck

Buck Woody goes through how he...

Improve performance by replacing temp tables with memory optimized tables - Part 3

Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/08/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-2/).

Previously we...

Permanent Employment v Contracting: How the figures stack up

In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over...

Adding a T-SQL Job Step to a SQL Agent Job with PowerShell

In my last post, I explained how to alter an existing job step across many servers. I also had cause...

Confusion of An Old Technologist

As someone who still actively pursues a career in technology, I’m a little on the older side. I got started...

Database Security Webinar Today (Feb 23)

Today at 3 PM EST I’m giving a webinar on designing a successful database security model with SQL Server.
Register Here for...

External SQL files vs. Stored procedures in SSIS development

[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions...

SQL Server 2016: The Coolest New Feature – Live Query Stats

This is the first in a series of blog posts about how great SQL Server 2016 is, and why you should...

Upcoming PASS Events

There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me...