Peter A. Carter - Pro SQL Server 2019 Administration: A Guide for the Modern DBA
Here you can read online Peter A. Carter - Pro SQL Server 2019 Administration: A Guide for the Modern DBA full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2019, publisher: Apress, genre: Romance novel. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:Pro SQL Server 2019 Administration: A Guide for the Modern DBA
- Author:
- Publisher:Apress
- Genre:
- Year:2019
- Rating:5 / 5
- Favourites:Add to favourites
- Your mark:
Pro SQL Server 2019 Administration: A Guide for the Modern DBA: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Pro SQL Server 2019 Administration: A Guide for the Modern DBA" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
Peter A. Carter: author's other books
Who wrote Pro SQL Server 2019 Administration: A Guide for the Modern DBA? Find out the surname, the name of the author of the book and a list of all author's works by series.
Pro SQL Server 2019 Administration: A Guide for the Modern DBA — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Pro SQL Server 2019 Administration: A Guide for the Modern DBA" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub via the books product page, located at www.apress.com/9781484250884 . For more detailed information, please visit http://www.apress.com/source-code .
This book is dedicated to Edward Carter.
Pro SQL Server 2019 Administration is a book designed for DBAs who manage on-premise SQL Server estates. The book starts by covering the installation of SQL Server in both Windows and Linux environments. It also examines how to install and configure SQL Server in containers, which I believe to be the future of hosting many data-tier applications.
The book then moves on to discuss the configuration and maintenance aspects of managing SQL Server. This includes optimizing tables, creating indexes, and running data consistency checks. These are the core elements that every DBA should be familiar with.
Next, we will look at ensuring the security and resilience of SQL Server. This is an important topic, and we will dive into areas such as the SQL Server security model and encryption. We will then look at how to provide high availability and disaster recovery for your databases. This includes everything from taking backups (and restoring them) through to implementing complex AlwaysOn topologies.
Finally, this book will guide you through many of the performance troubleshooting and maintenance tasks that DBAs should understand. This ranges from understanding locking and performing traces with Extended Events through to utilizing some really great SQL Server features, such as the Query Store, Distributed Replay, and Policy-Based Management (PBM). We will also explore how to use metadata to automate maintenance routines and schedule these with SQL Server Agent.
When running code samples in this book, you should change the personalized aspect of the code, such as folder structures and file names, to match your own configuration.
I want to extend my gratitude to Chris Dent, a leading automation expert, specializing in PowerShell. He assisted me with enhancing the quality of PowerShell code used in some chapters of this book.
is a SQL Server expert with over 15 years of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. He was awarded an MCC by Microsoft in 2011 to sit alongside his array of MCTS, MCITP, MCSA, and MCSE certifications in SQL Server from version 2005 onward. Peter has written a number of books across a variety of SQL Server topics, including security, high availability, and automation.
is a freelance SQL Server consultant based in London. In addition to his day job, he is an author, creator of software utilities, and technical reviewer who regularly writes book reviews for www.i-programmer.info .
He covers every aspect of SQL Server and has a specialist interest in performance and scalability. If you require help with your SQL Server systems, feel free to contact him at ian_stirk@yahoo.com or www.linkedin.com/in/ian-stirk-bb9a31 .
Ian would like to thank Peter Carter, Jonathan Gennick, and Jill Balzano for making this book experience easier for him.
None of us stands alone, and with this in mind, Ian would like to thank these special people: Mrs Neal, Miss Lister, Mrs Coulter, Mr Tucker, Mr Griffiths, Mr Holland, Mrs Ransom, Mrs Denis, Mr Fisher, Mr Ridley, Mrs Page, Mrs Chalmers, Mr Powell, Mr Cooper, Mrs Huller, Mr Jones, Mrs Amphlett, Mr Price, Mr Farmer, and Mr Galbraith.
Ians fee for his work on this book has been donated to: Train 50 women teachers in Uganda to educate 1000s ( www.globalgiving.org/projects/train50teachers/ ).
Planning a deployment of SQL Server 2019, in order to best support the businesss needs, can be a complicated task. You should make sure to consider many areas, including edition, licensing requirements, on-premises vs. cloud hosting, hardware considerations, software configuration, and even if Windows is the best platform. For example, if your new instance will be supporting a PHP web app, hosted on Linux, then maybe your instance should also be hosted on Linux? And all of this is before you even start to consider which features of SQL Server you may need to install to support the application.
This chapter will guide you through the key decisions that you should make when you are planning your deployment. You will also learn how to perform some essential operating system configurations, should you decide to host your instance on Windows Server. This chapter will also give you an overview of the top-level features that you can choose to install and discuss why selecting the appropriate features is important.
Font size:
Interval:
Bookmark:
Similar books «Pro SQL Server 2019 Administration: A Guide for the Modern DBA»
Look at similar books to Pro SQL Server 2019 Administration: A Guide for the Modern DBA. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book Pro SQL Server 2019 Administration: A Guide for the Modern DBA and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.