Using Azure SQL Data Sync to Replicate Data
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
azure
Unlocking the “PASS Pro” Educational series
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)
Azure Data Factory Pipeline Logging Error Details
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
Create Azure DevOps Analytics Visuals with Power BI OData Queries
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
2021-02-05
Azure Blob Storage Data Upload with SSIS
In this article we look at how to upload and download files from Azure Storage using SQL Server Integration Services.
2021-01-15
Azure SQL Database TDE Customer Managed Keys
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
Visualizing Azure Resource Metrics Data in Power BI
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
Securing Secrets in Azure DevOps
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
How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?
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
20,933 reads
Static Hosting with Azure Blob Storage and Azure CDN
No matter what you need, Azure probably has a solution. In this article Diogo Souza demonstrates how to host a static web page in Azure in just a few steps with Azure Blob Storage and Azure CDN.
2020-11-03
Blogs
Part 2: The Modern Azure Data Warehouse – ADF and ADLS
In today’s data-driven world, having the right tools to manage and process large datasets...
A New Word: Flichtish
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
Automating Container Image Builds with Docker Build Cloud and Github Actions
In a previous post we went through how to use Docker Build Cloud to...
Forums
Backup with Checksum Show No Issues, While DBCC CHECKDB Reports Errors
I took a backup with the CHECKSUM option, which was successful and showed no...
Realities of Predictive Analysis
Comments posted to this topic are about the item Realities of Predictive Analysis
Linked Server Product Name?
Just came across something weird. Was wondering if anyone else has ever seen this....
Question of the Day
Creating Statistics on XML
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers