SQL server 2017 administration inside out

Select an Action

Title:

Author:

Assaf, William, author.

ISBN:

9781509305216

Personal Author:

Assaf, William, author.

Physical Description:

xxiv, 677 pages : illustrations ; 23 cm.

Series:

Inside out

Inside out (Redmond, Wash.)

General Note:

Includes index.

Contents:

Introduction -- Getting Started with SQL Server Tools -- Introducing Database Server Components -- Designing and Implementing a Database Infrastructure -- Provisioning Databases -- Provisioning Azure SQL Database -- Administering Security and Permissions -- Securing the Server and its Data -- Understanding and Designing Tables -- Performance Tuning SQL Server -- Understanding and Designing Indexes -- Developing, Deploying, and Managing Data Recovery -- Implementing High Availability and Disaster Recovery -- Managing and Monitoring SQL Server -- Automating SQL Server Administration

Abstract:

Dive into SQL Server 2017 administration--and really put your SQL Server DBA 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 DBA 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. -- Provided by publisher.

Title Subject:

Subject Term:

Added Author:

Copies:

Available:*

Library	Material Type	Item Barcode	Shelf Number	Copy	Status
Searching... 1:IIESDN	1:GEN-BOOK	000096259	005.75 SQL	2	Searching... Unknown
Searching... 1:VCCT	1:GEN-BOOK	000122460	005.75 SQL	1	Searching... Unknown
Searching... 1:VCCT	1:GEN-BOOK	000124107	005.75 SQL	2	Searching... Unknown
Searching... 1:VCCT	1:GEN-BOOK	000124110	005.75 SQL	3	Searching... Unknown
Searching... 1:VCCT	1:PRES-BOOK	000124270	005.75 SQL	4	Searching... Unknown
Searching... 1:VCDBN	1:GEN-BOOK	002120539	005.75 SQL	1	Searching... Unknown
Searching... 1:VCDBN	1:LEC-BOOK	002130225	005.75 SQL	2	Searching... Unknown
Searching... 1:VCDBN	1:LEC-BOOK	002130226	005.75 SQL	3	Searching... Unknown
Searching... 1:VCDW	1:PRES-BOOK	000118841	005.75 SQL	1	Searching... Unknown
Searching... 1:VCDW	1:LEC-BOOK	000118941	005.75 SQL	2	Searching... Unknown
Searching... 1:VCPE	1:PRES-BOOK	000044567	005.75 SQL	1	Searching... Unknown
Searching... 1:VCPE	1:PRES-BOOK	000132182	005.75 SQL	2	Searching... Unknown
Searching... 1:VCPE	1:PRES-BOOK	000132179	005.75 SQL	3	Searching... Unknown
Searching... 1:VCPE	1:PRES-BOOK	000132304	005.75 SQL	4	Searching... Unknown
Searching... 1:VCSD	1:GEN-BOOK	002110199	005.75 SQL	1	Searching... Unknown

Bound With These Titles

On Order

Summary

Conquer SQL Server 2017 administration--from the inside out

* 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 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, or performance tuning expert

* Prerequisites: Basic understanding of database administration procedures