Learn Dbatools in a Month of Lunches: Automating SQL Server Tasks with Powershell Commands by Lemaire, Chrissy
Learn Dbatools in a Month of Lunches: Automating SQL Server Tasks with Powershell Commands by Lemaire, Chrissy

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...
HK$966.37
HK$966.37
SKU: 9781617296703
Product Type: Books
Please hurry! Only 45 left in stock
Author: Chrissy Lemaire
Format: Paperback
Language: English
Subtotal: $966.37
10 customers are viewing this product
Learn Dbatools in a Month of Lunches: Automating SQL Server Tasks with Powershell Commands by Lemaire, Chrissy

Learn Dbatools in a Month of Lunches: Automating SQL Server Tasks with Powershell Commands

$966.37
Learn Dbatools in a Month of Lunches: Automating SQL Server Tasks with Powershell Commands by Lemaire, Chrissy

Learn Dbatools in a Month of Lunches: Automating SQL Server Tasks with Powershell Commands

$966.37
Author: Chrissy Lemaire
Format: Paperback
Language: English
Description
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.

Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

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

Author: Chrissy Lemaire, Rob Sewell, Cláudio Silva
Publisher: Manning Publications
Published: 07/12/2022
Pages: 400
Binding Type: Paperback
Weight: 1.30lbs
Size: 9.13h x 7.24w x 0.94d
ISBN: 9781617296703

About the Author
Lemaire, Chrissy: - Chrissy LeMaire is a dual Microsoft MVP, awarded for her work with both SQL Server and PowerShell. She is an international speaker and the creator of the popular PowerShell module, dbatools. She has over 20 years of IT experience and currently works for General Dynamics Information Technology at NATO Special Ops HQ in Belgium.Sewell, Rob: - Rob Sewell is a passionate automator who has been recognized as an MVP by Microsoft. He is a keen community contributor as an event organizer, speaker and open-source contributor.Silva, Cláudio: - Cláudio Silva is a database professional, automator, and contributor of the open-source PowerShell module dbatools.
Et al...
Shipping & Return

Returns Policy

You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Review

Related Products

Example product title
HK$966.37
HK$966.37
Example product title
HK$966.37
HK$966.37
Example product title
HK$966.37
HK$966.37
Example product title
HK$966.37
HK$966.37
Example product title
HK$966.37
HK$966.37
Example product title
HK$966.37
HK$966.37
Example product title
HK$966.37
HK$966.37
Example product title
HK$966.37
HK$966.37
Example product title
HK$966.37
HK$966.37
Example product title
HK$966.37
HK$966.37

Recently Viewed Products