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 one issue / bug we found with CU5.

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

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