DBA Volume 2

Description

1. Improving SQL Server Query Performance with Indexes – Part 2
2. Moving User Databases in SQL Server
3. New Security Features in SQL Server 2016
4. Non-Clustered ColumnStore Indexes in SQL Server 2014
5. Partitioning in SQL Server
6. Query Store, Live Query Statistics and Live Query Plans
7. SQL Server Backup and Restore
8. SQL Server Basic Query Tuning Techniques
9. SQL Server Change Data Capture
10. SQL Server Clustered Index Internals