COUNT, DISTINCT, and NULLs
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
11 reads
Bert Wagner
Parsing HTML in SQL Server
Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...
2019-02-12
5 reads
Parsing HTML in SQL Server
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few...
2019-02-12
2,268 reads
Parsing HTML in SQL Server
Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...
2019-02-12
4 reads
Why make?
This post is a response to this month's T-SQL Tuesday #111 prompt by Andy Leonard. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-02-12
3 reads
Why make?
This post is a response to this month's T-SQL Tuesday #111 prompt by Andy Leonard. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-02-12
3 reads
Optimizing for Ad Hoc Workloads
Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...
2019-02-07 (first published: 2019-01-22)
2,191 reads
Automating Database Maintenance with Jess Pomfret and dbatools
dbatools is one of the coolest community projects I’ve seen – it is amazing how many commands are available to help...
2019-02-05
199 reads
Automating Database Maintenance with Jess Pomfret and dbatools
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
4 reads
Automating Database Maintenance with Jess Pomfret and dbatools
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
5 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers