SQL Saturday #21 in Orlando, FL is this Saturday, October 17th at Seminole Community College, 100 Weldon Boulevard, Sanford, FL 32773, The event is free, but there is a $10 charge for lunch, which based on the meal I received the last time in Orlando, is well worth it. I am looking forward to the event which has over 50 sessions and has attracted a lot of top speakers including
I’ll be presenting two sessions Saturday:
- Auditing User Activity 101
Auditing user activity in SQL Server has become a hot topic lately. From SOX and PCI to HIPPA, the security of personal data, and the ability to track who accessed the data and how has become extremely important. This session will cover the various methods available in SQL Server 2000, 2005, and 2008 to accomplish this task including SQL Trace in SQL Server 2000 and 2005, and the new Server Audits in SQL Server 2008.
- Wait Statistics: A Troubleshooting Methodology
Understanding when and how SQL Server waits to continue executing can be a powerful tool for troubleshooting problems with SQL Server. This session dives into how to look at and use wait statistics to determine the cause of performance problems inside of SQL Server. Learn what wait types mean, which types are signs of trouble, and how to determine the root cause of your performance problems in the shortest time possible.
I hope to see you at the event.