I haven’t been speaking a lot lately as I’ve been busy working, planning SQLSaturday #49 – Orlando, and planning PASS SQLRally, but I do have some upcoming engagements that I hope to see some of you at.

Introduction to Triggers on Thursday, September 9th 6:30pm, Space Coast SQL Users Group.

This session will give a brief overview of the different types of triggers available in SQL Server (DDL & DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers shoul d and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well

SQLSaturday #52 – Colorado on Saturday September 25th

I’m scheduled for 2 sessions at this event.  I’m attending this event for 2 reasons:

1. My wife has connected with Steve Jones’ wife, Tia, online and they both love horses.  Tia has horses, so my wife, Alice, will be spending the Saturday at the ranch with Tia and the horses.
2. An opportunity to go to a part of the country I haven’t been to and to connect with some new people.  There are several people I know from SQLServerCentral and Twitter that I have not meet in person yet, and this will be a great opportunity to do that.

Why I Use Stored Procedures

With the proliferation of ORM tools like Entity Framework, nHibernate, and Linq to SQL, many projects have decided that stored procedures are not needed and slow down development. While these tools have their place and have improved greatly, stored procedures still have their place, and, in this speaker's opinion, are the best way to do data access. In this session I'll discuss my reasons for using stored procedures and hopefully stimulate some discussion of other access methods.

Introduction to Triggers

This session will give a brief overview of the different types of triggers available in SQL Server (DDL & DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers shoul d and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well

SQLSaturday #49 – Orlando on Saturday, October 16th

In addition to planning and and running this event I’ll be presenting one session.

Profiling: It's Okay in SQL Server

Learn how to use SQL Server Profiler/Trace to troubleshoot SQL Server performance and errors. This session will cover how to use Profiler to capture SQL Server events, creating server-side traces, creating custom templates, saving trace data, and interpreting trace data.

I hope to see you at one of these events.  Please come up and talk to me, share your business card, and ask questions.  My favorite part of these events is meeting new people and re-connecting with people I haven’t seen recently.