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

2017-08-15

269 reads

How to Eliminate Ugly Nested REPLACE() Functions

by Bert Wagner

Bert Wagner

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

2017-08-15

19 reads

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

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

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

2017-08-15

449 reads

Automatic Sample Sizes for Statistics Updates

by Matthew McGiffen

Matthew McGiffen DBA

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

2017-08-23 (first published: 2017-08-15)

1,511 reads

Bad Parameter Sniffing Decision Flow Chart

by Grant Fritchey

The Scary DBA

Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...

2017-08-15

210 reads

Bad Parameter Sniffing Decision Flow Chart

by Grant Fritchey

The Scary DBA

Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...

2017-08-24 (first published: 2017-08-15)

2,362 reads

Always Encrypted with Azure Key Vault

by Bradley-Schacht

Bradley Schacht

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

2017-08-15

187 reads