The Year in Travel
Here’s my year, which is pre-populated with a couple more trips coming up in November. Those should be all, as I’ve declined to go back to the UK in...
2023-10-20
16 reads
Blog Posts
Common Mistakes in SQL Server – Part 3
Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part 2. This week in this article Common Mistakes in SQL Server - Part 3 I...
2023-10-18 (first published: 2023-10-02)
966 reads
Eleven chapters of my data architecture book are available
As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...
2023-10-18 (first published: 2023-10-02)
325 reads
Common Mistakes in SQL Server – Part 5
Last week, in the post Common Mistakes in SQL Server - Part 4 I explained about the Auto Growth configuration in SQL Server and how it can adversely impact....
2023-10-16
14 reads
SQL Saturday Boston 2023 Recap
First Things First Thank you to everyone who attended my session “Answering the Automator’s Call with Automation.” My slide deck and demo code are now available on my Github.....
2023-10-16 (first published: 2023-10-15)
63 reads
The 5 Best SQL Course for Beginners – Reviews and Guide
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the intricacies of database management. Central to this booming sector is SQL, a programming language exclusively...
2023-10-16 (first published: 2023-10-04)
484 reads
Using the Pure Storage PowerShellSDK2 - Part 1 - Connecting to FlashArray
Welcome to our blog series on using the Pure Storage PowerShell SDK2. In this series, we will provide you with practical insights and examples on how to harness the...
2023-10-16 (first published: 2023-10-03)
163 reads
SQL Saturday Boston 2023 Slide Decks
Thanks to everyone who came to my sessions at SQL Saturday Boston 2023. I’ve added the decks to the schedule, so you can click my session and will see...
2023-10-14
48 reads
A New Word: Harmonoia
harmonoia – n. an itchy sense of dread when life feels just a hint too peaceful – when everyone seems to get along suspiciously well, with an eerie stillness...
2023-10-13
37 reads
Creating an Empty Repo in GitHub–#SQLNewBlogger
I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an...
2023-10-13 (first published: 2023-09-20)
228 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Expensive CPUs
Comments posted to this topic are about the item Expensive CPUs
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers