{"product_id":"b0b39pchl8","title":"Learn dbatools in a Month of Lunches: Automating SQL server tasks with PowerShell commands","description":"\u003cp\u003eIf 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!\u003c\/p\u003e\n\n\u003cp\u003eIn  Learn dbatools in a Month of Lunches  you will learn how to:\u003c\/p\u003e\n\n\u003cp\u003ePerform instance-to-instance and customized migrations\u003cbr\u003e\nAutomate security audits, tempdb configuration, alerting, and reporting\u003cbr\u003e\nSchedule and monitor PowerShell tasks in SQL Server Agent\u003cbr\u003e\nBulk-import any type of data into SQL Server\u003cbr\u003e\nInstall dbatools in secure environments\u003c\/p\u003e\n\n\u003cp\u003eWritten 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.\u003c\/p\u003e\n\n\u003cp\u003eAbout the technology\u003cbr\u003e\nFor 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.\u003c\/p\u003e\n\n\u003cp\u003eAbout the book\u003cbr\u003e\nLearn 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.\u003c\/p\u003e\n\n\u003cp\u003eWhat's inside\u003c\/p\u003e\n\n\u003cp\u003ePerforming instance-to-instance and customized migrations\u003cbr\u003e\nAutomating security audits, best practices, and standardized configurations\u003cbr\u003e\nAdministering SQL Server Agent including running PowerShell scripts effectively\u003cbr\u003e\nBulk-importing many types of data into SQL Server\u003cbr\u003e\nExecuting advanced tasks and increasing efficiency for everyday administration\u003c\/p\u003e\n\n\u003cp\u003eAbout the reader\u003cbr\u003e\nFor DBAs, accidental DBAs, and systems engineers who manage SQL Server.\u003c\/p\u003e\n\n\u003cp\u003eAbout the author\u003cbr\u003e\nChrissy 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.\u003c\/p\u003e\n\n\u003cp\u003eTable of Contents\u003cbr\u003e\n1 Before you begin\u003cbr\u003e\n2 Installing dbatools\u003cbr\u003e\n3 The dbatools lab\u003cbr\u003e\n4 A gentle introduction to dbatools commands\u003cbr\u003e\n5 Writing to SQL Server\u003cbr\u003e\n6 Finding SQL Server instances on your network\u003cbr\u003e\n7 Inventorying your SQL estate\u003cbr\u003e\n8 Registered Servers\u003cbr\u003e\n9 Logins and users\u003cbr\u003e\n10 Backups\u003cbr\u003e\n11 Restore\u003cbr\u003e\n12 Snapshots\u003cbr\u003e\n13 Install and update SQL Server\u003cbr\u003e\n14 Preparing for disaster\u003cbr\u003e\n15 Performing your first advanced SQL Server instance migration, part 1\u003cbr\u003e\n16 Performing your first advanced SQL Server instance migration, part 2\u003cbr\u003e\n17 High availability and disaster recovery\u003cbr\u003e\n18 PowerShell and SQL Server Agent\u003cbr\u003e\n19 SQL Server Agent administration\u003cbr\u003e\n20 Creating and working with SQL Server Agent objects\u003cbr\u003e\n21 Data masking\u003cbr\u003e\n22 DevOps automation\u003cbr\u003e\n23 Tracing SQL Server activity\u003cbr\u003e\n24 Security and encryption\u003cbr\u003e\n25 Data compression\u003cbr\u003e\n26 Validating your estate with dbachecks\u003cbr\u003e\n27 Working in the cloud\u003cbr\u003e\n28 dbatools configurations and logging\u003cbr\u003e\n29 Never the end\u003c\/p\u003e","brand":"ANT","offers":[{"title":"Ebook","offer_id":52830755946712,"sku":"YSL49213","price":29.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0835\/3356\/2072\/files\/7122gSosEBL._SY1500.jpg?v=1793193313","url":"https:\/\/www.bookmebay.com\/products\/b0b39pchl8","provider":"BookMebay","version":"1.0","type":"link"}