Subscribe to this blog
Archives: September 2010
Be Thorough When Making Schema Changes
This morning we made some changes to the database. We realized that as part of a re-factor we needed to move 2 columns from table A to table B. We made the changes and immediately a lot of unit tests began failing. As we worked on it we found out… Read more
2 comments, 399 reads
Posted in Wise Man or Wise Guy on 30 September 2010
PASS Elections – Improving the Process
Since there has been a bit of a furor over the PASS election process the past 2 years I thought I’d post some ideas about the process, even if many people are tired of it.
The process this year was essentially 4 steps:
- Written applications reviewed & rated by the…
0 comments, 59 reads
Posted in Wise Man or Wise Guy on 23 September 2010
SQLSaturday #49 – Orlando is Closing In
We are less than an month from SQLSaturday #49 – Orlando at Seminole State College – Sanford/Lake Mary campus on October 16th. Our preparations are going well, we have a good sponsor base, a great schedule, and several volunteers. We can always use more sponsors (plan|sign… Read more
0 comments, 94 reads
Posted in Wise Man or Wise Guy on 20 September 2010
SQLSaturday #52 – Colorado Here I Come!
Well, I’ve been waiting to book hotel and rental car for SQLSaturday #52 – Colorado because I wasn’t sure if my father-in-law’s health issues were going to cause us to cancel the trip, but fortunately his health is looking up, so we booked our hotel last night and our rental… Read more
0 comments, 93 reads
Posted in Wise Man or Wise Guy on 17 September 2010
September OPASS Meeting Tonight!
Topic: Using PIVOT – Going from Static to Dynamic
Sometimes data normalization results in a data structure that is not convenient for displaying the data. Take the common example of a sales database in which each record represents a single sale. However, what the customer really…
0 comments, 63 reads
Posted in Wise Man or Wise Guy on 14 September 2010
Space Coast User Group Recap
I had the pleasure of making my second annual September visit to the Space Coast SQL Server User Group in Melbourne, FL, last Thursday, September 9, 2010, to present, Introduction to Triggers. This is small user group, but they are a lot of fun and ask good questions. Because of… Read more
0 comments, 66 reads
Posted in Wise Man or Wise Guy on 13 September 2010
PASS SQLRally – Session/Speaker Selection
Hopefully by now you’ve heard about the PASS SQLRally event that will be held in Orlando, May 11-13. Andy Warren, Kendal Van Dyke, and I are the local members of the planning team and we are making our best effort to give you a look behind the curtain…
1 comments, 59 reads
Posted in Wise Man or Wise Guy on 9 September 2010
Upcoming Engagements
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…
2 comments, 71 reads
Posted in Wise Man or Wise Guy on 7 September 2010
Book Review: Crunch Time
About a month ago I went to Barnes & Noble to pick up a copy of Seth Godin’s book, Tribes: We Need You to Lead Us and, having some extra time, I was browsing the discount areas and I came upon Crunch Time: 8 Steps to Making the Right Life… Read more
0 comments, 101 reads
Posted in Wise Man or Wise Guy on 1 September 2010