Which recovery model would have the largest transaction...

What UDP port does SQL Server listen on?...

Who Are You? (as a DBA)

Are you a 228 or a 229? Read on and think about how well you fit your job.

DB2 A Worthy Competitor?

Recently Steve Jones spent a week working with IBM's DB2 database. Read about his thoughts and impressions of this SQL Server competitor.

Is the Schema Still Needed?

Do you know what the schema is? In Relational databases, there is the concept of a database and a table, but the schema sits between them. In SQL Server, this is known as the owner. But do we really need this additional layer? Has it ever caused you problems? Has it outlived its usefulness?

A Sneak Peak at Windows 2003

Microsoft has been running 2 day seminars on Windows 2003 across the country as well as at selected Enterprise Partner sites. Steve Jones recently attended one and has a first look at the next generation of Windows Servers.

Getting Your Server Information

Do you use @@version? sp_server_info? What's the difference? Read on to see what each of these methods returns and which one you should be using.

What's In A Review?

Expanding on the issue of reviewing software for SQL Server, Steve Jones proposes some standards for reviews in this article. Please take a moment to read and comment on this proposal to better help SQL Server Central.com provide you with the information that you need.

Auditing Your SQL Server - Part 3

This article expands Steve Jones' look at ways to audit changes by examing how you can deal with the large amounts of data generated.

Worst Practices - Blank Passwords

Not even worth talking about, right? Probably, but they still exist. Read about this worst practice and pass it along.