Learn Microsoft SQL Server 2016 Best Practices for VLDB
Learning best practices for very large databases in SQL 2016
Description
The at the end of this course you will know how use Microsoft SQL Server 2016 with Very Large Databases, how its been improved from earlier version and get years of experience in this short course.
- Understand the Best Practices for databases for growth across files.
- Create file groups and move Data between file groups.
- Partition tables and create Memory optimized tables.
- How to use Mount Points.
- Use SQL Profiler to find improvements in database designs.
What You Will Learn!
- At the end of this you will understand how to find performance issues and understand the best practices for large databases.
- How you can optimism disk subsystems and memory management including row and page compression.
Who Should Attend!
- This course is for New Database Administrators that have not worked with Very Large Databases on Microsoft SQL Server 2016
- This course is for Database Administrators that want to have a deeper understanding of features that help VLDB
- This course is for Developers that want a better understanding of performance features.
- Knowledge level intermediate