Trigger Happy Rotating Header Image

Events

Toronto PASS September 2015 Session Materials

Thanks for attending the session and I hope you got something out of it.  I had a great time and enjoyed meeting you.  Here are all the session materials and don’t hesitate to contact me if you have any questions.

 

BulletSpoon

Prairie Devcon 2013 Saskatoon Session Materials

Here are the session materials for the talks I did at Prairie Devcon 2013 in Saskatoon. I hope you enjoyed the conference and hope to see you at a future event

QueryPlans

BulletSpoon

Session Materials – Index-fu

Here are the session materials for the Index-fu talk I gave at SDEC13 on Oct 23. I hope you enjoyed the session.

IndexFu

Session materials Winnipeg SQL User Group – May 2013

Here are the session materials for the Winnipeg SQL Server User group meeting on May 15

I hope you enjoyed the session and I hope to see you at a future event.

MDD

MikeDeFehrBulletSpoonMay2013

My first SQL Saturday Presentation

I will be speaking at SQL Saturday #166 in Olympia, WA on November 10.  I will be doing my beginner talk on Indexes and Query plans.  I am looking forward to it as my first presentation outside of Canada.

SQL Saturdays are free one-day events held all over the world and are part of the great offerings of the Professional Association for SQL Server (www.sqlpass.org).  Take a look at the SQL Saturday website (www.sqlsaturday.com) for an event near you and try to make it out to Olympia next Saturday.

I hope to see a familiar face or two!

Session Materials from Prairie DevCon West 2012

I had a great time presenting two sessions in Calgary last week.  For those who attended the sessions and for the folks in Saskatoon where I did the SQL 2012 session, here are the slides and demos.

Email me or leave a comment to let me know what you think!

 

QueryPlans

SQL2012WhatsNew

SQL Server 2012 Launch

Hey everybody – the next version of SQL server is going to be available on April 1.  Despite being April fool’s day, this release is no joke.  With features like AlwaysOn Availability groups and Columnstore indexes, this is a major release.  My favourite new thing is the enhancements to intellisense, but I can be strange that way…

There is a whole lot to get up to speed on for this release, and an excellent, fun and potentially rewarding way to do that would be to register for and log into the SQL Server 2012 launch event – it kicks off with live keynotes tomorrow (Wednesday, March 7).  Learn stuff, ask live experts questions and win prizes.

Enjoy!

Index Review Scripts SDEC 2010

Welcome to SDEC 2010.  I hope you enjoy(ed) my session on how to do an index review.  Here are the scripts and slides.

IndexReviewSDEC2010

Query Tuning and Index Review June 2010

Here are the scripts and slides for my session on Query Tuning and Index Reviews.  I hope you enjoy(ed) the session.

QueryTuningAndIndexReview

Bullet Dodging Scripts Prairie Devcon 2010

Here are the scripts for my bullet-dodging and spoon-bending session at Prairie DevCon Regina 2010.  Enjoy!

BulletSpoon