Read a story about how one company saved substantially on their cloud costs with a few simple changes and no interruptions to service.
2026-08-21
1,884 reads
We sat down with Lee Brownhill, a senior DBA and Redgate Ambassador with 20 years of experience, to get his honest take on where the role is heading – and what database professionals are actually focused on right now.
2026-08-21
This article presents a way to audit your SSAS cubes using PowerShell to prepare for any audit questions about who has access to the data.
2026-08-19
1,251 reads
Over the past couple of years, I've been using the bejeezus out of AI. I don't really feel like an expert by any means - it's so hard to keep up with the advancements - but I've been enjoying reading Grant Fritchey's series on building stuff with AI, and I thought you might enjoy some of my lessons learned as well.
2026-08-19
Learn how to automate OpenStreetMap data refresh on Power Bi's Azure Maps reference layer.
2026-08-17
1,614 reads
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.
2026-08-17
This article looks at one of the killers of performance at scale, SELECT *.
2026-08-14
2,004 reads
Build scalable data pipelines by pushing transformations into SQL and keeping Python focused on analysis.
2026-08-14
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.
2026-08-12
2,715 reads
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.
2026-08-12
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Security has long been a problem for me. Every time I think I understand...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers