-
Use advanced SQL Server connection properties in Microsoft Fabric with the ODBC connector
The built-in SQL Server connector in Fabric Data Factory doesn’t expose connection string properties like ApplicationIntent, MultiSubnetFailover, or Column Encryption Setting. Here is a supported way around it:… Continue Reading
-
Manage Fabric connections at scale with connection recency in Fabric REST APIs
Connections are shared infrastructure in Microsoft Fabric, and at enterprise scale it gets hard to tell which ones are still in use. Connection Recency in the Fabric REST… Continue Reading
-
Connect securely to Snowflake in Fabric Pipelines and Copy Jobs
Snowflake is a common source and sink for enterprise data movement, and Microsoft Fabric Data Factory supports it in both pipelines and Copy Jobs. Here is how Workspace-level… Continue Reading
-
Disabling Public Network Access in Synapse
Disabling public network access on a Synapse workspace throws a 403 in Synapse Studio. Here is why, and how private endpoints fix it. Continue Reading
-
How to read Data Lake with Synapse Serverless – Part 2
Use a Synapse Serverless external table to query a path in your Azure Data Lake with plain T-SQL. Part 2 of two. Continue Reading
-
How to read Data Lake with Synapse Serverless – Part 1
Query files in your Azure Data Lake with the Synapse Serverless pool using OPENROWSET, with no infrastructure to provision. Part 1 of two. Continue Reading
-
Structured Streaming in Synapse Spark
In this post we are going to look at an example of streaming IoT temperature data in Synapse Spark. I have an IoT device that will stream temperature… Continue Reading
-
Always Encrypted Data Displayed in SSRS with a gMSA
Let’s take a look at how to display Always Encrypted Data in SSRS with a gMSA (Group Managed Service Account). We are mixing some technologies and the one… Continue Reading
-
Build a SQL Cluster Lab Part 4
You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will… Continue Reading
-
Build a SQL Cluster Lab Part 3
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster… Continue Reading
-
Build a SQL Cluster Lab Part 2
You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run cluster validation followed… Continue Reading
-
Build a SQL Cluster Lab Part 1
This article is Part 1 in a series of articles showing how to build a SQL Cluster Lab. It covers building a Windows Cluster in Hyper-V that supports… Continue Reading
