Typing Strange Characters–#SQLNewBlogger
I’ve had to type a few non-English characters lately, and this blog talks about how to do this. Another post for me that is simple and hopefully serves as...
2023-06-28
453 reads
Three more chapters of my data architecture book are available!
As I have mentioned in a prior blog post, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering...
2023-07-14 (first published: 2023-06-28)
698 reads
When do Statistics get updated?
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful for us to understand when...
2023-06-28
180 reads
Heraflux and Rubrik Webinar – July 25
Heraflux is returning to deliver a new webinar with Rubrik and ActualTech Media titled “How to Secure Your Azure SQL Data.” With Azure SQL Server offerings continuing to grow...
2023-07-12 (first published: 2023-06-27)
115 reads
Battle of the Query Hints in Query Store
I recently presented a session on the Query Store at Data Saturday Rhineland and the question came up: If there’s already a query hint on a query, what happens...
2023-07-10 (first published: 2023-06-26)
315 reads
The Four Different Types of Flyway Files
This is documented, somewhat, but I wanted to put this down for myself, as the I don’t love the docs and they are hard to sort through. Flyway is...
2023-07-07 (first published: 2023-06-26)
142 reads
Twenty Years as a Guardian ad Litem
Twenty years ago, I stood in a courtroom and took an oath for a volunteer job I had no idea I would fall so much
The post Twenty Years as...
2023-06-30 (first published: 2023-06-26)
219 reads
A New Word: Volander
volander: n. the ethereal feeling of looking down at the world through an airplane window, able to catch a glimpse of far-flung places you’d never see in person, free...
2023-06-23
113 reads
Agile West–How Do I Get Started with Database DevOps
This week I had the chance to deliver a talk at Agile West in Las Vegas. I linked some resources on my blog, and feel free to check them...
2023-06-21
65 reads
What are Statistics in SQL Server?
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2023-06-21
346 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers