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

Archives: March 2010

Index Info

I recently came across an interesting script to help show index info and usage.  As I began to dissect the script, I noticed that the script was intended for SQL 2005 and beyond but was using SQL 2000 compatibility views.  I decided I would take it upon myself to update… Read more

0 comments, 1,989 reads

Posted in SQL RNNR on 31 March 2010

Stepping Stone Cert

A few of us have been deliberating and discussing the need for a bridge certification between the MCITP and MCM certifications from Microsoft.  This discussion was brought about due to an editorial by Steve Jones at SQLServerCentral.  As the discussion has progressed I believe there are some good ideas coming… Read more

6 comments, 1,519 reads

Posted in SQL RNNR on 30 March 2010

FizzBuzz Revisited

I had bigger plans for this series than what has transpired. I think that is a testament as to how things can rapidly change or other events can change your plans. The first thing that changed my plans for this series was the advent of a competition on ask.sqlservercentral.com centered… Read more

1 comments, 1,928 reads

Posted in SQL RNNR on 30 March 2010


There seems to be quite a flurry of talk these days about certification. There is evidence of it in the forums and editorials at SSC, as well as in several personal blogs of various SQL Professionals throughout the community. I even see it happening with the quarterly goals at my… Read more

6 comments, 1,252 reads

Posted in SQL RNNR on 26 March 2010

Security Audit

Of late I have seen a lot of questions on how to audit the logins and users on each SQL Server.  I had the same questions for myself when I went through the same exercise some time ago.  My first step was to peruse the internet and see what I… Read more

11 comments, 1,765 reads

Posted in SQL RNNR on 19 March 2010

Another Presentation Down

This evening I had the opportunity to once again give a presentation at our local SQL Uses Group (SSSOLV).  I went into the presentation with the hope of trying to encourage participation and group discussion.

I think the presentation started off a little shaky for a couple of reasons.  I… Read more

0 comments, 616 reads

Posted in SQL RNNR on 12 March 2010

Log Growing Pains Article

I Just had an article published at SQLServercentral on troubleshooting the cause of log growths.  At the conclusion of that article I had a reference to my blog with the expectation of having had time to create a post about using Event Notifications to track the Log Growth and determine… Read more

0 comments, 469 reads

Posted in SQL RNNR on 11 March 2010


Once again it is that time.  It is TSQL Tuesday.  This time it is being hosted by Mike Walsh.  Mike has decided to leave the topic open for interpretation like was done last month.  So this month we get to incorporate IO into our articles however we wish –… Read more

0 comments, 1,342 reads

Posted in SQL RNNR on 9 March 2010

Worst Thing to Do to your DBA

Recently Andy Warren Blogged about things that could drive your DBA mad.  There was a lot of feedback on SQLServerCentral about various things that could be done to drive the DBA nuts.  Well, I have one that could drive a DBA mad (this one in particular) and any IT… Read more

0 comments, 747 reads

Posted in SQL RNNR on 5 March 2010

Index your FK

A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas.  Since that article, I have seen several people asking about whether a foreign key should be indexed or not.  I have seen the benefits of having FKs indexed as well as the agony of…

Read more

0 comments, 855 reads

Posted in SQL RNNR on 5 March 2010