The Last SQL Server Service Pack
SQL Server 2016 SP3, the last service pack ever is out. Steve comments on how the world of software patches has changed.
Databricks Delta Change Data Feed
In this article we cover how to implement a batch Databricks Change Data Feed process through an end-to-end exercise.
Estimating Data Compression Savings in SQL Server
This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.
Choosing State Over Migrations
Steve notes that there are differences between state based development and migration based development, but neither is necessarily better.
Stairway to SSAS Tabular Level 1: Why use Analysis Services
In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.
Learning the SQL GROUP BY Clause
Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets.
Tower Loan: Monitoring our estate and insights for your success
Join Kevin Davis, DBA Manager at Tower Loan to hear their playbook for successful distributed estate monitoring, and the role of SQL Monitor.
Incremental Data Loading Using ADF and Change Tracking
This article looks at moving data in three related tables to Azure SQL Database using the change tracking feature in SQL Server to determine which rows have been changed.
Location Data Is Not Anonymous
The world of public data is scary for Steve, even when the data is aggregated. It appears that keeping information private is becoming harder, and perhaps, impossible.
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers