Power BI Subscriptions

Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in...

SQL Server 2016: JSON integration

Abstract
This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable...

Useful #SQLPrompt Tips

One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I’m constantly impressed...

Using Extended Events Telemetry Session

You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session...

What Is Your Career Investment Portfolio?

Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes...

Columnstore Indexes – part 96 (“Nonclustered Columnstore Index Online Rebuild”)

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

CREATE DATABASE – I’ve not seen that before.

TweetG’day,
It’s been a while
I thought that I’d make a quick blog post about an incident that I encountered today...

MVP 2016!!!

Dear All,

Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions...

MVP 2016!!!

Dear All,Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions to SQL Server Community in 2016!!!. This is an...

MVP 2016!!!

Dear All,Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions to SQL Server Community in 2016!!!. This is an...