eBook
Learn Dbatools in a Month of Lunches : Automating SQL Server Tasks with PowerShell Commands
| Τίτλος: | Learn Dbatools in a Month of Lunches : Automating SQL Server Tasks with PowerShell Commands |
|---|---|
| Περιγραφή: | 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 migrationsAutomate security audits, tempdb configuration, alerting, and reportingSchedule and monitor PowerShell tasks in SQL Server AgentBulk-import any type of data into SQL ServerInstall dbatools in secure environmentsWritten 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 technologyFor 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 bookLearn 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 insidePerforming instance-to-instance and customized migrationsAutomating security audits, best practices, and standardized configurationsAdministering SQL Server Agent including running PowerShell scripts effectivelyBulk-importing many types of data into SQL ServerExecuting advanced tasks and increasing efficiency for everyday administrationAbout the readerFor DBAs, accidental DBAs, and systems engineers who manage SQL Server.About the authorChrissy 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 Contents1 Before you begin2 Installing dbatools3 The dbatools lab4 A gentle introduction to dbatools commands5 Writing to SQL Server6 Finding SQL Server instances on your network7 Inventorying your SQL estate8 Registered Servers9 Logins and users10 Backups11 Restore12 Snapshots13 Install and update SQL Server14 Preparing for disaster15 Performing your first advanced SQL Server instance migration, part 116 Performing your first advanced SQL Server instance migration, part 217 High availability and disaster recovery18 PowerShell and SQL Server Agent19 SQL Server Agent administration20 Creating and working with SQL Server Agent objects21 Data masking22 DevOps automation23 Tracing SQL Server activity24 Security and encryption25 Data compression26 Validating your estate with dbachecks27 Working in the cloud28 dbatools configurations and logging29 Never the end |
| Συγγραφείς: | Chrissy LeMaire, Rob Sewell, Jess Pomfret, Cláudio Silva |
| Resource Type: | eBook. |
| Θέματα: | Database management--Computer programs, SQL (Computer program language) |
| Categories: | COMPUTERS / Database Administration & Management, COMPUTERS / Operating Systems / Windows Server, COMPUTERS / Distributed Systems / Client-Server Computing |
| Βάση Δεδομένων: | eBook Index |
| ISBN: | 9781617296703 9781638351269 |
|---|