Summary Here's your chance to learn from the best in the business. PowerShell Deep Dives is a trove of essential techniques, practical guidance, and the expert insights you earn only through years of experience. Editors Jeffery Hicks, Richard Siddaway, Oisin Grehan, and Aleksandar Nikolic hand-picked the 28 chapters in the book's four parts: Administration, Scripting, Development, and Platforms. About the Technology PowerShell has permanently changed Windows administration. This powerful scripting and automation tool allows you to control virtually every aspect of Windows and most Microsoft servers like IIS and SQL Server. Here's your chance to learn from the best in the business. About this Book PowerShell Deep Dives is a trove of essential techniques and practical guidance. It is rich with insights from experts who won them through years of experience. The book's 28 chapters, grouped in four parts (Administration, Scripting, Development, and Platforms), were hand-picked by four section editors: Jeffery Hicks, Richard Siddaway, Oisin Grehan, and Aleksandar Nikolic. Whether you're just getting started with PowerShell or you already use it daily, you'll find yourself returning to this book over and over. What's Inside Managing systems through a keyhole The Ten Commandments of PowerShell scripting Scalable scripting for large datasets Adding automatic remoting Provisioning web servers and websites automatically to IIS 8 And 23 more fantastic chapters Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the AuthorsEditors Jeffery Hicks, Richard Siddaway, Oisin Grehan, and Aleksandar Nikolic are joined by PowerShell experts Chris Bellee, Bartek Bielawski, Robert C. Cain, Jim Christopher, Adam Driscoll, Josh Gavant, Jason Helmick, Don Jones, Ashley McGlone, Jonathan Medd, Ben Miller, James O'Neill, Arnaud Petitjean, Vadims Podans, Karl Prosser, Boe Prox, Matthew Reynolds, Mike Robbins, Donabel Santos, Will Steele, Trevor Sullivan, and Jeff Wouters. Table of Contents PART 1 POWERSHELL ADMINISTRATION Diagnosing and troubleshooting PowerShell remoting CIM sessions 22 Collecting and analyzing performance counter data TCP port communications with PowerShell Managing systems through a keyhole Using PowerShell to audit user logon events Managing and administering a certification authoritydatabase with PowerShell Using PowerShell to reduce Active Directory token bloat PART 2 POWERSHELL SCRIPTING The 10 PowerShell scripting commandments Avoiding the pipeline A template for handling and reporting errors Tips and tricks for creating complex or advancedHTML reports with PowerShell Using and "abusing" dynamic parameters PowerShell type formatting Scalable scripting for large data sets: pipelineand database techniques Building your own WMI-based cmdlets Turning command-line tools into PowerShell tools PART 3 POWERSHELL FOR DEVELOPERS Using Source Control Software with PowerShell Inline .NET code PowerShell and XML: better together Adding automatic remoting to advanced functionsand cmdlets Taming software builds (and other complicated processes)with psake PART 4 POWERSHELL PLATFORMS PowerShell and the SQL Server provider Creating flexible subscriptions in SSRS Inventory database table statistics using PowerShellSQL Server Management Objects WSUS and PowerShell Provisioning IIS web servers and sites with PowerShell Active Directory Group Management application

Summary SQL Server MVP Deep Dives, Volume 2 is a unique book that lets you learn from the best in the business - 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques...and more. About this Book To become an MVP requires deep knowledge and impressive skill. Together, the 64 MVPs who wrote this book bring about 1,000 years of experience in SQL Server administration, development, training, and design. This incredible book captures their expertise and passion in 60 concise, hand-picked chapters and offers valuable insights for readers of all levels. SQL Server MVP Deep Dives, Volume 2 picks up where the first volume leaves off, with completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization. The chapters fall into five parts: Architecture and Design, Database Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book. What's Inside Discovering servers with PowerShell Using regular expressions in SSMS Tuning the Transaction Log for OLTP Optimizing SSIS for dimensional data Real-time BI and much more Manning Publications and the authors of this book support the children of Operation Smile, an international children's medical charity that performs free reconstructive surgery for children suffering from facial deformities such as cleft lips and cleft palates by mobilizing medical volunteers who provide education and training programs to local doctors on the latest surgical techniques. =============================================== Table of Contents PART 1 ARCHITECTURE Edited by Louis Davidson PART 2 DATABASE ADMINISTRATION Edited by Paul Randal and Kimberly Tripp PART 3 DATABASE DEVELOPMENT Edited by Paul Nielsen PART 4 PERFORMANCE TUNING AND OPTIMIZATION Edited by Brad M. McGehee PART 5 BUSINESS INTELLIGENCE Edited by Greg Low

Want to perform programming tasks better, faster, simpler, and make them repeatable? Take a deep dive into Windows PowerShell and discover what this distributed automation platform can do. Whether you’re a .NET developer or IT pro, this concise guide will show you how PowerShell’s scripting language can help you be more productive on everyday tasks. Quickly learn how to create PowerShell scripts and embed them into your existing applications, write "little languages" to solve specific problems, and take charge of your code. This book includes example scripts that you can easily pull apart, tweak, and then use in your own PowerShell and .NET solutions. Slice and dice text, XML, CSV, and JSON with ease Embed PowerShell to provide scripting capabilities for your C# apps Create GUI applications five to ten times faster with less code Leverage PowerShell’s capabilities to work with the Internet Interact with DLLs and create objects, automatically display properties, and call methods in live interactive sessions Build domain-specific languages (DSLs) and vocabularies to express solutions more clearly Work with Microsoft Office via the Component Object Model (COM) Discover PowerShell v3 features included with Windows 8 and Windows Server 2012

This book is designed to be like a conference in a book where each chapter is written by a different author who is a subject matter expert on the topic covered in their chapter. Each chapter is also independent of the others so you can read one chapter, ten chapters, or all of them. You can start with the first chapter, the last one, or somewhere in-between and not miss out on anything related to that particular topic. This book is written for the intermediate to advanced audience. Prior experience with PowerShell is highly recommended.100% of the royalties from this book are donated to the PowerShell + DevOps Global Summit's OnRamp Scholarship Program. Learn more at PowerShellSummit.org.

Scripting gurus Jones and Hicks teach readers PowerShell from the ground up. They cover its underlying technologies, flexible scripting language, and enough of the .NET Framework to be effective in PowerShell scripting. (Computer Books)

Summary PowerShell and WMI is an example-driven guide for administrators managing networks of Windows servers and desktops. With 150 practical examples, including ready-to-reuse scripts and techniques, you'll learn the ins and outs of automating WMI via PowerShell v3. You'll also find deep coverage of all aspects of Windows administration, including IIS, DNS and Hyper-V. About the Technology WMI, on its own, is simply a collection of Windows management facilities. Paired with PowerShell, however, WMI becomes a brilliant toolset for automating servers, networks, and remote Windows computers. About the Book PowerShell and WMI is an industrial-strength guide for administrators of Windows networks, servers, and desktops. You'll start with practical overviews of PowerShell and of WMI. Then you'll explore 150 specific examples—all with ready-to-use scripts—designed to simplify your day-to-day system management. Each tested technique is configured to load as part of a PowerShell module. A set of handy appendixes includes references for PowerShell and WMI. Prior exposure to PowerShell and WMI is helpful but not required. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book. What's Inside Managing Windows, IIS, and Hyper-V Remote desktops and devices Logs, jobs, and performance New PowerShell v3 WMI functionality =============================== Table of Contents PART 1 TOOLS OF THE TRADE Solving administrative challenges Using PowerShell WMI in depth Best practices and optimization PART 2 WMI IN THE ENTERPRISE? System documentation Disk systems Registry administration Filesystem administration Services and processes Printers Configuring network adapters Managing IIS Configuring a server Users and security Logs, jobs, and performance Administering Hyper-V with PowerShell and WMI PART 3 THE FUTURE: POWERSHELL V3 AND WMI WMI over WSMAN Your own WMI cmdlets CIM cmdlets and sessions

This portable reference to Windows PowerShell 3.0 summarizes the command shell and scripting language, and provides a concise reference to the many tasks that make PowerShell so useful. If you’re a busy Windows administrator, and don’t have time to plow through huge books or search online, this is the ideal on-the-job tool. Written by Microsoft PowerShell team member Lee Holmes, and excerpted from his Windows PowerShell Cookbook, this edition offers up-to-date coverage of PowerShell 3.0. You’ll find information on the .NET classes and legacy tools you need to manage your system, along with chapters on how to write scripts, manage errors, and format output. Beginning with a guided tour of Windows PowerShell, this handy guide covers: PowerShell language and environment Regular expression reference XPath quick reference .NET string formatting .NET DateTime formatting Selected .NET classes and their uses WMI reference Selected COM objects and their uses Selected events and their uses Standard PowerShell verbs