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

Archives: January 2010

What the Exec?

I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used 2008 personally.  I know I haven’t seen everything, but a couple of weeks ago a friend of mine asked me to look at some stored procedures he was working…

Read more

8 comments, 651 reads

Posted in Wise Man or Wise Guy on 28 January 2010

SQLSaturday 32 – Tampa Recap

I had the privilege to attend and speak at SQLSaturday 32 – Tampa this past weekend.  As I said in my event announcement, SQLSaturday is always a good time, and this one was no different.  My wife (yes, I brought my wife and she enjoyed herself, too) and I… Read more

0 comments, 547 reads

Posted in Wise Man or Wise Guy on 24 January 2010

SQLSaturday #32 – Tampa

Just a reminder that SQLSaturday #32 – Tampa is taking place this weekend (January 23rd).  This will be my 5th SQLSaturday and 4th as a speaker and every one has been a great event.  As a matter of fact, I enjoy SQLSaturday’s so much that I’m bringing my non-technical wife… Read more

0 comments, 328 reads

Posted in Wise Man or Wise Guy on 21 January 2010

Three Events that Brought Me Here

Paul Randal started the latest community chain blog, What three events brought you here?, and I was tagged by Steve Jones (@way0utwest), his post, and Brian Kelley (@kbriankelley), his post

I could go a couple of different directions with this:

  1. How I ended…

Read more

0 comments, 627 reads

Posted in Wise Man or Wise Guy on 19 January 2010

Accidental DBA?

It seems to me that over the last year or so that there has been an explosion in the use of the term “Accidental DBA” in the SQL Server community.  A google Bing search for “Accidental DBA” returns over 7 million results including blog posts, articles, editorials, and video training. …

Read more

0 comments, 628 reads

Posted in Wise Man or Wise Guy on 18 January 2010

Broadcasting OPASS over Live Meeting

Well, on January 12th OPASS moved into the present by broadcasting our meeting over the internet using Live Meeting.  Our main speaker, the incomparable Andy Leonard (@AndyLeonard), was presenting to us from somewhere outside Richmond, Virginia and we had attendees from the Europe to California.

Why did we…

Read more

0 comments, 466 reads

Posted in Wise Man or Wise Guy on 14 January 2010

Would Third-party Product Driven/Vendor Sessions Benefit User Groups and Community Events?

In the the couple of years I have been involved in the SQL Server community I have noticed that there is an issue with third-party product driven sessions or sponsor sessions at events.  The argument I usually hear against these sessions is that organizers are concerned about the event becoming… Read more

1 comments, 777 reads

Posted in Wise Man or Wise Guy on 12 January 2010

Video Featured on SQLShare

I didn’t have a chance to blog this yesterday (January 11, 2010), but my most recent video, Dynamic SQL Using sp_executesql, was featured on SQLShare yesterday.

It was great as it generated several comments and I was able to take the time to answer them this morning.  I love… Read more

0 comments, 469 reads

Posted in Wise Man or Wise Guy on 12 January 2010

January OPASS Meeting Tonight

Tonight is the January meeting for OPASS and we have a great schedule for the evening.

Robert Hurwitz a developer for the Florida K-12 online public schools will be doing a mini-presentation on Automating Index Maintenance from 6:15 to 6:30 and out main presentation will be by Andy Leonard (@AndyLeonard)… Read more

0 comments, 377 reads

Posted in Wise Man or Wise Guy on 12 January 2010

Book Review: SQL Server 2008 Query Performance Tuning Distilled

I recently finished reading the Apress book SQL Server 2008 Performance Tuning Distilled by Grant Fritchey and Sajal Dam.  I consider Grant to be a personal friend in addition to his being one of the top SQL Server experts.  I have not had the opportunity to meet Grant’s co-author, Sajal…

Read more

0 comments, 1,290 reads

Posted in Wise Man or Wise Guy on 7 January 2010

2010 Goals

It’s time to make a list of things to shoot for in the year ahead.  I did okay on my 2009 goals, but I hope to do better this year.  There is a new blog chain started by Tom LaRock (@SQLRockstar) for goals and a theme word…

Read more

2 comments, 747 reads

Posted in Wise Man or Wise Guy on 4 January 2010