Learn Microsoft SQL Server 2016 Best Practices for VLDB
What you'll 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.
- SQL 2008 or later knowledge.
- Downloaded SQL Server 2016 Developer or Enterprise.
- Windows 8.1 or Windows Server 2012 R2 and higher
- Recommend running VirtualBox but this is optional.
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.
Who this course is for:
- 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
John Hall is an IT professional with knowledge of Linux, Windows and Networking.
Spend large part of his career working for blue chip multinationals developing Private and Public cloud solutions for applications such as Sharepoint, SAP, J2EE and PaaS.
Working in IT since 1999 he is an Microsoft Certified IT Professional in SQL Server and Windows Server however most of his time has been spend hunting down performance issue and improving overall customer service.