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....
2019-02-27
251 reads
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...
2019-02-27
2,501 reads
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...
2019-02-27
429 reads
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...
2019-02-26
1,047 reads
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...
2019-02-26
853 reads
Workload analysis with WorkloadTools
Last week I introduced WorkloadTools and promised additional posts to describe what it can do in more detail. So, here...
2019-02-26
594 reads
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....
2019-02-26
889 reads
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...
2019-02-26
247 reads
Cool Stuff in Snowflake – Part 7: Creating Tables
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough...
2019-02-26
100 reads
Database context and compatibility level
To add onto yesterday’s post about which cardinality estimator (CE) your query will use, there’s an additional complexity. This specifically...
2019-02-26
836 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers