The PoSh DBA: Solutions using PowerShell and SQL Server

When you read about using PowerShell and SQL Server, you are usually learning about the way that you use PowerShell to access SQL Server. Sometimes, instead, you’ll want to use PowerShell directly from SQL Server to create solutions. You may want to do it from TSQL, getting data back in a form that can then be
inserted into a table, or execute it on the server from SSMS. You might want to run PowerShell scripts from the SQL Server Agent, or to set up sophisticated SQL Server Alerts using WMI that then execute jobs that are written in PowerShell. I’ll be showing you how to do all this.
Presented by Laerte Junior at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Laerte_Junior.jpg
    Laerte Junior is a Wuindows PowerShell MVP ,Database Consultant at Pythian Group and, through through his technology blog and simple-talk articles, an an active member of the SQL Server and PowerShell community around the World. He is a skilled Principal Database Architect, Developer, and Administrator, specializing in SQL Server and PowerShell Programming and Automation. He also is PASS Virtual Chapter Mentor , Co-Lead of the PASS PowerShell Virtual Chapter and former PASS Regional Mentor for Brasil. In addition He is also a HUGE Star Wars Fan, his main skill. "May The Force be with us"
    http://shellyourexperience.wordpress.com/
  • Video
    The video is not available to view online.