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
19 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,229 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,598 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
1,977 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,671 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
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Comments posted to this topic are about the item BIT_COUNT() V
Comments posted to this topic are about the item How We Reduced SQL Server...
Comments posted to this topic are about the item An Eventual Consistency Scam
What does this return on SQL Server 2025?
select bit_count(null)See possible answers