Blog Post

Packt $10 Sale

,

One sale today, my Getting Started with SQL Server 2016 Administration video. You can get this for $10 today, and it’s an introduction to an overview of what’s in SQL Server 2016, most of which applies to 2017 as well.

Covers basics of administration from install and configuration to security and XE. If you have a junior that’s not worked much with SQL Server, this might help.

Outline:

  1. Installation – GUI and CLI
  2. Login, Users, and Roles
  3. Databases, configuration and creating objects including CLR code.
  4. OLTP Tables
  5. Indexing Basics
  6. Backup and Recovery
  7. Agent, Jobs, and Operators
  8. HA technologies in SQL Server
  9. TDE, Always Encrypted, Column encryption, Row-Level Security, Dynamic Data Masking
  10. Extended Events
  11. Execution Plans and Query Store

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating