Using Azure Data Factory Mapping Data Flows to populate Data Vault
(2019-May-24) Data Flow as a data transformation ...
2019-05-24
ETL/SSIS/Azure Data Factory
2019-05-22
2019-05-22
Mapping Data Flow in Azure Data Factory (v2)
Azure Data Factory is more of an orchestration tool than a data movement tool, yes. It’s like using SSIS, with control flows only. Once they add Mapping Data Flows...
2019-05-08
The Recording for Using Biml as an SSIS Design Patterns Engine is Available!
Enjoy! :{>
The post The Recording for Using Biml as an SSIS Design Patterns Engine is Available! appeared first on AndyLeonard.blog().
2019-05-06
Exporting an .ISPAC from the SSIS Catalog via the SSIS PowerShell Provider
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
The...
2019-05-06
Where should I clean my data?
As a follow-up to my blogs What product to use to transform my data? and Should I load structured data into my data lake?, I wanted to talk about where you...
The...
2019-04-26
SSIS 2019 has arrived!
It is not a joke: SSIS is available for Visual Studio 2019 as a preview. Whoa, hold on. SQL Server 2019 hasn’t been released yet? But there’s already an...
The...
2019-04-26
How to fix SSIS Deployment Error “Please Create a Master Key”
Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and keeps on failing with the following error: The error is succinct and direct to...
2019-04-24
SSIS vs. Oracle GG
This is the third in a series of product identifications between Oracle and Microsoft to assist those attempting to understand the similarities and differences between these essential parts of...
2019-04-11
Blogs
PASS Data Community Summit 2024 Day 3 Keynote
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
A New Word: Skidding
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
PASS Summit – Thursday
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Forums
Step by step guide to setup PostgreSQL on Docker
Comments posted to this topic are about the item Step by step guide to...
Backing up the Database Encryption Key
Comments posted to this topic are about the item Backing up the Database Encryption...
Technology Fears
Comments posted to this topic are about the item Technology Fears
Question of the Day
Backing up the Database Encryption Key
In my SQL Server 2022 database, I run this:
USE Sales; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE MyServerCert; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers