On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running. This includes, but is...
2024-08-21 (first published: 2024-08-09)
365 reads
A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...
2024-08-21 (first published: 2024-08-12)
212 reads
In this post, we share the strategies and techniques we've implemented to ensure our Electron-based Studio app runs smoothly, delivering a high-performance user experience.
2024-08-20
25 reads
The post How to Excel in Board Meetings as a CFO appeared first on Joyful Craftsmen.
2024-08-20
12 reads
If you're a data analyst, you already know that SQL isn't just a nice-to-have skill – it's the bedrock of your work. But let's face it, SQL isn't a...
2024-08-19
209 reads
There is a new index feature in Redgate Monitor, but it’s disabled by default. This post shows how to enable things. This is part of a series of posts...
2024-08-19 (first published: 2024-08-05)
129 reads
I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...
2024-08-19
30 reads
My personal experience Dockerizing a Ruby on Rails Application: Deploy to AWS ECR using Github ActionsI recently received a request on how to Dockerize a Ruby on Rails application after...
2024-08-19
49 reads
This post is dedicated to all 10 other DBAs that use Service Broker (you know who you are).
The main reason for this blog post is that I’ve got no...
2024-08-19 (first published: 2024-08-09)
177 reads
This is my own contribution to the T-SQL Tuesday I am hosting – on managing database code. I am from the older generation – where the farthest we went...
2024-08-18
41 reads
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Keeping up with Form W-4 updates doesn’t have to be complicated. In this practical...
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Comments posted to this topic are about the item Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers