I recently wrote a couple blog posts about writing. Is this meta-writing? I reckon. The posts are titled Writing a Technical Book and One Way to Write a Technical Book. Writing a Technical Book is a generic-ish look at the process of writing a technical book, while One Way to Write a Technical Book is …
Continue reading Getting Started Writing
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Delete SSIS Catalog Folders With SSIS Catalog Compare
To delete a Catalog folder using SSIS Catalog Compare, right-click the folder and click Delete Folder: You are prompted to confirm folder deletion: If the folder contains additional Catalog artifacts, the user is prompted again to confirm the deletion of the folder and all contents: Let’s take a short break right here and consider some …
Continue reading Delete SSIS Catalog Folders With SSIS Catalog Compare
Anatomy of a Catalog Reference Script in SSIS Catalog Compare
A Catalog Reference script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Header Documentation The script begins with a header documentation similar to that shown here: When executed, the Project Reference script header documentation portion displays in the Messages output window of SQL Server management Studio (SSMS): The statements …
Continue reading Anatomy of a Catalog Reference Script in SSIS Catalog Compare
The Recording for Use Biml to Build a Local Copy of an Azure SQL DB is Available
Enjoy! :{>
Anatomy of an Environment Script in SSIS Catalog Compare
An SSIS Catalog Environment script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that support SSIS Catalog Environment Variables contained within an SSIS Catalog Environment. These parameters are placed at the top of the script for …
Continue reading Anatomy of an Environment Script in SSIS Catalog Compare
Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare
An SSIS Catalog Connection Literals script is automatically generated using several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that will be used to provide literal overrides. These parameters are placed at the top of the script for easy access by …
Continue reading Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare
It Costs Precisely $0.00USD to be Nice
Be nice. We all have bad days. I know I do. It seems like I get interrupted about 1,000 times more when I’m busy than when I’m not busy. Why is that? Is it some vast universal conspiracy to rob me of productive work? Is it all in my head? I am not sure. One …
Continue reading It Costs Precisely $0.00USD to be Nice
Honored to Present Faster SSIS at SQL Saturday Boston 22 Sep 2018!
I am honored to present Faster SSIS at SQL Saturday Boston 22 Sep 2018! Check out this schedule – there are a bunch of smart people presenting – plus me! Abstract Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows …
Continue reading Honored to Present Faster SSIS at SQL Saturday Boston 22 Sep 2018!
Surface Connections in SSIS Catalog Compare and Catalog Browser
Changing the way Connections are surfaced and managed was a major focus of SSIS Catalog Compare version 3. The changes were first shared as part of SSIS Catalog Browser – a free utility from DILM Suite for viewing the contents of an SSIS Catalog – because building the surfacing mechanisms for the SSIS Catalog was …
Continue reading Surface Connections in SSIS Catalog Compare and Catalog Browser
PASS Summit 2018 Starts in 10 Weeks!
Can you believe the PASS Summit 2018 begins only 10 weeks from today (27 Aug 2018)? I confess, this is sneaking up on me fast! I will be there. Will you? Where Can You Find Andy at the PASS Summit 2018? Precon! Monday 5 Nov 2018, I’m delivering a full-day pre-conference session titled Intelligent Data …
Continue reading PASS Summit 2018 Starts in 10 Weeks!