Brad M McGehee
Brad M. McGehee is a MCITP, MCSE+I, MCSD, and MCT (former) with a Bachelor’s degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 16 years SQL Server experience, over 7 years training experience, and has been involved in the industry since 1982.
Brad is a frequent speaker at SQL PASS, European PASS, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars, where he shares his 16 years of cumulative knowledge and experience.
In 2009, Brad made 33 public presentations to a total of 1,853 attendees, in six different countries. In 2010, Brad made 31 public presentations to a total of 3,156 attendees in two different countries.
Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics.
A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 15 technical books and over 275 published articles. His most recent books include How to Become an Exceptional DBA (2nd Edition), Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs, Mastering SQL Server Profiler, and Brad’s Sure Guide to SQL Server Maintenance Plans. These books are available free in PDF format at: http://www.sqlservercentral.com/Books/. He blogs at www.bradmcgehee.com.
Website URL: http://www.bradmcgehee.com
Introduction to SQL Trace
While many DBAs and developers are familiar with SQL Server Profiler, they are not familiar with SQL Trace. Very briefly, SQL Trace allows you to capture Profiler traces using system stored procedures, without the extra overhead of using the Profiler GUI, helping to minimize the amount of resources used for capturing traces. SQL Trace can be especially helpful to developers who want to see what their code is sending to SQL Server, helping when troubleshooting code or performance problems.
In this session you will learn: What is SQL Trace; The Pros and Cons of Using SQL Trace; How SQL Trace Works; What are the SQL Trace System Stored Procedures; How to Create Your Own SQL Trace Script; How to Query Trace Data Directly From a Trace File; and How to use the SQL Server Profiler GUI to Automatically Write SQL Trace Scripts.
This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use Profiler. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice.