SSIS Catalog Compare Version 4 – Three Videos

I am excited to announce general availability of SSIS Catalog Compare version 4! I made three short-ish (~2 minutes each) videos demonstrating some of the capabilities of the product. I really like the SCCPAC files and SCCPAC Deployment Wizard, which are only available in the Enterprise Edition. Use SCCPAC Deployment Wizard to Lift and Shift …
Continue reading SSIS Catalog Compare Version 4 – Three Videos

Grant SSIS Catalog Read-Only Permissions

The SSIS Catalog has built-in security to manage permissions. SSISDB – the database behind the SSIS Catalog – is “just a database” in many respects. When it comes to security, the SSIS Catalog surfaces an internal mechanism that provides granular permissions management. In this post I intend to demonstrate how to use SSIS Catalog security to …
Continue reading Grant SSIS Catalog Read-Only Permissions

Two ADF Presentations Next Week!

I am honored to deliver Moving Data with Azure Data Factory to two User Groups next week! Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) – or “SSIS in the Cloud.” Attend this session …
Continue reading Two ADF Presentations Next Week!

Thinking of You…

The holidays are a joyous and happy time of year.  Almost everyone struggles in some way with the holidays, though. There are numerous posts about how to have difficult conversations with family who disagree with you on some matter or other – usually politics or religion. For some folks, though, it’s worse. Some struggle with …
Continue reading Thinking of You…

Q: “What are Pitfalls for Software Developers to Avoid?”

I speak with up-and-coming software developers often. A couple junior / intermediate software developers work with me at Enterprise Data & Analytics. As I’ve navigated four decades (plus) of software development I have witnessed – and experienced – places on my career-trajectory-map marked, “Here be dragons.”  “I Can Learn All the Things” “My name is …
Continue reading Q: “What are Pitfalls for Software Developers to Avoid?”

Q: “Is It Possible to Get Software Development Right the First Time?”

A: “Almost.” Q: “Why Almost?” I’m glad you asked. There’s an awesome, albeit somewhat dated, article titled They Write the Right Stuff. The article is about implementing a process to manage software development. In the article, the following metrics are mentioned: 3 Previous Builds: 420,000 lines of code 1 error each 11 Previous Builds: 17 total …
Continue reading Q: “Is It Possible to Get Software Development Right the First Time?”

Fundamentals of Azure Data Factory

This past week I delivered Fundamentals of Azure Data Factory twice. Once for Brent Ozar Unlimited and once for a client – a private training delivery.  The course introduces Azure Data Factory and covers: Azure Data Factory Essentials – including provisioning an ADF instance Azure Data Factory Pipelines – in which introduce pipeline activities and source …
Continue reading Fundamentals of Azure Data Factory