Oops, I did it again!


No, I am not talking about Brittany Spears; one blog post could not possibly define or explain that child!

I am talking about SQL User Groups!  I opened my mouth for a brief second and sure enough I was shocked and surprised by what came out of it.

“I will present at the November meeting.”

What the heck did I just say? What did I just volunteer my self to do? I really need to learn to take my wife’s advice.  “Just say NO”  LOL

Any way, on to picking a topic to present. One of the most intriguing things for me as a SQL DBA is performance tuning. The ability to push the limits and make queries go faster!  I get excited when I figure out how to shave milliseconds of off of a query.

For me the best way to approach performance is to try and develop your queries and indexes correctly from the start.  My presentation, “Indexes and Execution Plans”, will begin with a brief overview of indexes and execution plans; how to read them and to use them to your advantage in development. I will then give code examples on how to use execution plans to determine the best need (if any) for indexes.

See you all on November 11th at the Louisiana Tech Park on Florida. customLogo

My presentation and code will be available after the user group meeting.

Advertisements

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