SSIS DevOps and Azure Containers I was honored to co-present SSIS DevOps and Azure Containers with Sreeja Pullagura and Elizabeth Baron. Liz and Sreeja work for Teach for America, a really cool non-profit headquartered in NYC. This was their very first time presenting at the PASS Summit. We were even featured on PASStv! . You …
Continue reading My PASS Summit 2019 Presentations
SSIS DevOps and Azure Containers I am preparing for an exciting week in Seattle! This year I have the honor of co-presenting SSIS DevOps and Azure Containers with Elizabeth Baron and Sreeja Pullagura, two (really) smart architects who work together at Teach For America – an awesome non-profit in New York. Catch us Wednesday, 6 …
Continue reading PASS Summit 2019 Presentations
In my post titled SSIS, Docker, and Windows Containers, Part 4 – Adding an SSIS Catalog, Attempt 2 I wrote about storing the SQL Server 2017 Developer Edition installation media in a directory. But I failed to explain how I do this. This is how I store the SQL Server 2017 Developer Edition installation media …
Continue reading One Way to Extract SQL Server 2017 Installation Media
I consider scripting in SQL Server Integration Services (SSIS) my data integration “get out of jail free” card. Why? If I cannot find a way to accomplish some requirement using SSIS’s built-in objects – tasks, containers, Data Flow components, etc. – I can usually write .Net code to fulfill the requirement. As stated in the …
Continue reading SSIS Design Pattern: Use Script Tasks for ETL Instrumentation
2018 is drawing to a close. Some readers recently shared requests for more blog posts on certain topics. I thought I’d put the question to my audience (both of you, hi Mom!) to gather your thoughts. Feel free to leave a comment or reach out via email. Here are some topics I plan to blog …
Continue reading How May I Serve You?
Has this ever happened to you? You are opening an SSIS project and… it won’t open. Instead of a Control Flow filled with awesome tasks and containers, you see a message in Solution Explorer telling you “The application is not installed.” You know this isn’t right because you built the SSIS project on this same machine …
Continue reading SSIS Project Incompatible
As the title of this post suggests, it is possible to execute SSIS in a container. How? I’ll share more details later – promise. One short version is: Run a container with the microsoft/mssql-server-windows-developer image (assign lots of RAM). Add the SQL Server installation files to the container. Execute SQL Server setup from a command line …
Continue reading It is Possible to Execute SSIS in a Container
I got a great question from a student in the December delivery of Expert SSIS. A student asked, “Why wouldn’t you use Environments in Visual Studio (Dev, Test, and Prod), and deploy accordingly the mapped project parameters and package parameters?” I’ve looked into using SQL Server Data Tools (SSDT, or Visual Studio) configurations in the …
Continue reading SSIS and Visual Studio Configurations
I am honored to partner with the awesome team at SQLSkills to deliver IESSIS1: Immersion Event on Learning SQL Server Integration Services in person in Chicago 7-11 May 2018! Click here to register! Here’s what I’ll be covering: Module 1: Introduction In the introduction we share information about the instructor, course flow, and content, and gather …
Continue reading Immersion Event on Learning SSIS – May 2018!
I am honored to once again deliver Immersion Event on Learning SQL Server Integration Services (IESSIS1) in Chicago with SQLSkills 2-6 Oct 2017! You can find additional details here. Click here to register! Here’s what I’ll be covering: Module 1: Introduction In the introduction we share information about the instructor, course flow, and content, and gather …
Continue reading IESSIS1: Immersion Event on Learning SQL Server Integration Services – Chicago, 2-6 Oct 2017!
