SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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, 1,362 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:

  1. Written applications reviewed & rated by the…

Read more

0 comments, 470 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, 488 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, 349 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…

Read more

0 comments, 453 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, 335 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…

Read more

1 comments, 512 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…

Read more

2 comments, 474 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, 568 reads

Posted in Wise Man or Wise Guy on 1 September 2010