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

Ultrawide Monitor - Samsung CF971 - First impressions

As a developer, I’ve been a big fan of multiple monitors for a long time. I moved to a triple...

How to Eliminate Ugly Nested REPLACE() Functions

Watch this week's video on YouTube
How many times have you had to transform some column value and ended up stacking several nested SQL REPLACE() functions like this?
-- Input: Red,...

Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL

This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script...

Automatic Sample Sizes for Statistics Updates

I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...