Learn how to correctly install and configure SQL Server 2012, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance. This course is applicable to anyone who is installing SQL Server for the first time and wants to avoid the common mistakes and pitfalls that are made so often.
One of the easiest ways to collect information about SQL Server workloads is to capture trace information. This course will introduce you to using SQL Trace and SQL Profiler for tracing SQL Server activity, including common pitfalls and problems to avoid. You'll learn how to analyze the collected information using a variety of methods that will help with performance troubleshooting, workload benchmarking, activity auditing, and much more. The course is perfect for developers and DBAs who need to collect information about workloads running on SQL Server for analytic purposes. The information in the course applies to all versions from SQL Server 2005 onwards.