Proposed SQL Server defaults: disable priority boost

A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...

Dem queries

Dem queries, dem queries, dem slow queries,

Dem queries, dem queries, dem fast queries,

Dem queries, dem queries, dem big queries,

Now write...

Editorial – Dealing with Ugly Babies

One thing I learned while working as a database administrator over 17 years is the importance of teamwork across departments....

A short guide to sp_executesql

Last week I talked about single use plans. One way to increase execution plan re-use is to parameterize queries by...

Using Github as a repository for SQL Server Helm Charts

In a previous post I ran through how to create a custom SQL Server Helm chart.
Now that the chart has...

What Does the Undocumented UNCOMPRESS Function Do?

(last updated: 2019-02-26 @ 18:35 EST / 2019-02-26 @ 23:35 UTC )
IntelliSense in SQL Server Management Studio (SSMS) can be quite helpful. It...

Checking Progress of the Creation of your Azure Resources

When I’ve created resources in Azure it’s usually taken from a few minutes and up to quarter of an hour...

Workload analysis with WorkloadTools

Last week I introduced WorkloadTools and promised additional posts to describe what it can do in more detail. So, here...

The Reader’s Choice Awards are Taking Nominations

If you’re using products, you might want to nominate a vendor or product for a database tool that helps you....

Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO

In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...