Great script, and it did work on 2008 SP2.

I will use this and probably add to it. I want to identify the logins with instance level permissions outside the...

Paraphrased conversation between a hotel gift shop attendant and me, when I was attending the PASS conference in Denver:

Them: Are you in town for vacation?

Me: I am in town for...

The assumptions I most frequently run into are that DBAs are a "catch all" for any database issue, no matter how remote.

If the word database is used in the description...

Some companies allow CUs to be applied, others only allow applying service packs due to a number of reasons (down time, change management, etc.). However, some of the CUs...

I have heard them called "intermediate tables".

The information in the article is good information. I know of a hiring manager who eliminated candidates for a database developer position because...

In 1988 I graduated with a B.S. in Computer Science with a math minor. This helped me with programming jobs in the 1980s and 1990s, but the DBA work...

SQL Server 2005 documentation on the "CREATE FULL-TEXT CATALOG" statement shows the following:

The default full-text filegroup is the primary filegroup for the database. We recommend that full-text catalogs be put on...

SQL Server 2000 stores the full-Text index outside the database.  SQL Server 2005 stores the full-text index inside the database.  This means that when a SQL Server 2005 database is restored,...