Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our options for migrating SSIS to Azure and what components are required to migrate SSIS packages. […]
2021-04-05 (first published: 2021-03-22)
10,008 reads
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
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers