PowerShell comes with specific options for outputting objects in normal, wide, and list views. But you can create your own formats using some PowerShell know-how and XML as this video excerpt from Jimmy Skowronski’s new course Extending PowerShell shows. In the video Jimmy shows how to create an XML format file for your objects and what elements to use to customize the output. In the full course he also shows pipeline processing, using dynamic parameters, and risk management.
PowerShell version 3 has some nifty new features to enable IT professionals to create even more robust scripts. In this video excerpt from Robert Cain’s new course What’s New in PowerShell Version 3 you’ll see how to use the new workflow features to execute tasks in parallel. In the full course Robert covers new commandlets such as export-csv and out-gridview as well as key concepts like the new PowerShell ISE and support for oData.
No, we don’t mean inflating your estimates. Sandbagging is the process of defining a series of DIV elements to force text to wrap around non-rectangular objects on a web page. In this video excerpt from Jim Christopher’s new course Everyday PowerShell for Developers you’ll see how to create a PowerShell script to create the DIV elements required to create the affect you’re looking for. In the full course Jim covers using .NET from PowerShell, working with Mercurial, and automating Visual Studio with StudioShell.
PowerShell version 3 is packed with more new features than you can count. But that didn’t stop Thomas Lee from counting the Top 10 Cool PowerShell v3 Features with Windows Server 2012. In this excerpt from that course we look at Tip #6, using PowerShell Web Access to remotely manage servers. In the full course Thomas covers other features such as improved syntax, workflow, and robust remoting.
In today’s episode of our Meet the Author podcast series, Fritz Onion talks to Thomas Lee about his course Creating PowerShell Modules. In the interview Thomas explains what PowerShell modules are and how they can improve the portability and reusability of your PowerShell functionality. He also describes some of the differences between PowerShell version 2 and version 3 as well as how PowerShell modules can be distributed.
Listen to the Audio (MP3)
[Fritz] Hi, this is Fritz Onion. I’m here today speaking with Thomas Lee about his new course Creating PowerShell Modules. Thomas is an IT industry veteran of over forty years. He’s been involved in Microsoft products since the very beginning of the IBM PC and DOS. He provides consultancy and training around a range of Microsoft products concentrating recently on PowerShell and Lync Server. Thomas has been a Microsoft MVP for sixteen of the past seventeen years and runs PowerShell training courses around the world. Thanks for joining me Thomas.
[Thomas] Thanks Fritz, nice to be here.
In today’s episode in our Meet the Author podcast series, Mike Woodring talks to Robert Cain about his course PowerShell and SQL Server. In the interview Robert discusses how his passion for programming began before moving on to a description of why he felt that a course combining PowerShell and SQL Server would be of use to both DBAs and developers. He also discusses some of the capabilities that are exposed to PowerShell via the SQL Management Objects as well as the SQL Provider. Lastly he covers a few of the new features coming available in PowerShell 3.
Listen to the Audio (MP3)
[Mike] Hello this is Mike Woodring with another Pluralsight author interview. Today I am talking with Robert Cain about his new course Powershell and SQL Server. Robert Cain is a Microsoft MVP in SQL Server, MCTS certified in Business Intelligence and works as a senior consultant for Pragmatic Works. He is coauthor of volumes one and two of SQL Server MVP Deep Dives as well as Professional SQL Server 2012 Administration. A popular speaker Robert is presented at events such as TechEd, SQL Rally and numerous SQL Saturdays and Roberts’s popular blog on SQL Server and Powershell topics can be found at arcanecode.com. Well hello Robert and thank you for being here today.
[Robert] Hi Mike, thanks for having me.
Modules are a good way to organize your PowerShell scripts into easily reusable fragments. In this video excerpt from Thomas Lee’s new course Creating PowerShell Modules you’ll see how to convert a PowerShell script to a module and various ways to load and execute it. In the full course Thomas also covers topics such as new module features in PowerShell v3, binary and manifest modules, and dynamic modules.
No Uber-scripting language would be complete without the ability to store and retrieve data from a database. In this video excerpt from Robert Cain’s new course PowerShell and SQL Server you’ll see how to use the Invoke-SqlCmd commandlet to query a SQL Server database and how to inspect the data it returns. In the full course he also covers topics such as performing basic DBA tasks, developer-centric tasks, and real world topics.
Want to know an easy way to view WMI Objects and set their value? In this video excerpt from Thomas Lee’s course WMI and Powershell you’ll learn exactly how to read WMI objects for items such as file shares, BIOS info, and logical disk properties. In the full course Thomas also covers WMI Type Accelerators, WMI Security, and using the WMI query language.
Did you know that PowerShell has powerful formatting features that allow you to change the output of your PowerShell commands including built in commands? In this video excerpt from Thomas Lee’s course Formatting with PowerShell you’ll see how to use hashtables to format output from the built in Get-Process command as well as how to use them with Format-Table and Format-List. In the full course Thomas goes on to cover other advanced formatting topics such as pipeline formatting, format files, display XMLs, and even outputting Office documents and HTML.