I’m honored and excited to deliver a brand new presentation at SQL Saturday 683 – Charlotte on 14 Oct: Faster SSIS! 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 you how to tune SQL Server 2016 Integration Services …
Continue reading Presenting Faster SSIS at SQL Saturday 683 – Charlotte 14 Oct
Presenting Designing an SSIS Framework at SQL Saturday 681 – Spartanburg 23 Sep
I am honored to present Designing an SSIS Framework at SQL Saturday 681 – Spartanburg 23 Sep! Abstract: Enterprise data integration changed with the introduction of the SSIS Catalog. Implementing enterprise data integration often requires functionality beyond the rich features provided by the SSIS Catalog. Building on his previous work in the field of Data …
Continue reading Presenting Designing an SSIS Framework at SQL Saturday 681 – Spartanburg 23 Sep
Coming Soon: SSIS Catalog Compare Updates
I spent a lot of time this year writing and managing a book project. I will blog about that later, I promise. While I enjoy writing it really cuts into my play time. What do I do when I play? I write software. This weekend I cracked open the code for SSIS Catalog Compare and …
Continue reading Coming Soon: SSIS Catalog Compare Updates
(Some of) Why We Do What We Do, an Opinion
I encounter different personalities in the Technology Communities to which I belong. I’m not merely a consumer, I contribute a different personality as well. I’ve been playing and working in technology since 1975. One thing I’ve learned is: people believe the things they believe for a reason. Or reasons. I can hear some of you …
Continue reading (Some of) Why We Do What We Do, an Opinion
Remain Standing
Why am I writing about this on a technical blog (instead of my personal blog where I discuss faith and culture)? In this post I discuss personal and professional perseverance. I make no apology for my faith or for sharing it in every setting – personal and professional. People are singletons; you cannot decouple components of …
Continue reading Remain Standing
Catalog Reports Update
I recently updated the Data Integration Lifecycle Management Suite (DILM Suite) Catalog Reports solution! Here’s a summary of the changes: I re-arranged fields on the Executions Report: I moved the links to the Overview, Messages, and Performance reports to the left in each (execution) row to support easier navigation. I added Previous and Next Execution …
Continue reading Catalog Reports Update
Congratulations Kent Bradshaw – Certified Data Scientist!
I am honored to announce Kent Bradshaw, who works with me at Enterprise Data & Analytics, is now a Microsoft Certified Data Scientist! Kent worked hard for several months to achieve this honor. He worked through ten courses, including a five-week Statistics course taught by Columbia University faculty. Congratulations Kent! :{> Learn more: Enterprise Data …
Continue reading Congratulations Kent Bradshaw – Certified Data Scientist!
A Basic SSIS Catalog Dashboard in Power BI
Announcing the latest addition to the DILM Suite: Basic SSIS Catalog Dashboard in Power BI! This free download includes a T-SQL script to create a view in the SSIS Catalog database (SSISDB) and a Power BI template for viewing SSIS Catalog executions by Year, Month, Folder, Project, Package, and/or Execution Status. The Basic SSIS Catalog Dashboard …
Continue reading A Basic SSIS Catalog Dashboard in Power BI
Please Change the Color of the SSIS Progress Tab “Finished” Icon
I’m tuning SSIS for better performance for a large client. The SSIS package I’m working with runs for over an hour and generates thousands of entries on the Progress / Execution Results tab. I wrote a small demo package, executed it, and show the results here to demonstrate: Why is the Finished icon red? This …
Continue reading Please Change the Color of the SSIS Progress Tab “Finished” Icon
Updates to Integration Services Deployment Wizard
I’m doing a little writing and I noticed something different about the Integration Services Deployment Wizard. Specifically, the Select Destination page now looks like this: The Authentication dropdown – along with the User name and Password textboxes – are recent additions. I’m not sure if they’re part of the SSMS 17.2 installation or one of …
Continue reading Updates to Integration Services Deployment Wizard