{"product_id":"9781617296703","title":"Learn dbatools in a Month of Lunches: Automating SQL server tasks with PowerShell commands","description":"\u003ctable\u003e\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd style=\"\"\u003e\u003cstrong\u003eAuthor\/Contributor(s):\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd style=\"\"\u003eLeMaire, Chrissy; Sewell, Rob; Silva , Cláudio; Pomfret, Jess\u003cbr\u003e\n\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd style=\"\"\u003e\u003cstrong\u003ePublisher:\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003eManning\u003cbr\u003e\n\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd style=\"\"\u003e\u003cstrong\u003eDate:\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003e7\/12\/2022\u003cbr\u003e\n\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd style=\"\"\u003e\u003cstrong\u003eBinding:\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd style=\"\"\u003ePaperback\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd style=\"\"\u003e\u003cstrong\u003eCondition:\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd style=\"\"\u003eNEW\u003cbr\u003e\n\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\u003c\/table\u003e\u003cb\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\/b\u003e\u003cbr\u003e\u003cbr\u003eIn \u003ci\u003eLearn dbatools in a Month of Lunches\u003c\/i\u003e you will learn how to:\u003cbr\u003e\u003cbr\u003ePerform instance-to-instance and customized migrations\u003cbr\u003eAutomate security audits, tempdb configuration, alerting, and reporting\u003cbr\u003eSchedule and monitor PowerShell tasks in SQL Server Agent\u003cbr\u003eBulk-import any type of data into SQL Server\u003cbr\u003eInstall dbatools in secure environments\u003cbr\u003e\u003cbr\u003eWritten by a group of expert authors including dbatools creator Chrissy LeMaire, \u003ci\u003eLearn dbatools in a Month of Lunches\u003c\/i\u003e 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.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the technology\u003c\/b\u003e\u003cbr\u003eFor 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.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the book\u003c\/b\u003e\u003cbr\u003e\u003ci\u003eLearn dbatools in a Month of Lunches\u003c\/i\u003e 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.\u003cbr\u003e\u003cbr\u003eWhat's inside\u003cbr\u003e\u003cbr\u003ePerforming instance-to-instance and customized migrations\u003cbr\u003eAutomating security audits, best practices, and standardized configurations\u003cbr\u003eAdministering SQL Server Agent including running PowerShell scripts effectively\u003cbr\u003eBulk-importing many types of data into SQL Server\u003cbr\u003eExecuting advanced tasks and increasing efficiency for everyday administration\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the reader\u003c\/b\u003e\u003cbr\u003eFor DBAs, accidental DBAs, and systems engineers who manage SQL Server.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the author\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eChrissy LeMaire\u003c\/b\u003e is a GitHub Star and the creator of dbatools. \u003cb\u003eRob Sewell\u003c\/b\u003e is a data engineer and a passionate automator. \u003cb\u003eJess Pomfret\u003c\/b\u003e and \u003cb\u003eCláudio Silva\u003c\/b\u003e are data platform architects. All are Microsoft MVPs.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e1 Before you begin\u003cbr\u003e2 Installing dbatools\u003cbr\u003e3 The dbatools lab\u003cbr\u003e4 A gentle introduction to dbatools commands\u003cbr\u003e5 Writing to SQL Server\u003cbr\u003e6 Finding SQL Server instances on your network\u003cbr\u003e7 Inventorying your SQL estate\u003cbr\u003e8 Registered Servers\u003cbr\u003e9 Logins and users\u003cbr\u003e10 Backups\u003cbr\u003e11 Restore\u003cbr\u003e12 Snapshots\u003cbr\u003e13 Install and update SQL Server\u003cbr\u003e14 Preparing for disaster\u003cbr\u003e15 Performing your first advanced SQL Server instance migration, part 1\u003cbr\u003e16 Performing your first advanced SQL Server instance migration, part 2\u003cbr\u003e17 High availability and disaster recovery\u003cbr\u003e18 PowerShell and SQL Server Agent\u003cbr\u003e19 SQL Server Agent administration\u003cbr\u003e20 Creating and working with SQL Server Agent objects\u003cbr\u003e21 Data masking\u003cbr\u003e22 DevOps automation\u003cbr\u003e23 Tracing SQL Server activity\u003cbr\u003e24 Security and encryption\u003cbr\u003e25 Data compression\u003cbr\u003e26 Validating your estate with dbachecks\u003cbr\u003e27 Working in the cloud\u003cbr\u003e28 dbatools configurations and logging\u003cbr\u003e29 Never the end","brand":"Manning","offers":[{"title":"Default Title","offer_id":48176680960255,"sku":"9781617296703","price":59.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0452\/0886\/2873\/files\/Jacket_dabad73c-1c7b-477f-b6ab-3bdfa07f593b.jpg?v=1771351316","url":"https:\/\/massivebookshop.com\/de\/products\/9781617296703","provider":"MASSIVE BOOKSHOP","version":"1.0","type":"link"}