Level 6 of the Stairway to Synapse Analytics: Dedicated SQL Pool
This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.
2025-05-07
529 reads
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?
The article A gentle introduction to dbt explains how you can get dbt in the cloud version, how you can set up a free account, and how to create a connection to a Microsoft Fabric warehouse.
2025-04-30
2025-04-16
1,265 reads
Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform
Learn how you can create a full data load process in Fabric.
2025-04-16
2,544 reads
Create Raw Zone Tables using Generative AI: The Fabric Modern Data Platform
In this first article on the Fabric Modern Data Platform, we look at how to use Generative AI to build tables.
2025-04-07 (first published: 2025-04-02)
3,129 reads
Fabric Analytics for SQL folks: Part 1 - Fabric demystified
Unlock new opportunities for data-driven decision-making by grasping the significance of SQL and structured data in current data and analytics ecosystems like Microsoft Fabric.
2025-03-21
6,004 reads
Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric
This next article in the Data Engineering with Fabric series showcases how tally tables can help load data in a Fabric warehouse.
2025-02-26
1,956 reads
How to Develop Solutions with Fabric Data Warehouse: Data Engineering with Fabric
In this next article in the Data Engineering with Fabric series, learn the different ways to develop schemas inside of Fabric.
2025-02-12
1,996 reads
An Effective Approach for High Volume Data in Azure Synapse
Learn about how you can efficiently load data in Azure Synapse.
2025-03-06 (first published: 2025-02-03)
1,067 reads
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
Blogs
Speaking at the NYC Lunch and Learn DevOps Devour Hour
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Forums
SQL 2022 upgrade issues
We're about to upgrade our SQL 2017 Standard to 2022 standard. We have 1...
Script-Drop Orphan users from SQL Server Database
Comments posted to this topic are about the item Script-Drop Orphan users from SQL...
The Hidden Cost of Ignoring Software Bugs
Every expert knows you can't make perfect software that never crashes or has bugs....
Question of the Day
The Minimal Linked Server
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers