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 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...

MVP 2016!!!

Dear All,

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

Professional SSRS 2016 Book Preview Posts

This page is a table of contents for for several new and forthcoming posts.  I’m posting a series of excerpts...

Adding Application Name to Invoke-SqlCmd2

In a previous post, I expressed some frustration over Invoke-SqlCmd not setting an Application Name for its ODBC connection, leaving us with the generic .NET SqlClient Library when looking at active sessions...

Easy Database Space with dbatools

One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is...

Friday Reading 2017-01-20

Been an interesting week! My site has had the most views ever (so chuffed) and during all that I’ve been...