Grinding Away: Mary Spender
A few years ago I stumbled on this video and loved it. That led me to Mary’s page and this cover of John Mayer’s Stop This Train: Since then...
2025-01-13
12 reads
Blog Posts
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also using the Azure migration tool. I had to ultimately do a combo of those because...
2025-01-13 (first published: 2025-01-07)
1,934 reads
How to clear the SSMS cache?
How to clear the SSMS cache?
If you are reading this, it's probably because you too have this rare need to clear the SSMS cache for...
2025-01-13 (first published: 2025-01-10)
1,842 reads
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your...
2025-01-13 (first published: 2025-01-12)
106 reads
A New Word: Querinous
querinous – adj. longing for a sense of certainty in a relationship; wishing there were some way to know ahead of time whether this is the person you’re going...
2025-01-10
119 reads
BK’s Bookshelf: Never Split the Difference
I picked up Never Split the Difference: Negotiating As If Your Life Depended On It by Chris Voss, a former FBI negotiator. Given what I do, I realized that...
2025-01-10 (first published: 2025-01-01)
431 reads
Capturing Ideas for Blogs
As we close out the year, I decided to drop this post here and maybe inspire a few of you to write in 2025. This post looks at some...
2025-01-10 (first published: 2024-12-30)
1,679 reads
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World Exercises for All Levels. It covers subqueries – a must-have tool for any SQL pro....
2025-01-10
166 reads
Introduction to OpenAI and LLMs – Part 3
My previous blog posts on this topic were Introduction to OpenAI and LLMs, the “what” part (what is OpenAI and LLM), and the “how” part Introduction to OpenAI and LLMs –...
2025-01-09
14 reads
2025-01-09
5 reads
Blogs
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers