Ever wanted to know what happens behind the scenes in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high-efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behind the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You’ll be glad you did.
Who is Ben?
About Ben Miller: Ben has been a member of the SQL Server Community for over 14 years now. He is currently an Enterprise DBA Architect for HealthEquity, a Health Savings Account Provider in Draper, Utah. He is a 3 year SQL Server MVP, a SQL Server 2008 MCM and has spent time in the field using SQL Server since 1997. He has worked at various companies throughout the US as well as at Microsoft for 7 years. He is passionate about SQL Server and automation and integration. Contact URL: http://dbaduck.com
Don’t forget to go to our LinkedIn site to join and register. Hope to see everyone there!