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 is a PASS RM,  Senior Powershell Expert Consultant at Confio Software and an active member of the Microsoft community in Brasil. He is a skilled Principal Database Architect, Developer, and Administrator, specializing in SQL Server and Powershell Programming with over 8 years of hands-on experience. He holds a degree in Computer Science and has accomplished a number of certifications (including MCDBA), and is an expert in SQL Server 2000 / SQL Server 2005 / SQL Server 2008 technologies. Also he is a HUGE Star Wars Fan, his main skill."May The Force be with us"
  • Video
    The video is not available to view online.