MCDBA certification training course Microsoft MCDBA certification training course Microsoft certified database administrator The Microsoft Certified Database Administrator MCDBA Certification training course from StudyITonline prepares students to lead organizations in the successful design, implementation, and administration of Microsoft SQL Server databases. Installing SQL Server on Server Core One of Microsoft s best practices for deploying SQL Server is to install it on Windows Server Core Windows Server Core provides a streamlined, efficient and secure platform than the full Windows Server implementation with the GUI. Troubleshooting High CPU Issues in SQL Learn how you can analyze the root cause of SQL Server performance problems to ensure your tuning efforts are successful. Microsoft SQL Server Unleashed nd Microsoft SQL Server Unleashed, E offers a variety of topics for system and database administrators to help them learn new features of the product SQL Server Hardware Glenn Berry Glenn Berry works as a Principal Consultant at SQLskills in Parker, CO He is a SQL Server MVP, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves he likes to take tests. SQL Server Consulting SQL Server Consultant FYI Columnstore indexes can dramatically speed up queries in SQL Server and Batch mode processing can also be a big win The SQL Server optimizer doesn t know when data is on fast SSD or if it is already in RAM.