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

Archives: February 2010

The Journey from Smart to Good

“It’s easier to be smart than good.”

I heard that quote in a recent sermon at church and it is one I can very much relate to in more than one area of my life.  In context the pastor was discussing the difference between knowing what the Bible says (being… Read more

2 comments, 279 reads

Posted in Wise Man or Wise Guy on 25 February 2010

What’s up with the reads?

So the other day I read Andrew Kelly’s article, Do You Have Hidden Cache Problems, in the latest electronic edition of SQL Server Magazine, and decided to run the query he listed in the article to see if my server was suffering from this problem:

SELECT
SUM(single_pages_kb…

Read more

4 comments, 117 reads

Posted in Wise Man or Wise Guy on 22 February 2010

SQLSaturday Acquired by PASS – Reactions

The Announcement

On February 2nd, PASS (@sqlpass), here, and Andy Warren (@sqlandy), here, announced ownership of the SQLSaturday franchise brand was transferred to PASS.  Since I am friends with Andy I know that this is something that he and his partners (Steve… Read more

9 comments, 392 reads

Posted in Wise Man or Wise Guy on 18 February 2010

SQL Developers Please Use the Table Name/Alias to Prefix Columns

Note:  After I completed this post Aaron Bertrand added this subject to his “Bad Habits to Kick” series for myself and Jay as we suggested on Twitter.  I wrote this post because I knew Aaron was headed to the Winter Olympics so I didn’t think he’d get to it for…

Read more

3 comments, 335 reads

Posted in Wise Man or Wise Guy on 16 February 2010

February OPASS Meeting Recap

Introduction

Last night we had our February OPASS meeting with Ron Dameron (@RonDBA) presenting on Database Hardening using PowerShell.  We broadcast the main presentation using Live Meeting and this time I remembered to hit record, so the session will be available on the OPASS web site at some… Read more

2 comments, 141 reads

Posted in Wise Man or Wise Guy on 10 February 2010

February OPASS Meeting Tonight

It's here!  Our February meeting is tonight at 6pm at End To End Training, 225 S. Westmonte Drive, Suite 2010, Altamonte Springs, FL (see the OPASS web site for directions).  While we would love for you to be there in person, the presentation will also be available on-line via Live… Read more

0 comments, 118 reads

Posted in Wise Man or Wise Guy on 9 February 2010

SSMS and Visual Studio Tip

Did you know that if you right-click on a tab in SSMS or Visual Studio you get the option to “Close all But this”?

Maybe everyone else already knew this, but at the January OPASS meeting Andy Leonard (@AndyLeonard) used this and it was the first time I… Read more

0 comments, 172 reads

Posted in Wise Man or Wise Guy on 4 February 2010

DBCC CHECKDB() on ResourceDB?

A few days ago I was answering a forum post about CHECKDB() and as part of the research I checked the Windows Application Log.  I was surprised to see this entry:

Event Type:    Information
Event Source:    MSSQLSERVER
Event Category:    (2)
Event ID:    8957
Date:        1/30/2010
Time:        5:45:02 PM
User:        domain\username…

Read more

3 comments, 569 reads

Posted in Wise Man or Wise Guy on 3 February 2010