For all of us working with data, we know that we work no only with SQL Server but the suite of tools around the SQL Server engine. In this episode, we share some thoughts around SSIS administration, which is the most popular ETL tool in the Microsoft stack. Just like the SQL Server engine, many times the defaults are taken and in this episode we give some thoughts around logging, package execution, and notification with our guest Ravi Kumar. With the every expanding functionality of SSIS, Steve and I found this discussion insightful as we think about supporting an SSIS environment and ways we can educate package developers.
The show notes for today's episode can be found at http://sqldatapartners.com/2016/10/15/ssis-administration/ Have fun on the SQL trail!
Episode 177: Lock Pages in Memory
Episode 176: Power BI Storage Options
Episode 175: Migrating to the Cloud
Episode NULL: Summer Break
Episode 174: Power BI Report Server
Episode 173: New Data Certifications
Episode 172: Power BI Monitoring
Episode 171: SQL Server Encryption
Episode 170: Devops with Power BI
Episode 169: Should you learn to code?
Episode 168: Data Privacy Settings
Episode 167: Azure SQL Data Sync
Episode 166: Custom Visuals
Episode 165: Artificial Intelligence
Episode 164: The DAX Episode
Episode 163: Very Large Databases
Episode 162: Power Query vs DAX
Episode 161: Migrating/Upgrading 8000 databases
Episode 160: Power BI Embedded
Episode 159: Power BI Dataflows
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
Lex Fridman Podcast
The Unbelivable Truth - Series 1 - 26 including specials and pilot