Starting with Chocolatey

I ran across Chocolatey years ago when Scott Hanselman wrote about it in his power tool list. At the time,...

Moving to WordPress.com

For years I’ve hosted WordPress somewhere, most recently in Azure using Project Nami so that I could store all the...

Columnstore Indexes – part 95 (“Basic Query Patterns”)

Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In this blog post I am continuing...

Checking Permissions for Keys–#SQLNewBlogger

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

Columnstore Indexes – part 94 (“Use Partitioning Wisely”)

Continuation from the previous 93 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post will talk about some...

Data Channel - Interview 02 - Hamid Fard on SQL Server Memory Capacity Planning

Dear All,

Welcome to the second interview of Data Channel. Very happy and proud to have Mr Hamid Fard, MVP and...

Friday Reading 2017-01-06

Happy New Year to all of you out there! I know, I know it’s a week late but hey I’ve...

New String Function – TRIM – in SQL Server vNext

As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...

Refreshing the SQL Server PowerShell Provider

Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same...

Refreshing the SQL Server PowerShell Provider

Sometimes SSMS gives you stale results and there you have the Refresh button to fix that. In SQL PowerShell, the same situation can arise where the SQL Server PowerShell...