Wise man or Wise guy? You Decide

Just another WordPress.com weblog

PASS Sessions Submitted, Should I Be Committed?

Posted by sqlwiseguy on April 11, 2009

Well, even though the deadline was extended 2 weeks, I got 2 sessions submitted for the PASS Summit submitted by the original deadline.  Now the question is, should I be committed for even attempting to speak at a national (international) event?

Here are the sessions:

Profiler: An Underused Tool

Profiler has been around for awhile, but is often left in the DBA’s toolbox. Profiler is a flexible tool that can be used for Auditing, Monitoring, and Performance Tuning

Goals:

  1. Understand when, why, and how to use Profiler
  2. Understand the differences between Profiler and server-side tracing.
  3. Understand performance and security considerations for using Profiler.

Dive into the Default Trace

Beginning with SQL Server 2005 there is a server-side trace installed and started by default in every SQL Server installation. Not many DBA’s take advantage of the wealth of information collected through this trace. This trace includes 34 events in 2005 and 35 events in 2008 that audit non-DDL activity on your SQL Server.

Goals:

  1. Learn what events are included in the Default Trace.
  2. Learn how to query the Default Trace
  3. Learn how to process the Default Trace files to keep the information beyond the default amount of data (5 20MB files).

Now that I’ve submitted, how about you?

Advertisements

One Response to “PASS Sessions Submitted, Should I Be Committed?”

  1. Bob H said

    You’re mad, Jack!!! But you shouldn’t be committed. You should be rolled back.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: