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)
9,887 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
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
WA:08218154393 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers