Robert Cain - Zero to Hero with PowerShell and SQL Server

Robert Cain - Zero to Hero with PowerShell and SQL Server

Today's DBA is under more pressure than before to manage ever increasing workloads. And not just in your local SQL Server installations, but now supporting cloud based databases in AzureSQL. But don't worry, there is an answer! Automation, using PowerShell.

In this course we'll look at using PowerShell with SQL Server. You'll see how to use the SQL Server PowerShell module to explore your SQL Server installation, then do more and more tasks such as backups, and executing scripts against your databases.

Next we'll branch out into the cloud, using PowerShell with your Azure SQL instance. You'll see how to take a local SQL Server database and import into Azure SQL, after which you'll see how to run scripts against your Azure SQL databases.

Finally, we'll roll up our sleeves and get low level. Underlying the SQL Server module is the SMO, or SQL Management Object library. You'll see how to connect directly to the SMO from PowerShell, often gaining big speed advantages over using the SQL Server module.

Come see example after example of ways you can automate your life with PowerShell and SQL Server.

Speaker Bio

Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.

FAQ

What should I bring to the event?

Wireless connectivity will be limited at the facility. Please bring your own hotspot if you plan to access the Internet during the presentation.

What's the refund policy?

Refunds are available through EventBrite up to 7 days before the event. Within 7 days, please contact the organizer for refund processing.