SQL Server 2019 Administrator's Guide, Second Edition | A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions
Langue : anglais
Edité par Packt Publishing, 2020
- Livre broché
- Neuf



Vendeur : preigu, Osnabrück, Allemagnepreigu
Vendeur AbeBooks depuis 5 août 2024
Etat: Neuf
EUR 65,30
Quantité disponible : 5 disponible(s)
Ajouter au panierItem description from seller
SQL Server 2019 Administrator's Guide, Second Edition | A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions | Marek Chmel (u. a.) | Taschenbuch | Kartoniert / Broschiert | Englisch | 2020 | Packt Publishing | EAN 9781789954326 | Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, 36244 Bad Hersfeld, gpsr[at]libri[dot]de | Anbieter: preigu Print on Demand.
N° de réf. du vendeur 119399140
- Titre
- SQL Server 2019 Administrator's Guide, Second Edition | A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions
- Auteur
- Marek Chmel (u. a.)
- Éditeur
- Packt Publishing
- Année de publication
- 2020
- État de l'article
- Neu
- Reliure
- Taschenbuch
- Langue
- anglais
- ISBN à 10 chiffres
- 1789954320
- ISBN à 13 chiffres
- 9781789954326
- Édition
- 2ème Édition
- Poids de l'article
- 964 grammes
- Dimensions
- 235 x 191 x 29 mm
- Catalogues du vendeur
- Bücher
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 » peut appartenir à une autre édition de cet ouvrage.
À propos de l’auteur
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.
« A propos de ce titre » peut appartenir à une autre édition de cet ouvrage.
preigu
Osnabrück, Allemagne
Vendeur AbeBooks depuis 5 août 2024
Frais d'expédition de Allemagne vers Etats-Unis
| Article | 60 à 60 jours ouvrés | 60 à 60 jours ouvrés |
|---|---|---|
| Premier article | EUR 70,00 | EUR 70,00 |
Modes de paiement
- Paypal
Description de la boutique
preigu betreibt einen Onlineversandhandel mit über 1 Mio. Produkten in verschiedenen Sortimenten. Das Kernsortiment besteht aus Büchern, Medien und Spielwaren. Ein gelungenes Einkaufserlebnis ist das Ziel einer jeden Bestellung bei preigu, denn der Kunde und seine Zufriedenheit stehen an erster Stelle. preigu setzt daher auf einen kompetenten Kundenservice, funktionierende Prozesse und schnelle Reaktion.
Spécialité
Bücher, SpielwarenProfil professionnel du vendeur
preigu GmbH & Co. KG
Lengericher Landstraße 19
Osnabrück, Allemagne 49078
Conditions de vente
About Us
Legal website operator identification:
preigu GmbH & Co. KG
Lengericher Landstr. 19
49078 Osnabrück
Germany
Telephone: +49 (0) 541 / 580 72 84
Email: mail@preigu.de
VAT No: DE 455 380 498
AG Osnabrück - HRA 209647
PhG: preigu Verwaltung GmbH
AG Osnabrück - HRB 221793
CEO: Ansas Meyer
We are neither willing nor obliged to participate in dispute resolution proceedings before consumer arbitration boards.
We are a member of the initiative "FairCommerce" since 30.11.2016.
For more information, see: https://www.haendlerbund.de/de/haendlerbund/interessenvertretung/faircommerce
Droit de rétractation
Instructions for revocation
Right of withdrawal for the sale of goods
Revocation right for consumers
(A ‘consumer' is any natural person who concludes a legal transaction which, to an overwhelming extent, cannot be attributed to either his commercial or independent professional activities.)
Instructions for revocation
Revocation right
You have the right to revoke this contract within 14 days without specifying any reasons.
The revocation period is 14 days with effect from the day,
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the products, provided you had ordered one or more products within the scope of a standard order and this/these product/products is/are delivered uniformly;
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last product, provided you had ordered several products within the scope of a standard order and these products are delivered separately;
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last part delivery or the last unit, provided you had ordered a product, which is delivered in several part deliveries or units;
To exercise your right of withdrawal, you must inform us (preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, Telephone number: +49 (0) 541 / 580 72 84, E-Mail address: mail@preigu.de) by means of a clear declaration (e.g. a letter sent by post, or an e-mail) of your decision to withdraw from this contract. You can use the attached model withdrawal form for this purpose, which is, however, not mandatory.
You can also exercise your right of withdrawal online by clicking on a button labelled accordingly (such as ‘Withdraw from contract' or similar) on the AbeBooks/ZVAB website. If you use this online function, you will immediately receive a confirmation of receipt on a durable medium (e.g. via email) containing information on the content of the withdrawal notice, as well as the date and time of its receipt.
In order to safeguard the revocation period, it is sufficient that you send the notification about the exercise of the revocation right before the expiry of the revocation period.
Consequences of the revocation
If you revoke this contract, we shall repay all the payments, which we received from you, including the delivery costs (with the exception of additional costs, which arise from that fact that you selected a form of delivery other than the most reasonable standard delivery offered by us), immediately and at the latest within 14 days from the day on which we received the notification about the revocation of this contract from you. We use the same means of payment, which you had originally used during the original transaction, for this repayment unless expressly agreed otherwise with you; you will not be charged any fees owing to this repayment.
We can refuse the repayment until the products are returned to us or until you have furnished evidence that you have sent the products back to us, depending on whichever is earlier.
You must return or transfer the products to us immediately and, in any case, at the latest within 14 days with effect from the day on which you inform us of the revocation of this contract. The deadline is maintained if you send the products before the expiry of the 14 day deadline.
You bear the direct costs for returning the products.
You must pay for any depreciation of the products only if this depreciation can be attributed to any handling with you that was not necessary for checking the condition, features and functionality of the products.
Criteria for exclusion or expiry
The revocation right is not available for contracts
-
for delivery of products, which are not prefabricated and for whose manufacturing an individual selection or stipulation by the consumer is important or which are clearly tailored to the personal requirements of the consumer;
-
for delivery of products, which can spoil quickly or whose use-by date would be exceeded quickly;
-
for delivery of alcoholic drinks, whose price was agreed at the time of concluding the contract, which however can be delivered 30 days after the conclusion of the contract at the earliest and whose current value depends on the fluctuations in the market, on which the entrepreneur has no influence;
-
for delivery of newspapers, periodicals or magazines with the exception of subscription contracts. The revocation right expires prematurely in case of contracts
-
for delivery of sealed products, which are not suitable for return for reasons of health protection or hygiene if their seal has been removed after the delivery;
-
for delivery of products if they have been mixed inseparably with other goods after the delivery, owing to their condition;
-
for delivery of sound or video recording or computer software in a sealed package if the seal has been removed after the delivery.
Specimen - revocation form
(If you wish to revoke the contract, please fill up this form and send it back to us.)
-
To preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, Email address: mail@preigu.de :
-
I/we () herewith revoke the contract concluded by me/ us () regarding the purchase of the following products ()/
the provision of the following service () -
Ordered on ()/ received on ()
-
Name of the consumer(s)
-
Address of the consumer(s)
-
Signature of the consumer(s) (only in case of a notification on paper)
-
Date
(*) Cross out the incorrect option.