I was the principal author of this SIOS whitepaper, which describes how to build a 2-node SQL Server cluster in Google Cloud Platform (GCP) spanning multiple zones. Today, I’ll...
2024-11-13 (first published: 2024-10-29)
199 reads
I am able to head back to Seattle for the PASS Summit this year. I would love to meet up with friends and colleagues. I shouldn’t be too hard...
2024-10-29
21 reads
I still have a tendency to talk about all the cons of a proposed solution I don’t believe is the optimal one. There’s an old saying that “no one...
2024-11-08 (first published: 2024-10-29)
174 reads
One of the things that many DBAs struggle with is managing space across an estate. There might be one or two servers that you watch closely, or that are...
2024-11-11 (first published: 2024-10-28)
463 reads
I'm excited to tell you about the "SQL from A to Z" learning track. This comprehensive program will take you from SQL newbie to pro in no time. It's...
2024-10-28
46 reads
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
2024-11-06 (first published: 2024-10-27)
432 reads
feresy – n. the fear that your partner is changing in ways you don’t understand, even though they might be changes for the better, because it forces you to...
2024-10-25
32 reads
This article provides a comprehensive overview of the ORDER BY clause within SQL window functions. We'll explore how it interacts with PARTITION BY and the standard ORDER BY clause,...
2024-11-11 (first published: 2024-10-24)
658 reads
Want to build a data analytics foundation that transforms raw data into valuable business insights? Look no further than SQL! It's the perfect tool for creating powerful data pipelines...
2024-11-04 (first published: 2024-10-21)
726 reads
Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some...
2024-11-08 (first published: 2024-10-21)
188 reads
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Comments posted to this topic are about the item Database Mail Configuration
Comments posted to this topic are about the item Learn From History
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers