Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is a logical continuation...

DevOps Basics– git Cloning Repos

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

SQL Database File Wise Disk Space Monitoring

As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may...

2 Great Courses For Databases Professionals - Deal Of the Week

I received  the email from Learning Tree on Wednesday with their weekly offer of courses running in the London Education...

Book Review – The Truthful Art

I’m participating in the #vizBookClub, a great idea by the data visualization community. In short, we read a book about...

Resolution to “Connection Timeout Expired. [Pre-Login] initialization =18090; handshake=14281” error

This blog post is about a SQL Server connection issue that presents itself:

We were building an Availability Group (AG) at...

Microsoft Data Amp event announcements

Yesterday was the Microsoft Data Amp event where a bunch of very exciting announcements were made:
SQL Server vNext CTP 2.0...

What is SQL Server?

I’ve been playing around with YouTube, making some tutorial videos on SQL Server and it’s been a fun process so...

Thoughts about the Microsoft Data Amp Announcements

Microsoft conducted a live event called Microsoft Data Amp to announce a number of key features and releases for SQL...

Presenting 2 sessions @ SQLSaturday (Silicon Valley)

Apr 22nd I will be presenting “Re-Indexing – The quest of ultimate automation” & “Consolidated Essential Performance Health Check using PowerShell” @ SQLSaturday, Silicon...