Columnstore Indexes – part 112 (“Linked Servers”)

Continuation from the previous 111 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the Server...

Multi Script Removes 25 Database Limit

I woke up to a Slack message that alerted me to a post in one of our channels. An engineer...

Come See Me in Minnesota in October!

The schedule for SQL Saturday #682 Minnesota 2017 is out, and I will be giving my talk on Extended Events:

--
Getting...

Running for the PASS Board of Directors #PASSelections

This year I decided to take “someday” to heart and do something that has been on my mind for awhile...

Twilight Timezone: Date and Time Architecture in your Applications aka Use DateTimeOffset, Your Future Self Thanks You

Thanks to everyone at a joint meeting of the Baton Rouge .NET and SQL Server User Groups who joined my...

Azure SQL Database Resumable Online Index Rebuild

If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...

Help! My query is too fast!

Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of...

Microsoft Azure – How to check the available extensions for a virtual machine using Windows PowerShell

Hello friends, Please find the link of my new article – https://social.technet.microsoft.com/wiki/contents/articles/40102.microsoft-azure-how-to-check-the-available-extensions-for-a-virtual-machine-using-powershell.aspx

[PowerShell] From 20 minutes to 20 seconds - Change domain user password on multiple domains without login into each one

I’m working on a environment where I have to deal with multiple domains. The user’s password needs to be updated each 40/45 days (it depends on the domain).
Because I...

A trillion and one

Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in...