Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2009

RE: Career Development and Training by Lynn Pettis

Thank you, Lynn, for your previous post. I have reinforced in my first blog posting on SSC about certification as a good method to keep up with technology.  Instead of commenting directly to your post, I’m elaborating here below.

Absolutely, as you’ve said, share(!), it's the best way… Read more

2 comments, 663 reads

Posted in The Database Hive for SQL Server DBAs on 29 April 2009

Spring Still Not Really Hitting Montreal Yet, thus More Time to Hunt Down Useless Indexes

 

Hopefully, by the time we have our annual family vacation in May, the Cherry Blossoms will be out – until then I’ll just dig into some very, very heavily updated Indexes that are causing Quest’s Spotlight, at my latest contract with Transcontinental, to flash warnings for excessive disk… Read more

3 comments, 413 reads

Posted in The Database Hive for SQL Server DBAs on 23 April 2009

LinkedIn as your Stepping Stone for Opportunities with Internationally-Oriented Organisations

 As some of you may have read already, Andy Warren‘s series on LinkedIn (part 1, 2, 3) and networking has sparked my interest by first listing down what I would like to share about this brilliant business networking utility.  And then proceeding to read his –… Read more

1 comments, 743 reads

Posted in The Database Hive for SQL Server DBAs on 19 April 2009

SQL Server 2005/8 Database Compression Presentation in Burlington, Vermont - April 15th

Yesterday, I drove the Smart down to Burlington/Colchester, Vermont to meet up with MVP Roman Rehak and speak to the local user group about SQL Server Row, Page and VarDecimal compression, originally touched during this post.

The final version of the presentation is here.

I had much more performance gains… Read more

1 comments, 531 reads

Posted in The Database Hive for SQL Server DBAs on 13 April 2009

Activity Monitor in SQL Server 2008: an Embedded Optimisation Gizmo for the Thrifty DBA

As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul Neilsen (SQLserverBible.com), here is an introduction to one of our favorite new Management Studio Enhancements: Activity Monitor.  To use AM, right click on a SQL Server… Read more

4 comments, 876 reads

Posted in The Database Hive for SQL Server DBAs on 9 April 2009