Mar 30 2012
Until yesterday I never heard of World Backup Day. I checked Target and I couldn’t find a single greeting card either. I was wondering if I was being Punk’d by Brent Ozar in his post that tomorrow (March 31, 2012) has that distinction. Then I figured what the heck, I’ve some scripts I use frequently [...]
Feb 28 2012
What Brings a Good Looking DBA Like You to a Place Like This? You’ve most likely found this post because of one of the following reasons: You’ve got this shiny new server and are thinking about installing SQL Server on it. You’ve been following this series from the beginning (thank you by the way) and [...]
Feb 22 2012
The db_owner Database Role Has a Secret The right solution is not frequently the easiest to implement. Avoiding hyperbole as much as possible I’ll simply say that database security is a very fine example of that adage. It is by far easier to … grant all users in a database membership in the db_owner database [...]
Feb 17 2012
A Little Patience It’s been a long time since I rock and rolled since I addressed this series on common mistakes in SQL Server database administration. When it comes to this topic I’m glad I held off because the recommendations have changed from when I was originally working on this series when it comes to [...]
Nov 7 2011
We all knew the dream had to come to an end at some point. Effective with licensing changes for SQL Server 2012 is the end of licensing based upon CPU sockets as an option for SQL Server. Since I’ve only ever had to deal with processor licensing (low CAL diet for me, thanks) I’m focused [...]
Jan 11 2011
While examining things you can do with the sys.dm_os_info Dynamic Management View I ran across an interesting outcome concerning SQL Server start time. Theorhetically, you can determine the last start time for your SQL Server services via any of the three methods: Create Date of tempdb (because tempdb is recreated each time the SQL services [...]
Sep 22 2010
I’ve received word that the labour of love (and almost Exhibit A in a divorce proceeding) is available for purchase at Amazon.com! If you’re even vaguely interested with increasing your proficiency with administrating and tuning your SQL Server instances then there is only one book I can recommend that has a photo I took on [...]
Jul 12 2010
The service accounts for SQL Server have undergone expansion in the past few releases of Microsoft SQL Server. Back in the days of SQL Server 2000 and earlier you only had to deal with configuring a service account for the SQL and the SQL Agent services. Now you have to contend with those in addition [...]
