The Importance of Database Coding Standards

I was working with a developer the other day and the question came up
of how to return status from a...

Presentation slides and sql scripts up

I have posted the slides for the presentation I gave to the DotNet Columbia User Group.
The talk was called, "Something...

Visual Studio Team System - Database Professionals: Database Connection Error

If you're like me, you don't have SQL Server 2005 sitting on the
default instance because SQL Server 2000 is sitting...

Excellent article on SQL Server 2005 Common Table Expressions

SQL Server MVP Nigel Rivett has written an excellent article on Common Table Expressions on Red Gate Software's Simple Talk...

Identifying NTLM vs. Kerberos authentication using Fiddler

I saw this post on using Fiddler to tell the difference between an NTLM and a Kerberos connection to a...

Does your organization need a DBA? (part 2)

This is a follow-on to Does your organization need a DBA? and Andy Leonard's Database Professionals: An Enterprise Requirement.

I was...

Does your organization need a DBA?

Andy Leonard pens the following blog entry:

Database Professionals: An Enterprise Requirement

There are quite a few organizations that feel they can...

Succint Article on Encypting File System (EFS)

Encrypting File System, or EFS, first debuted in Windows 2000 and gave
users to encrypt files without a 3rd party tool....

Detecting SQL Server 2005 Properly

There is a new post in the SQL Server Express blog which indicates the
right way to detect SQL Server 2005:...

More SQL Server blogs

There is a new site for SQL Server blogs, SQLBlog.com. "Brought to you by Peter DeBetta & Adam Machanic," it has...