A reader of one of my previous posts pointed out that the legend order and segment order in my core visual stacked column chart did not match. I had...
2024-10-21 (first published: 2024-09-30)
712 reads
Please, let me reiterate: The only valid test of a backup is a restore. THE ONLY VALID TEST OF A BACKUP IS A RESTORE. I’m happy that you have...
2024-10-16 (first published: 2024-09-30)
283 reads
Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...
2024-09-30
13 reads
Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...
2024-09-30
144 reads
The season 1, seventh episode of Simple Talks is out. Check it out, with Ryan as the main host. Simple Talks is the Redgate podcast from myself, Grant, Ryan,...
2024-09-27
34 reads
the McFly Effect – n. the phenomenon of observing your parents interact with people they grew up with, which reboots their personalities into youth mode, offering you a glimpse...
2024-09-27
31 reads
At a recent conference I was asked how I executed code during my presentation. Running code during a presentation should be as smooth as possible…so in VS Code I...
2024-10-16 (first published: 2024-09-27)
437 reads
This fall you can take the next step in your data leadership journey by joining a cohort of industry peers and get mentored by experts in the field. In...
2024-09-26
18 reads
“Could you help me, we deleted the database’s transaction log file and now that database is stuck in ‘Recovery Pending’?” This was a panicked call that I received a...
2024-10-14 (first published: 2024-09-26)
571 reads
I had a couple of clients who were moving content from development catalogs to production catalogs for the first time. They wanted to copy the schema and data from...
2024-09-25
27 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Comments posted to this topic are about the item Four Rules for Adding AI...
Hello, the title says it all. Is the SQL Server 2025 section missing?
I am not sure which is the best way to proceed. I have parent...
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers