When did SQL Server start and how long is the downtime window?

 
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...

Issue with SQL Server 2K5 SP3 CU5

In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out...

Journey to trouble-shoot Error 5042 (cannot remove a file xxx because it is not empty)

I was working on a table partition management task yesterday. The table is partitioned on a datetime column, and each...

Thoughts on SSC Blog Site Improvement

I have been reading blogs from various sources, such as blogs on SSC, and on sqlblog.com etc. However on all...

Database Administration Literature Criticism

What is literature? I find this definition is pretty intuitive at http://classiclit.about.com/od/literaryterms/g/aa_whatisliter.htm and also this one is more comprehensive at...

DBA Education

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

Last week (Jan 21...

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...

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...

Database Administrtion Skillset Investment Rules

With each new release of SQL Server version, there is something new to learn. In SQL Server 6.5 days, it...

Database Adminstration Scalability

database administration scalabilityI am working on a project that is very successful in terms of its market
share, i.e. product users...