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

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

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