How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Learn about using classification as a technique to prepare your data for additional machine learning analysis.
2026-07-15
709 reads
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
2026-06-27
117 reads
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Data build tool (dbt) is an open-source command line tool that helps engineers transform data using SQL scripts. However, there are limitations to what can be done with the Structure Query Language (SQL). That is where dbt Python models can be used to perform complex tasks. A dbt Python model is a function that reads […]
2026-06-03
2,497 reads
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data within their warehouses. It already assumes that data is extracted and loaded into raw tables. The dbt core framework is written in Python with the translations defined as a combination of SQL scripts, Jinga Template Language, and YAML […]
2026-05-27
1,168 reads
Improve Query Performance in the Fabric Warehouse with Clustering
Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.
2026-05-18
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Learn more about dbt in this next article on Data Engineering in Fabric.
2026-04-08
4,823 reads
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
In this next installment, we look at using dbt to seed a Fabric Warehouse.
2026-03-25
3,359 reads
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
The next installment of the Fabric Modern Data Platform looks at Spark pools for executing code.
2026-03-11
1,734 reads
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
In this next installments of the Modern Fabric Data Warehouse, we look at tools for developers.
2026-02-25
2,257 reads
Microsoft Fabric and MQTT for Real-Time IoT Data Ingestion and Analytics
Microsoft Fabric is a unified platform for data integration, data engineering, real-time intelligence, and advanced analytics. Fabric is known for providing an integrated way of working with your data, connecting to many diverse types of sources and across the data landscape. How do we get started ingesting and analyzing real-time data streamed over the MQTT protocol?
2026-02-23
Blogs
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Forums
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
whats that ssis analyzer product that documents lineage
hi, a few years ago was at a very large company that bought a...
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers