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, 126 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…
4 comments, 59 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, 135 reads
Posted in Wise Man or Wise Guy on 18 February 2010
SQL Developers Please Use the Table Name/Alias to Prefix Columns
3 comments, 101 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, 72 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, 59 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, 89 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…
3 comments, 295 reads
Posted in Wise Man or Wise Guy on 3 February 2010



Subscribe to this blog