- Home Page /
- Books /
- Computers & Technology /
- Databases & Big Data /
- Data Processing /
- SQL Server 2019 Administrator's Guide: A defi...
Item #:
34832885
SQL Server 2019 Administrator's Guide: A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions, 2nd Edition
Item #:
34832885
0 ratings
Write a review
Out of stock
Imported from USA store
Secured transaction
Ubuy works hard to protect your security and privacy. Our advanced payment security system ensures confidentiality by encrypting your information during transmission using AES (Advanced Encryption Standards) and SSL (Secure Socket Layer) protocols. Your payment details are 100% secure as we do not share your payment details with third party sellers.
Our Top Logistics Partners
Fast
Shipping
Free
Return*
Secure Packaging
100% Original Products
PCI DSS Compliance
ISO 27001 Certified
Note: Step Down Voltage Transformer required for using electronics products of US store (110-120). Recommended power converters Buy Now.
Product Details
- Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is disaster-proof and highly availableKey FeaturesExplore new features of SQL Server 2019 to set up, administer, and maintain your database solution successfullyDevelop a dynamic SQL Server environment and streamline big data pipelinesDiscover best practices for fixing performance issues, database access management, replication, and securityBook DescriptionSQL Server is one of the most popular relational database management systems developed by Microsoft. This second edition of the SQL Server Administrator's Guide will not only teach you how to administer an enterprise database, but also help you become proficient at managing and keeping the database available, secure, and stable.You'll start by learning how to set up your SQL Server and configure new and existing environments for optimal use. The book then takes you through designing aspects and delves into performance tuning by showing you how to use indexes effectively. You'll understand certain choices that need to be made about backups, implement security policy, and discover how to keep your environment healthy. Tools available for monitoring and managing a SQL Server database, including automating health reviews, performance checks, and much more, will also be discussed in detail. As you advance, the book covers essential topics such as migration, upgrading, and consolidation, along with the techniques that will help you when things go wrong. Once you've got to grips with integration with Azure and streamlining big data pipelines, you'll learn best practices from industry experts for maintaining a highly reliable database solution.Whether you are an administrator or are looking to get started with database administration, this SQL Server book will help you develop the skills you need to successfully create, design, and deploy database solutions.What you will learnDiscover SQL Server 2019's new features and how to implement themFix performance issues by optimizing queries and making use of indexesDesign and use an optimal database management strategyCombine SQL Server 2019 with Azure and manage your solution using various automation techniquesImplement efficient backup and recovery techniques in line with security policiesGet to grips with migrating, upgrading, and consolidating with SQL ServerSet up an AlwaysOn-enabled stable and fast SQL Server 2019 environmentUnderstand how to work with Big Data on SQL Server environmentsWho this book is forThis book is for database administrators, database developers, and anyone who wants to administer large and multiple databases single-handedly using Microsoft's SQL Server 2019. Basic awareness of database concepts and experience with previous SQL Server versions is required.Table of ContentsSetting Up SQL Server 2019Keeping Your SQL Server Environment HealthyImplementing Backup and RecoverySecuring Your SQL ServerWorking with Disaster Recovery OptionsIndexing and PerformancePlanning Migration and UpgradeAutomation - Using Tools to Manage and Monitor SQL Server 2019Configuring Always On High Availability FeaturesIn-Memory OLTP - Why and How to Use itCombining SQL Server 2019 with AzureTaming Big Data With SQL Server
| Publisher | Packt Publishing |
| Publication date | September 11, 2020 |
| Edition | 2nd ed. |
| Language | English |
| Print length | 522 pages |
| ISBN-10 | 1789954320 |
| ISBN-13 | 978-1789954326 |
| Item Weight | 2.1 pounds (950 grams) |
| Dimensions | 7.5 x 1.18 x 9.25 inches (19.1 x 3 x 23.5 cm) |
Product Description
SQL Server 2019 Administrator's Guide: A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions, 2nd Edition
Customers also viewed these products
Important information
- Limitations : For products shipped internationally, please note that any manufacturer warranty may not be valid; manufacturer service options may not be available; product manuals, instructions, and safety warnings may not be in destination country languages; the products (and accompanying materials) may not be designed in accordance with destination country standards, specifications, and labeling requirements; and the products may not conform to destination country voltage and other electrical standards (requiring use of an adapter or converter if appropriate). The recipient is responsible for assuring that the product can be lawfully imported to the destination country. When ordering from Ubuy or its affiliates, the recipient is the importer of record and must comply with all laws and regulations of the destination country.
- Not all the products listed on Ubuy are for sale, as Ubuy is a global search engine. Products are subject to export/trade regulations.
Currently unavailable.
We don't know when or if this item will be back in stock.
This item is not restrict in my country.(Please click on above link if this item is not restrict in your country, So our team will review and allow.)
Secured transaction
PCI DSS compliant and ISO 27001:2022 certified, with encrypted payments and full buyer protection on every order.
Our Top Logistics Partners
Fastest cross-border delivery
Ubuy Assurance
Experience worry-free shopping with 100% original products, PCI DSS-compliant payment security, ISO 27001-certified data protection, the fastest cross-border delivery, free returns *, and secure packaging on every order.