SQL Server 2019 Administration Inside Out

Assaf, William, West, Randolph, Aelterman, Sven

  • 出版商: MicroSoft
  • 出版日期: 2020-04-13
  • 售價: $1,986
  • 貴賓價: 9.5$1,887
  • 語言: 英文
  • 頁數: 864
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 0135561086
  • ISBN-13: 9780135561089
  • 相關分類: MSSQLSQL

尚未上市,歡迎預購

商品描述

Conquer SQL Server 2019 administration-from the inside out

 

 

 

 

 

Dive into SQL Server 2019 administration-and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of time-saving solutions, tips, and workarounds-all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today's essential tasks-and challenge yourself to new levels of mastery.

 

 

 

 

 

  • Install, customize, and use SQL Server 2019's key administration and development tools
  • Manage memory, storage, clustering, virtualization, and other components
  • Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations
  • Provision SQL Server and Azure SQL databases
  • Secure SQL Server via encryption, row-level security, and data masking
  • Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing
  • Establish SQL Server IaaS network security groups and user-defined routes
  • Administer SQL Server user security and permissions
  • Efficiently design tables using keys, data types, columns, partitioning, and views
  • Utilize BLOBs and external, temporal, and memory-optimized tables
  • Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans
  • Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments

 

 

 

 

 

For Experienced SQL Server Administrators and Other Database Professionals

 

 

Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer