With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal to write SQL more efficiently. One of those features is macros, which we’ll introduce in this article
2025-05-28
This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.
2025-06-06 (first published: 2025-05-07)
718 reads
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
2026-05-06 (first published: 2025-04-16)
1,728 reads
Learn how you can create a full data load process in Fabric.
2025-04-16
4,128 reads
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,343 reads
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,662 reads
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
2,312 reads
In this next article in the Data Engineering with Fabric series, learn the different ways to develop schemas inside of Fabric.
2025-02-12
2,404 reads
Learn about how you can efficiently load data in Azure Synapse.
2025-03-06 (first published: 2025-02-03)
1,288 reads
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Security on your SQL Server is important. That doesn’t need any explaining. But where...
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
Comments posted to this topic are about the item BIT_COUNT in SQL Server
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers