Stashing Data for dbatools

While working on an enhancement to dbatools, I had a need to stash a local copy of a file downloaded from the internet, but in a safe place that...

Analysis Services Series on SQLShack

Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document...

Columnstore Indexes – part 109 (“Trivial Plans in SQL Server 2017”)

Continuation from the previous 108 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Do you remember one of the major...

I’m speaking: SQL Saturday Orlando (Oct 7th 17)

It’s been a while since I’ve done a SQL Saturday and I’m happy to be joining the folks in Orlando...

Microsoft presents: MySQL and PostgreSQL?

For the longest time, MySQL has been the recommended database platform for blogs and other websites. It’s free. It’s available...

SQL Server – So you like to shrink do you?

If you do – shame on you and shame on me because I do.

Moving on, I found strange behaviour within SQL...

SQL Server on Linux Series: Moving TempDB

In the last blog post, we added additional drives to the SQL Server machine so that we can scale out...

SQLCLR vs. SQL Server 2017, Part 3: “CLR strict security” – Solution 2

Welcome back, everyone. In the previous post in this series, I explained how to work within the new SQLCLR security...

“Does that copy subscriptions too?” – Now it does! New PowerShell SSRS commands

On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the...

Always Encrypted with Azure Key Vault

I recently wrote a post about using Transparent Data Encryption (TDE) with Azure Key Vault as an alternative to managing certificates. Today’s post will explore using SQL Server’s Always...