SQL Server 2017 Administration Inside Out

Book Description

Conquer 2017 —from the inside out

Dive into SQL Server 2017 administration—and really put your SQL Server expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of capabilities available in SQL Server 2017 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 2017’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 , and data masking
  • Safeguard Azure SQL databases using 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, or performance tuning expert
  • Prerequisites: Basic understanding of database administration procedures

Table of Contents

Chapter 1 Getting started with SQL Server tools
Chapter 2 Introducing database server components
Chapter 3 Designing and implementing a database infrastructure
Chapter 4 Provisioning databases
Chapter 5 Provisioning Azure SQL Database
Chapter 6 Administering security and permissions
Chapter 7 Securing the server and its data
Chapter 8 Understanding and designing tables
Chapter 9 Performance tuning SQL Server
Chapter 10 Understanding and designing indexes
Chapter 11 Developing, deploying, and managing data recovery
Chapter 12 Implementing high availability and disaster recovery
Chapter 13 Managing and monitoring SQL Server
Chapter 14 Automating SQL Server administration

Book Details

File HostFree Download LinkFormatSize (MB)Upload Date
UsersCloud Click to downloadEPUB14.407/09/2018
How to Download? Report Dead Links & Get a Copy

Leave a Reply