I got pinged about a new trusted site requirement when I tried to connect to Azure SQL DB this morning. https://aadcdn.msftauth.net is the URL. I added the URL to Internet Explorer’s Trusted Sites: I was then able to connect to Azure SQL DB and add a rule for my IP using SQL Server Management Studio (SSMS).
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.
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
T-SQL Tuesday #111 – What is Your “Why?”
“Why do you do what you do?” This month’s T-SQL Tuesday topic by Andy Leonard.
Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!
I am honored to announce I will be delivering Intelligent Data Integration through SSIS – a day-long SQL Saturday 841 – Dallas pre-conference session 31 May 2019! Description: What is Intelligent Data Integration? SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data …
Continue reading Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!
Lift and Shift is Not a Strategy…
Lift and shift is a bridge. If your enterprise is considering migrating enterprise data and data integration workloads from on-premises to the cloud, lifting and shifting is not the end of the story. Lifting and shifting is, rather, the mechanism – the conversion project – that positions your enterprise to leverage the economies of scale …
Continue reading Lift and Shift is Not a Strategy…
Enterprise Data & Analytics Welcomes Shannon Lowder!
I am honored and thrilled to welcome Shannon Lowder (@shannonlowder | blog | LinkedIn) to the Enterprise Data & Analytics team! Shannon is a data engineer, data scientist, BimlHero (though not listed on the page at the time of this writing), and shepherd of the Biml Interrogator open source project. If you use Biml to generate SSIS …
Continue reading Enterprise Data & Analytics Welcomes Shannon Lowder!
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
Presenting Moving Data with Azure Data Factory in Richmond 7 Feb!
I’m honored to deliver Moving Data with Azure Data Factory to Azure Richmond Virginia Thursday, 7 Feb 2019 starting at 6:30 PM! The meeting will be held at Markel Plaza – 4600 Cox Road · Glen Allen, VA. Learn more at Meetup… I hope to see you there! :{>
Join me For Expert SSIS Training!
I’m honored to announce Expert SSIS – a course from Enterprise Data & Analytics! The next delivery is 01-02 Apr 2019, 9:00 AM – 4:30 PM ET. Data integration is the foundation of data science, business intelligence, and enterprise data warehousing. This instructor-led training class is specifically designed for SQL Server Integration Services (SSIS) professionals …
Continue reading Join me For Expert SSIS Training!
The 2:00 AM Test
I’m working with a collection of clients these days providing data integration, cloud, and DevOps advice. I love architecture work! My clients love the results. Everyone wins. Kent Bradshaw and I are tag-teaming with a couple clients who are converting data integration from other platforms to SSIS. In a recent meeting Kent mentioned “the 2:00 …
Continue reading The 2:00 AM Test