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

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

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

Working with the registry from within SQL Server

There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...

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

Creating an SSIS project

Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open...

SQL Server vs Oracle: How to replace NULL values

It’s Wednesday and that means another SQL/Oracle post. Today we’ll be discussing NULL Values, which can sometimes be a real...

Attaching databases via a dockerfile

Last week I presented my session on SQL Server & Containers for the PASS Virtualization Group and during my prep I...

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