Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Learn how to automate OpenStreetMap data refresh on Power Bi's Azure Maps reference layer.
Going Big with SSDs
Solid State Drives are becoming more commonplace in database systems. eBay and Facebook have implemented large SSD systems in their environments. Steve Jones thinks DBAs should be learning more about how SSDs affect SQL Server.
SQL Server index tuning: common mistakes and how to fix them
This guide walks through the most common SQL Server index tuning mistakes seen in production environments, such as over-indexing, oversized INCLUDE lists, unnecessary fill factor settings, misuse of SORT_IN_TEMPDB, over-aggressive index maintenance – and the myth that heaps are a shortcut to speed. Features real examples.
Learn From History
I've just spent a week in the UK visiting the Redgate HQ with my fellow advocates. I'm really blessed to get to work with such a great bunch of people. A couple of the conversations we had stuck with me and I'd like to share them here. Sitting in the midst of Cambridge, Cambridgeshire, UK, […]
The Hidden Danger of Wildcard Operators In Join Operations
This article looks at one of the killers of performance at scale, SELECT *.
How to get clean, usable data out of SQL Server into Python
Build scalable data pipelines by pushing transformations into SQL and keeping Python focused on analysis.
Building Great Software
Steve notes that building great software isn't easy, and there is a lot of work that goes into this. Even in today's age of AI.
OUTER APPLY Fundamentals: Part 2
In Part 2 of this series we learn how OUTER APPLY can be used in your queries to return data, even when there are no matches between tables.
Create SQL Server 2025 Availability Groups with SSMS Wizard
SQL Server Availability Groups are great for DR and HA purposes. In this article, we look at how to setup a SQL Server 2025 Availability Group using the features in SQL Server Management Studio.
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