SQL Server 2019 Administrator's Guide, Second Edition: A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions
Language: English
Published by Packt Publishing, 2020
- Softcover
- Used
Seller: GreatBookPrices, Columbia, MD, U.S.A.GreatBookPrices
AbeBooks seller since April 6, 2009
Condition: Used - As new
£ 43.30
Quantity: Over 20 available
Add to basketItem description from seller
Unread book in perfect condition.
Seller Inventory # 41905880
- Title
- SQL Server 2019 Administrator's Guide, Second Edition: A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions
- Author
- Marek Chmel; Vladimir Muzny
- Publisher
- Packt Publishing
- Publication year
- 2020
- Condition
- As New
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 1789954320
- ISBN 13
- 9781789954326
- Edition
- 2nd Edition
Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is disaster-proof and highly available
Key Features
- Explore new features of SQL Server 2019 to set up, administer, and maintain your database solution successfully
- Develop a dynamic SQL Server environment and streamline big data pipelines
- Discover best practices for fixing performance issues, database access management, replication, and security
Book Description
SQL 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 learn
- Discover SQL Server 2019's new features and how to implement them
- Fix performance issues by optimizing queries and making use of indexes
- Design and use an optimal database management strategy
- Combine SQL Server 2019 with Azure and manage your solution using various automation techniques
- Implement efficient backup and recovery techniques in line with security policies
- Get to grips with migrating, upgrading, and consolidating with SQL Server
- Set up an AlwaysOn-enabled stable and fast SQL Server 2019 environment
- Understand how to work with Big Data on SQL Server environments
Who this book is for
This 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 Contents
- Setting Up SQL Server 2019
- Keeping Your SQL Server Environment Healthy
- Implementing Backup and Recovery
- Securing Your SQL Server
- Working with Disaster Recovery Options
- Indexing and Performance
- Planning Migration and Upgrade
- Automation - Using Tools to Manage and Monitor SQL Server 2019
- Configuring Always On High Availability Features
- In-Memory OLTP - Why and How to Use it
- Combining SQL Server 2019 with Azure
- Taming Big Data With SQL Server
"Synopsis" may belong to another edition of this title.
About the Author
Marek Chmel is a senior cloud solutions architect at Microsoft for data and artificial intelligence, a speaker, and a trainer with more than 15 years' experience. He's a frequent conference speaker, focusing on SQL Server, Azure, and security topics. He has been a Data Platform MVP since 2012. He has earned numerous certifications, including MCSE: Data Management and Analytics, Azure Architect, Data Engineer and Data Scientist Associate, EC Council Certified Ethical Hacker, and several eLearnSecurity certifications. Marek earned his MSc degree in Business and Informatics from Nottingham Trent University. He started his career as a trainer for Microsoft courses and later worked as principal sharepoint administrator and principal database administrator.
Vladimir Muzny has been a freelance developer and consultant since 1997. He has been a Data Platform MVP since 2017, and he has earned certifications such as MCSE: Data Management and Analytics and MCT. His first steps with SQL Server were done on version 6.5, and from that time on, he has worked with all following versions of SQL Server. Now Vladimir teaches Microsoft database courses, participates in SQL Server adoption at various companies, and collaborates on projects for production tracking and migrations.
"About the title" may belong to another edition of this title.
GreatBookPrices
Columbia, MD, U.S.A.
AbeBooks seller since April 6, 2009
Shipping rates within U.S.A.
| Item | 5 to 14 business days | 8 to 14 business days |
|---|---|---|
| First item | £ 1.99 | £ 1.99 |
Payment methods
Store description
SuperBookDeals.com is your top source for finding new books at the absolute lowest prices, guaranteed ! We offer big discounts - everyday - on millions of titles in virtually any category, from Architecture to Zoology -- and everything in between. Discover great deals and super-savings, on professional books, text book titles, the newest computer guides, or your favorite fiction authors. You'll find it all - at HUGE SAVINGS - at SuperBookDeals. Browse through our complete online product catalog today. Serving customers around the world for years, we help thousands find just the books they're looking for -- at incredibly low, bargain prices.…
Seller's business information
Expert Trading Limited
9220 Rumsey Road, Suite 101
Columbia, MD U.S.A. 21045
Terms of sale
Company Name: GreatBookPrices
Legal Entity: Expert Trading, LLC
Address: 6310 Stevens Forest, suite 200, Columbia MD 21046
Email address: CustomerService@SuperBookDeals.com
Phone number: 410-964-0026
consumer complaints can be addressed to address above
Registration #: 52-1713923
Authorized representative: Danielle Hainsey
Right of withdrawal
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to GreatBookPrices, Bensenville, Illinois, U.S.A., without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
- The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
- The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.
Shipping terms
Our warehouses across the globe are fully operational without substantial delays. We are working hard and continue to overcome the daily challenges presented by COVID-19. We appreciate your understanding.
Internal processing of your order will take about 1-2 business days. Please allow an additional 4-14 business days for Media Mail delivery. We have multiple ship-from locations - MD,IL,NJ,UK,IN,NV,TN & GA