Target New ArrivalsGift Ideas for MomClothing, Shoes & AccessoriesHomeKitchen & DiningOutdoor Living & GardenFurnitureGroceryHousehold EssentialsBabyBeautyPersonal CareHealthWellnessLuggageSports & OutdoorsToysElectronicsVideo GamesMovies, Music & BooksSchool & Office SuppliesParty SuppliesGift IdeasGift CardsPetsUlta Beauty at TargetTarget OpticalDealsClearanceTarget New ArrivalsSpring OutfitsGift Ideas for MomWomen’s Festival OutfitsTop DealsTarget Circle DealsWeekly AdShop Order PickupShop Same Day DeliveryRegistryRedCardTarget CircleFind Stores
Expert Scripting and Automation for SQL Server DBAs - 2nd Edition by  Peter A Carter (Paperback) - 1 of 1

Expert Scripting and Automation for SQL Server DBAs - 2nd Edition by Peter A Carter (Paperback)

$59.99Save $5.00 (8% off)

In Stock

Eligible for registries and wish lists

About this item

Highlights

  • The market is trending toward a much smaller ratio of DBAs to SQL Server instances, but this book will help you meet this new reality by harnessing automation to continue building and maintaining reliable database platform services for your SQL Server enterprise.
  • About the Author: Peter Carter is a SQL Server expert with two decades of experience developing, administering, and architecting SQL Server platforms and data-tier applications.
  • 290 Pages
  • Computers + Internet, Databases

Description



Book Synopsis



The market is trending toward a much smaller ratio of DBAs to SQL Server instances, but this book will help you meet this new reality by harnessing automation to continue building and maintaining reliable database platform services for your SQL Server enterprise. The book will help you automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with the power of PowerShell. You'll soon be able to automate your new instance-builds and centralize your maintenance.

This book walks you through automating the SQL Server build processes and maintenance of multiple instances from a single location, as well as how to use database metadata to drive your automation. With a heavier focus on PowerShell, this 2nd edition highlights modern techniques, such as configuration management. Also new in this edition, you will learn how to use PowerShell modules such as SqlServer and DBATools, which is a popular community module that you can rely on to keep your database estate running smoothly. You will understand the benefits of centralizing maintenance to better keep your enterprise responding with reliable performance to the loads placed upon it by your business. The book helps you become faster and better at what you do for a living, and thus will boost your value within the job market.

What You Will Learn

  • Automate SQL Server installation and configuration
  • Apply techniques such as Desired State Configuration to prevent drift on your servers and instances
  • Increase your value to your organization by automating low-value tasks and focusing your time on the higher-value ones
  • Take advantage of database metadata to drive automation, allowing you to build intelligent automated routines
  • Promote and demonstrate how to modernize database maintenance across your enterprise
  • Apply tools such as PowerShell with modern techniques to increase your value in the job market

Who This Book Is For

SQL Server DBAs who want to increase their productivity by embracing automation



From the Back Cover



The market is trending toward a much smaller ratio of DBAs to SQL Server instances, but this book will help you meet this new reality by harnessing automation to continue building and maintaining reliable database platform services for your SQL Server enterprise. The book will help you automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with the power of PowerShell. You'll soon be able to automate your new instance-builds and centralize your maintenance.

This book walks you through automating the SQL Server build processes and maintenance of multiple instances from a single location, as well as how to use database metadata to drive your automation. With a heavier focus on PowerShell, this 2nd edition highlights modern techniques, such as configuration management. Also new in this edition, you will learn how to use PowerShell modules such as SqlServer and DBATools, which is a popular community module that you can rely on to keep your database estate running smoothly. You will understand the benefits of centralizing maintenance to better keep your enterprise responding with reliable performance to the loads placed upon it by your business. The book helps you become faster and better at what you do for a living, and thus will boost your value within the job market.

What You Will Learn

  • Automate SQL Server installation and configuration
  • Apply techniques such as Desired State Configuration to prevent drift on your servers and instances
  • Increase your value to your organization by automating low-value tasks and focusing your time on the higher-value ones
  • Take advantage of database metadata to drive automation, allowing you to build intelligent automated routines
  • Promote and demonstrate how to modernize database maintenance across your enterprise
  • Apply tools such as PowerShell with modern techniques to increase your value in the job market



About the Author



Peter Carter is a SQL Server expert with two decades of experience developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, and currently leads a team of platform engineers within a major UK company. His passion for SQL Server shows through in everything he does, and has written a number of SQL Server books (Apress), including Pro SQL Server 2022 Administration, SQL Server Advanced Data Types, Securing SQL Server, and SQL Server 2019 AlwaysOn.

Dimensions (Overall): 10.0 Inches (H) x 7.0 Inches (W) x .65 Inches (D)
Weight: 1.18 Pounds
Suggested Age: 22 Years and Up
Number of Pages: 290
Genre: Computers + Internet
Sub-Genre: Databases
Publisher: Apress
Theme: General
Format: Paperback
Author: Peter A Carter
Language: English
Street Date: May 21, 2025
TCIN: 1003133853
UPC: 9798868811500
Item Number (DPCI): 247-02-8862
Origin: Made in the USA or Imported
If the item details aren’t accurate or complete, we want to know about it.

Shipping details

Estimated ship dimensions: 0.65 inches length x 7 inches width x 10 inches height
Estimated ship weight: 1.18 pounds
We regret that this item cannot be shipped to PO Boxes.
This item cannot be shipped to the following locations: American Samoa (see also separate entry under AS), Guam (see also separate entry under GU), Northern Mariana Islands, Puerto Rico (see also separate entry under PR), United States Minor Outlying Islands, Virgin Islands, U.S., APO/FPO, Alaska, Hawaii

Return details

This item can be returned to any Target store or Target.com.
This item must be returned within 90 days of the date it was purchased in store, delivered to the guest, delivered by a Shipt shopper, or picked up by the guest.
See the return policy for complete information.

Q: What topics does the book primarily cover?

submitted by AI Shopping Assistant - 23 days ago
  • A: The book focuses on automating SQL Server tasks, managing instances, and using PowerShell for database maintenance and build processes.

    submitted byAI Shopping Assistant - 23 days ago
    Ai generated

Q: How can this book benefit SQL Server professionals?

submitted by AI Shopping Assistant - 23 days ago
  • A: It helps professionals automate low-value tasks, enabling them to focus on higher-value responsibilities, thus enhancing job market value.

    submitted byAI Shopping Assistant - 23 days ago
    Ai generated

Q: What techniques are emphasized in the 2nd edition?

submitted by AI Shopping Assistant - 23 days ago
  • A: The 2nd edition emphasizes automation techniques, metadata-driven approaches, and the use of tools like PowerShell and DBATools.

    submitted byAI Shopping Assistant - 23 days ago
    Ai generated

Q: What modern techniques are introduced in this edition?

submitted by AI Shopping Assistant - 23 days ago
  • A: This edition introduces configuration management techniques and PowerShell modules to improve automation and database maintenance efficiency.

    submitted byAI Shopping Assistant - 23 days ago
    Ai generated

Q: Who is the target audience for this book?

submitted by AI Shopping Assistant - 23 days ago
  • A: SQL Server DBAs looking to increase their productivity and embrace automation in their database management practices.

    submitted byAI Shopping Assistant - 23 days ago
    Ai generated

Additional product information and recommendations

Get top deals, latest trends, and more.

Privacy policy

Footer

About Us

About TargetCareersNews & BlogTarget BrandsBullseye ShopSustainability & GovernancePress CenterAdvertise with UsInvestorsAffiliates & PartnersSuppliersTargetPlus

Help

Target HelpReturnsTrack OrdersRecallsContact UsFeedbackAccessibilitySecurity & FraudTeam Member ServicesLegal & Privacy

Stores

Find a StoreClinicPharmacyTarget OpticalMore In-Store Services

Services

Target Circle™Target Circle™ CardTarget Circle 360™Target AppRegistrySame Day DeliveryOrder PickupDrive UpFree 2-Day ShippingShipping & DeliveryMore Services
PinterestFacebookInstagramXYoutubeTiktokTermsCA Supply ChainPrivacy PolicyCA Privacy RightsYour Privacy ChoicesInterest Based AdsHealth Privacy Policy