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

Archives: January 2009

DBA Education

I always consider taking seminars and technical conferences as a key component in my DBA education framework

Last week (Jan 21 to 22, 2008), I attended MS TechDays Canada 2008 in Vancouver, BC. Though the quality of the sessions is above the usual business-promotion-focused sessions, I still feel the quality… Read more

7 comments, 1,719 reads

Posted in DBA Philosophy on 27 January 2009

List Objects in a Filegroup in SQL Server 2005

I have tried hard to google a SQL query to find what objects exist in a specific filegroup, but in the end, I am not satisified with my findings.

I know there is an undocumented SP called sp_ObjectFileGroup, but I do not know how useful this is. My issue is… Read more

4 comments, 12,448 reads

Posted in DBA Philosophy on 16 January 2009

DBA Mission and Vision Statement


There is a saying that "The important is often not urgent and the urgent not important". I could not agree more when I think of my DBA work. Most of the time, we DBAs are driven by daily routine job and some "accidents" from time to time. We seldom think about what… Read more

3 comments, 9,139 reads

Posted in DBA Philosophy on 3 January 2009