Level 1 of the Stairway to Synapse Analytics - Create a Synapse Workspace
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
2025-06-06 (first published: 2024-07-03)
1,415 reads
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
Control OneLake with Storage Explorer – Data Engineering with Fabric
In this new article, we examine how to work with OneLake storage.
2024-06-26
1,778 reads
Stairway to Synapse Analytics
This stairway series is designed to teach you about the Azure Synapse Analytics cloud service.
2025-06-06 (first published: 2024-06-19)
641 reads
How to Set Up Microsoft Fabric Database Mirroring for Azure Cosmos DB
This article shows how to configure database mirroring from CosmosDB to Microsoft Fabric.
2024-06-10
1,348 reads
How to Build Metadata Driven Pipelines in Microsoft Fabric
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach. One of the benefits of having a more code-based approach in data pipelines is that it has become easier to build metadata driven pipelines.
2024-05-24
Empowering Lakehouse Users – Data Engineering with Fabric
Learn how to use the OneLake Explorer and Data Wrangler extension in VS Code to empower users to work with data in Microsoft Fabric.
2024-05-22
1,855 reads
Read Data Stored in a Lake Database using Azure Synapse Analytics
In this article, we look at how to read data stored in a lake database using Azure Synapse Analytics to help reduce overall Azure costs.
2024-05-13
Metadata Driven Pipelines – Data Engineering with Fabric
This article explains metadata driven pipelines and shows an example in Microsoft Fabric.
2024-05-01
5,230 reads
Full vs. Incremental Loads – Data Engineering with Fabric
Learn how to perform full and incremental loads in Fabric with a little SparkSQL.
2024-04-17
6,759 reads
Use Fabric Data Factory to Load Data From a CSV File in Azure Blob Storage to Azure SQL DB
Andy Leonard discusses and demonstrates using Fabric Data Factory to load a CSV file stored in Azure Blob Storage to Azure SQL DB.
2024-04-03
Blogs
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...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
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