The Microsoft SSIS Team announces the general availability (GA) of the SSIS Projects for VS2019 version 3.3! In this version, the biggest change is that we removed Power Query Source for SQL Server 2017 and Microsoft Oracle Connector for SQL Server 2019. Since this version, if you want to use these two components in this …
Continue reading Announcing GA of the Integration Services Projects Extension for Visual Studio 2019
Category:Azure DevOps
Honored to Present From Zero to ADF at SQLBits 2020 in London!
Honored to Present From Zero to ADF at SQLBits 2020 in London 1 Apr 2020! When I look at this list of SQLBits Training Day presenters, I think, “Wow! That’s a lot of really smart people… plus me!” Registration is open now. Register today! :{>
My PASS Summit 2019 Presentations
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
PASS Summit 2019, Coming Down
During the PASS Summit 2019, Frank and I worked hard to deliver several DataDriven *DataPoint*’s.Here’s a list: *DataPoint* Andy is on the Way to Seattle for PASS 2019 *DataPoint* Andy Arrives at PASS 2019 *DataPoint* PASS 2019 Welcome Reception *DataPoint* Hanging Out with #SQLGeeks at PASS 2019 *DataPoint* Andy Speaks with SentryOne CEO Bob Potter …
Continue reading PASS Summit 2019, Coming Down
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
Presenting Moving Data with ADF at TriPASS 20 Aug
I am honored to deliver Moving Data with ADF to the Triangle SQL Server Users Group (TriPASS) 20 Aug 2019 starting at 6:00 PM EDT! This event will be streamed live via Twitch. Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical …
Continue reading Presenting Moving Data with ADF at TriPASS 20 Aug
SSIS Is Not Dead (Or Dying)
A few weeks ago I began hearing a rumor that SSIS had a couple years of life remaining. “In two years or so,” according to the rumor, “SSIS will die and be replaced with Azure Data Factory.” Is Microsoft capable of such a move; deprecating a technology? Yep. Remember SQL Server Notification Services? I can …
Continue reading SSIS Is Not Dead (Or Dying)
Honored to Present Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019!
I am honored to deliver Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019! Abstract Data Integration Lifecycle Management – or DILM – is challenging regardless of your chosen data integration platform. The primary goal of this session is an explanation – via demonstration – of the production release of an SSIS …
Continue reading Honored to Present Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019!
How To: Execute Azure-SSIS Packages From Azure Files
UPDATE: View the recording of the free webinar titled Execute Azure-SSIS from Azure Files. Enjoy! :{> Join me Tuesday, 2 Jul 2019 at 12:00 PM EDT for a free webinar titled Execute Azure-SSIS Packages from Azure Files! An Updated Azure-SSIS Integration Runtime I confess: I have been waiting for this feature since I first learned …
Continue reading How To: Execute Azure-SSIS Packages From Azure Files
Free Webinar: Using the Azure Data Factory If Condition and Web Activities
The summer o’ ADF continues with another free webinar from Enterprise Data & Analytics Friday, 14 Jun 2019 at 12:00 PM EDT: Using the Azure Data Factory If Condition and Web Activities! Abstract Join Microsoft Data Platform MVP and author Andy Leonard for 30 minutes packed with demos. In this session, Andy walks through using …
Continue reading Free Webinar: Using the Azure Data Factory If Condition and Web Activities