SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. SSIS Connection Managers In Secure Connections Management in SSIS, Part 1, I demonstrated configuring an SSIS Connection …
Continue reading Secure Connections Management in SSIS, Part 2
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. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
A Cool SSIS Catalog Visualization
My friend George Squillace (LinkedIn) shares this great post and cool SSIS Catalog Visualizations. Enjoy! :{> Learn more: Advanced SSIS Training with Tim Mitchell and Andy Leonard in Dallas, TX 9-11 Mar 2015 Linchpin People Blog: SSIS Stairway to Integration Services
Social Media and Me
Earlier this month, I decided to take a break from Twitter and Facebook. A couple of you noticed (I’m ok, Mom. Really!) so I decided to share this post. I continue to post updates about articles, blog posts, and presentations at LinkedIn, and I’m (obviously) still blogging. I encourage everyone interested in the goings-on at …
Continue reading Social Media and Me
Secure Connections Management in SSIS, Part 1
SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. SSIS Connection Managers Let’s begin by examining ways to connect to a database – any database – …
Continue reading Secure Connections Management in SSIS, Part 1
What’s the Number One Attribute of Awesome Email?
Brevity. :{> Learn more:
SSIS Catalog Environments– Step 20 of the Stairway to Integration Services!
SSIS Catalog Environments– Step 20 of the Stairway to Integration Services is live at the Stairway to Integration Services site at SQL Server Central! Enjoy! :{>
Consulting 101: Viewing the Field
It’s important for a consultant to be able jump into a situation and quickly evaluate and assess the dynamics involved, in order to serve the client efficiently and effectively and economically. While a lot of people dislike military metaphors, there are a lot of good lessons to learn from military thinking. This is one area …
Continue reading Consulting 101: Viewing the Field
Interpreting Communication
One important thing about which to be self-aware is how you interpret communication. Communication is a two-phase commit. The first part lies with the person communicating. She has an idea she wishes to communicate, and she communicates it – in writing or verbally. The second part is with the person (or people) to whom the …
Continue reading Interpreting Communication
Executing SSIS: Run SSIS Packages in the SSIS Catalog via Stored Procedure
In my article titled A Custom Execution Method – Level 19 of the Stairway to Integration Services posted at SQL Server Central, I created a stored procedure to execute SSIS packages stored in the SSIS Catalog. Really, all I did was build a rudimentary wrapper for the stored procedures used by the SSIS Catalog to …
Continue reading Executing SSIS: Run SSIS Packages in the SSIS Catalog via Stored Procedure
Self-Awareness – Feedback
Self-awareness is an important trait. I believe it is especially important for consultants. For each of us, there is some gap between reality and what we perceive. I believe one measure of humility (or pride) is this self-awareness delta. I also believe we can narrow this gap by engaging in exercises in intentional awareness. Which …
Continue reading Self-Awareness – Feedback