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

2017-08-16

722 reads

Ultrawide Monitor - Samsung CF971 - First impressions

by Sheldon Hull

Sheldon Hull

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

451 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,514 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

213 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,363 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

189 reads