Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
SQL Server 2022 Administration Inside Out
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Disponible en magasin

SQL Server 2022 Administration Inside Out

SQL Server 2022 Administration Inside Out

Randolph / Assaf West

992 pages, parution le 30/07/2023

Résumé

Conquer SQL Server 2022 and Azure SQL administration from the inside out!

Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance. Nine experts thoroughly tour DBA capabilities available in the SQL Server 2022 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and much more. You'll find extensive new coverage of Azure SQL Database and Azure SQL Managed Instance, both as a cloud platform of SQL Server and in their new integrations with SQL Server 2022, information available in no other book. Discover how experts tackle today's essential tasks and challenge yourself to new levels of mastery.

  • Identify low-hanging fruit and practical, easy wins for improving SQL Server administration
  • Get started with modern SQL Server tools, including SQL Server Management Studio, and Azure Data Studio
  • Upgrade your SQL Server administration skillset to new features of SQL Server 2022, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Linux
  • Design and implement modern on-premises database infrastructure, including Kubernetes
  • Leverage data virtualization of third-party or non-relational data sources
  • Monitor SQL instances for corruption, index activity, fragmentation, and extended events
  • Automate maintenance plans, database mail, jobs, alerts, proxies, and event forwarding
  • Protect data through encryption, privacy, and auditing
  • Provision, manage, scale and secure, and bidirectionally synchronize Microsoft's powerful Azure SQL Managed Instance
  • Understand and enable new Intelligent Query Processing features to increase query concurrency
  • Prepare a best-practice runbook for disaster recovery
  • Use SQL Server 2022 features to span infrastructure across hybrid environments

Part I: Introduction

Chapter 1 Get started with SQL Server tools

Chapter 2 Introduction to database server components

Chapter 3 Design and implement an on-premises database infrastructure

Part II: Deployment

Chapter 4 Install and configure SQL Server instances and features

Chapter 5 Install and configure SQL Server on Linux

Chapter 6 Provision and configure SQL Server databases

Chapter 7 Understand table features

Part III: SQL Server management

Chapter 8 Maintain and monitor SQL Server

Chapter 9 Automate SQL Server administration

Chapter 10 Develop, deploy, and manage data recovery

Chapter 11 Implement high availability and disaster recovery

Part IV: Security

Chapter 12 Administer instance and database security and permissions

Chapter 13 Protect data through classification, encryption, and auditing

Part V: Performance

Chapter 14 Performance tune SQL Server

Chapter 15 Understand and design indexes

Part VI: Cloud

Chapter 16 Design and implement hybrid and Azure database infrastructure

Chapter 17 Provision Azure SQL Database

Chapter 18 Provision Azure SQL Managed Instance

Chapter 19 Migrate to SQL Server solutions in Azure

Randolph West (they/them) lives in Calgary, Alberta, Canada, with a husband and two dogs. After being a consultant for millennia, Randolph now writes full-time at Microsoft Docs, still yelling at the screen. Occasional voice actor. Occasional blogger at bornsql.ca. Not to be trusted around chocolate. Yes, this is a short bio.

William Assaf (he/him) is a senior content developer for Microsoft, writing Learn content for SQL Server, Azure SQL Database, Azure Synapse Analytics, and more. A long-time Baton Rougean, William and his adventure buddy Christine moved to Seattle during the pandemic. They love their new home but are still New Orleans Saints fans. Before joining Microsoft, William was a Data Platform MVP, SQL Saturday and SQL community organizer, and a long-time DBA and data consultant. As a consultant for 13 years, he worked with clients across the U.S. on SQL Server and Azure SQL platform optimization, management, data integration, disaster recovery, and high availability, and led a multi-city team of senior consulting SQL DBAs. William has written for Microsoft SQL certification exams since 2011 and was the team lead author of the 2017 and 2019 editions of SQL Server Administration Inside Out by Microsoft Press.

Elizabeth Noble is a Director of Database Development, the author of Pro T-SQL 2019, and a Microsoft Data Platform MVP. Ze has spoken at several SQL Saturdays across the United States and at PASS Summit. Most of zir topics focus on DevOps, collaboration with other IT departments, and automated database deployments. Zir passion is to help others improve the quality and speed of deploying database changes through automation. When ze is not trying to automate all things, ze can be found spending time with zir dogs, playing disc golf, or paddleboarding (if the weather is right).

Meagan Longoria is a Microsoft Data Platform MVP living in Denver, Colorado. She is an experienced consultant and trainer who has worked with the Microsoft Data Platform for over 15 years. She enjoys creating solutions in Azure, SQL Server, and Power BI that make data useful for decision makers and make the lives of information workers a little bit easier. Meagan enjoys sharing her knowledge with the technical community by speaking at conferences, blogging (DataSavvy.me), and sharing tips and helpful links on Twitter (@mmarie).

Joseph D'Antoni is a Principal Consultant at Denny Cherry & Associates Consulting. He is recognized as a VMWare Expert and a Microsoft Data Platform MVP and has over 20 years of experience working in both Fortune 500 and smaller firms. He has worked extensively on database platforms and cloud technologies and has specific expertise in performance tuning, infrastructure, and disaster recovery.

Louis Davidson has over 20 years as a data architect and technical writer. Recently he joined Redgate as the editor of the Simple Talk website after 20-plus years working for a nonprofit, where he was the lead SQL Server architect and programmer. Louis has been the principal author on many technical books about SQL Server, including six editions of a book on database design. Louis' blog, located at simple-talk.com for many years, provides information about technical issues and upcoming presentations, including previewing the thought process that goes into writing presentations, books, and blogs.

Caractéristiques techniques

  PAPIER
Éditeur(s) Prentice
Auteur(s) Randolph / Assaf West
Parution 30/07/2023
Nb. de pages 992
EAN13 9780137899883

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription