The Powershell Conference Book

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.

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

With more than 250 ready-to-use recipes, this solutions-oriented introduction to the Windows PowerShell scripting environment and language provides administrators with the tools to be productive immediately.

If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine—all in just one month! In Learn dbatools in a Month of Lunches you will learn how to: Perform instance-to-instance and customized migrations Automate security audits, tempdb configuration, alerting, and reporting Schedule and monitor PowerShell tasks in SQL Server Agent Bulk-import any type of data into SQL Server Install dbatools in secure environments Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible. In twenty-eight lunchbreak lessons, you’ll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool. About the technology For SQL Server DBAs, automation is the key to efficiency. Using the open-source dbatools PowerShell module, you can easily execute tasks on thousands of database servers at once—all from the command line. dbatools gives you over 500 pre-built commands, with countless new options for managing SQL Server at scale. There’s nothing else like it. About the book Learn dbatools in a Month of Lunches teaches you how to automate SQL Server using the dbatools PowerShell module. Each 30-minute lesson introduces a new automation that will make your daily duties easier. Following the expert advice of dbatools creator Chrissy LeMaire and other top community contributors, you’ll learn to script everything from backups to disaster recovery. What's inside Performing instance-to-instance and customized migrations Automating security audits, best practices, and standardized configurations Administering SQL Server Agent including running PowerShell scripts effectively Bulk-importing many types of data into SQL Server Executing advanced tasks and increasing efficiency for everyday administration About the reader For DBAs, accidental DBAs, and systems engineers who manage SQL Server. About the author Chrissy LeMaire is a GitHub Star and the creator of dbatools. Rob Sewell is a data engineer and a passionate automator. Jess Pomfret and Cláudio Silva are data platform architects. All are Microsoft MVPs. Table of Contents 1 Before you begin 2 Installing dbatools 3 The dbatools lab 4 A gentle introduction to dbatools commands 5 Writing to SQL Server 6 Finding SQL Server instances on your network 7 Inventorying your SQL estate 8 Registered Servers 9 Logins and users 10 Backups 11 Restore 12 Snapshots 13 Install and update SQL Server 14 Preparing for disaster 15 Performing your first advanced SQL Server instance migration, part 1 16 Performing your first advanced SQL Server instance migration, part 2 17 High availability and disaster recovery 18 PowerShell and SQL Server Agent 19 SQL Server Agent administration 20 Creating and working with SQL Server Agent objects 21 Data masking 22 DevOps automation 23 Tracing SQL Server activity 24 Security and encryption 25 Data compression 26 Validating your estate with dbachecks 27 Working in the cloud 28 dbatools configurations and logging 29 Never the end

"In many ways, this is The Phoenix Project for the PowerShell world." Introduced in 2006, Microsoft's PowerShell made an immediate, positive impact on its server products and in the lives of the people who administer them. The world's first object-oriented shell, the first designed-from-scratch shell for the Windows operating system, and now a cross-platform management shell, PowerShell's technical achievement is significant. It's easy to look at where PowerShell is today, and not realize or remember the long and sometimes-difficult road it took to get there. What if Microsoft's "next-gen" shell had been nothing more than a port of the Unix KornShell to Windows? What if PowerShell had never become a default, built-in component of the Windows operating system? What if PowerShell had simply been called, "Microsoft Shell?" Yeah, all of those things almost happened. In the end, the story of PowerShell is less about the technology, and more about the people who brought it to life, and the people who use it every day. It's about how one small band of passionate, crazy people with a vision can bring something wonderful into the world, in small, incremental, deliberate steps. It's about how the right people came together at the right time and did the right thing, and about the enormous community that rallied around them to make the whole thing an incredible success. Author Don Jones was with PowerShell from the beginning, and through a series of core team interviews, community discussions, and background research, he brings you this: the untold story of PowerShell, a Shell of an Idea.

Here's the complete guide to Windows PowerShell 2.0 for administrators and developers Windows PowerShell is Microsoft's next-generation scripting and automation language. This comprehensive volume provides the background that IT administrators and developers need in order to start using PowerShell automation in exciting new ways. It explains what PowerShell is, how to use the language, and specific ways to apply PowerShell in various technologies. Windows PowerShell is Microsoft's standard automation tool and something that every Windows administrator will eventually have to understand; this book provides the background necessary to apply PowerShell automation. Covers how to use the language and specific ways to apply PowerShell in a variety of scenarios Addresses new features in the latest version of PowerShell and the additional functionality delivered by new products that provide direct or indirect ways to use PowerShell for scripting and automation purposes Explores the language fundamentals and how to use PowerShell for desktop, server, server application, and virtualization/cloud situations This thorough guide goes well beyond theory to offer real-world information and new scripting techniques, enabling administrators and developers to make the most of PowerShell 2.0.

Microsoft Exchange Server 2013 is a complex messaging system. Windows PowerShell 5 can be used in conjunction with Exchange Server 2013 to automate and manage routine and complex tasks to save time and money and eliminate errors. Starting by going through key PowerShell concepts and the Exchange Management Shell, this book will get you automating tasks that used to take hours in no time. Diving deeper, you will then manage your mailbox database, client access, and your transport servers with simple but effective scripts. This book finishes with advanced recipes on Exchange Server problems, such as managing distribution groups and maintaining high availability and security.

Designed for busy IT professionals, this innovative guide will take you from the basics to PowerShell proficiency through 25 tutorials you can do in your lunch break. Learn PowerShell in a Month of Lunches, Fourth Edition is a task-focused guide for administering your systems using PowerShell. It covers core language features and admin tasks, with each chapter a mini-tutorial you can easily complete in under an hour. Discover how PowerShell works on different operating systems, and start automating tasks so they take just a few seconds to complete. No previous scripting experience required. The book is based on the bestselling Learn Windows PowerShell in a Month of Lunches by community legends Don Jones and Jeffery Hicks. PowerShell team members Travis Plunk and Tyler Leonhardt and Microsoft MVP James Petty have updated this edition to the latest version of PowerShell, including its multi-platform expansion into Linux and macOS. PowerShell gives you complete command line control over admin tasks like adding users, exporting data, and file management. Whether you're writing one-liners or building complex scripts to manage cloud resources and CI/CD pipelines, PowerShell can handle the task. And now that PowerShell is truly cross-platform, you don't have to switch scripting languages when you move between Windows, Linux, and macOS. Learn PowerShell in a Month of Lunches, Fourth Edition is a new edition of the bestseller that introduced PowerShell to over 100,000 readers. With bite-sized lessons and hands-on exercises, this amazing book guides you from your first command to writing and debugging reusable scripts for Windows, Linux, and macOS. Set aside just an hour a day and you'll soon be tackling increasingly complex automation tasks with PowerShell.