SQL Feather and Quill

Planning

SQLSaturday #99 was last Friday (11/11/11) and man it was really great to be a part of it.  I told many people that, for the preparation, I did very little work and spent most of my time learning from Jason Strate and Dan English on what needs to be done for an event such as this.  Dan and I were in charge of the sponsors – I sent a few emails to a few people.  What really happened was I’d get an email that would have a question that I thought I could answer, by the time I actually started to type a respond, Dan had sent at least one very good response.  He would answer the original question, ask a follow up question and make a few suggestions to help the sponsor/potential sponsor – I couldn’t add much value to most of them.  It was great to learn from him.  Tim Plas, Steve Hughes and Bill Preachuk did a great job on all the other details as well.

My Sessions:

SQL Community and Social Networking –Roundtable

I had the privilege of being on a panel with Dan English (T), Jason Strate (T), and Steve Hughes (T) for the “SQL Community and Social Networking –Roundtable” Session.  The moderator was Ted Krueger (T), so it was a very fun group.  Jason’s videos were a hit.  Unfortunately Ted was not wearing his sun glasses, so not many people recognized him – joking of course.

Here are some useful links from the session:

TSQL Tips and Tricks

This was my first full fledged technical session – and I thought it went well – no major issues with the demos, I did forget to mention the drag and drop features of SSMS (drag and drop columns from the object browser rather than use select * For that matter drag and drop object names of all types to prevent mistyping), but I did cover the material and I didn’t run out of stuff.

Click here to download the presentation with the demos.

Here are the links I mentioned during the session that I would post:

• SSMS Keyboard Shortcuts
• CAST and CONVERT (Transact-SQL)
• Create Insert/Update Scripts for Static Data Tables
• TSQL Looping Stats
• Script for Running Events
• The line from The Blues Brothers about 1060 West Addison

One more thing…the guy who asked me about turning off a trigger for a transaction, I came up with a potential solution…you have to alter the trigger and add a table to the database, so if you can’t do that, you don’t have to read the rest of this.  If you can do that…you may be able to add a new table, and in the trigger you that you want to turn off, add some logic checking for the existence in of the ID in the new table – if the record doesn’t exist, execute the trigger, if it does, skip the trigger.  That way you could just insert records to table when you don’t want to execute the trigger and remove them when you are done.  You also keep transactional consistency by not turning off the trigger for the entire table.  Just a thought, hope it helps.