Microsoft Certified Trainer!

For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...

Microsoft Certified Trainer!

For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...

SQL Azure Databases - Active Secondary - How to connect? - Part 2

As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to a azure SQL Database primary and secondary after...

SQL Azure Databases - Active Secondary - How to connect? - Part 2

As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to a azure SQL Database primary and secondary after...

Columnstore Indexes – part 105 (“Performance Counters”)

Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
For a very long time I was...

SQL Azure Databases - Active Secondary - How to connect? - Part 2

As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to...

Web API 2 Interview FAQs

Web API FAQs:

1.       What are the return types of Action methods in Web API?

a. Void:     If the return type is void, Web API...

Tuning Parallelism on SQL Server

Parallelism and MAXDOP
There’s no doubt that parallelism in SQL is a great thing. It enables large queries to share the...

Microsoft Professional Program in Data Science – The Road So Far

I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open...

Speaking at SQL Saturday Pensacola!

I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing schedule!
If you don’t know what SQLSaturday is, it’s a...