Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines
Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.
2025-01-13
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
How to Load a Fabric Warehouse: Data Engineering with Fabric
In this next level, learn how you can load data from Amazon S3 in Fabric.
2025-01-08
4,759 reads
Convert Excel Workbooks to CSV with Microsoft Fabric
For my new mission, I set out to convert a list of files from Excel to comma-separated values (CSV). We upload the original Excel files to a Data Lake in Fabric. We then need to convert a specific worksheet and move the CSV files to a different folder in Data Lake.
2024-12-25
Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake
Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creating the Synapse Workspace. In Level 2, we analyzed Data Lake files using the Serverless SQL Pool. In Level 3, we analyzed Data Lake files using the Spark Pool. In Levels 4 and level 5, I will discuss the Delta […]
2025-06-06 (first published: 2024-12-18)
1,956 reads
Virtualizing GCP data by using Fabric Shortcuts: Data Engineering with Fabric
In the next installment of this series, learn how you can read data from the Google Cloud Platform (GCP) and virtualize it into your Azure Data Lake Storage.
2024-12-11
2,694 reads
Explore Pandas in Python to Analyze and Manipulate Tabular Data
Learn how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.
2024-11-18
Ingesting Data From REST API endpoints: Data Engineering with Fabric
In this article on Fabric we will examine how to get data from a REST API.
2024-11-13
3,662 reads
Relationships with Microsoft Fabric GraphQL API
Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.
2024-11-13
How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform
In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing with a lot of Azure Logic Apps in your data platform.
2024-11-08
2024-11-06
199 reads
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