Azure AD Authentication for Azure SQL Databases
In this article we walk through how to connect to Azure SQL Database using Azure Active Directory authentication along with multi-factor authentication.
2021-03-19
In this article we walk through how to connect to Azure SQL Database using Azure Active Directory authentication along with multi-factor authentication.
2021-03-19
Learn how to setup and use Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.
2021-03-02
Thanks to the consent of the speakers, the expert-led educational training courses covering the following four topics: Data Modernization, Azure Migration, Azure Synapse, Azure SQL, are now available to all. You can watch the sessions and learn from a range of experts online, for free.
2021-03-17 (first published: 2021-03-01)
In this article we will cover how to capture and persist Azure Data Factory pipeline errors to an Azure SQL Database table.
2021-02-16
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
2021-02-05
In this article we look at how to upload and download files from Azure Storage using SQL Server Integration Services.
2021-01-15
In this tip we will go through the steps for setting up customer managed keys or Bring your own key (BYOK) to be used for transparent data encryption for an Azure SQL Database.
2020-12-08
Learn the five steps to perform Azure resource reporting with Power BI in order to embed the reports in dashboards for stakeholders.
2020-11-23
Azure DevOps tasks often contain sensitive credentials and secrets that need to be appropriately secured and in this article I demonstrate how to implement different options.
2020-11-13
This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]
2020-11-12
21,069 reads
A couple of weeks ago, a developer came to me and wanted to know...
By SQLPals
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...
Comments posted to this topic are about the item Baseball Everywhere
I am working on a small test script on SQL server 2022 using python...
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and...
I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?
ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price, dbo.sales.discount WITH ( LABEL = 'Highly Confidential', INFORMATION_TYPE = 'Financial', RANK = 'INTERNAL ONLY' );See possible answers