Microsoft SQL Server 2016: Installation and Administration

Introduction

• Welcome
• What you should know

1. Installation and Configuration

• Introduce installation options
• Installation options continued
• Database storage strategies
• Capacity and growth considerations
• Understanding service accounts
• Install SQL Server
• Setting up the database

2. Database Instances

• Configure instance properties
• Configure instance properties continued
• Collation and Unicode support
• Configure linked servers
• Database engine services management

3. Performance Considerations

• Locks, blocking, and deadlocks
• Using the profiler
• Auditing the database
• Resource governor

4. Security

• Manage roles
• Manage server logins
• Manage database users
• Manage database roles
• Implement server permissions
• Implement database permissions
• Logon triggers

5. Managing Data

• Backup and restore strategies
• Backup demonstration
• Moving database files
• Ensure data integrity
• Manage indexes and data maintenance

6. High Availability Options

• Database replication
• Log shipping
• Database mirroring
• Always On

Conclusion

• Next steps