Checking SQL Server Versions

This question comes up enough on the forums and with SP1 for SQL Server
2005 released, I'll cover it again. You...

Sharing Internet Connections?

This study out of the University of Illinois at Urbana-Champaign sounds great:

Software Allows Neighbors To Improve Internet Access At No...

More on xp_logininfo

In this post,
I talked about using xp_logininfo in order to get the permission paths
for a particular Windows account. If you've...

Fix for SSIS SP1 "service failed to start" issue

I was catching up on my blog reading and found the following post from Jamie Thomson:

SSIS: Another SP1 problem

The post...

Issues with SQL Server 2005 SP1

There have been reports of some issues with SQL Server 2005 SP1, especially
with SQL Server Integration Services not starting as...

When life intrudes

I have MVP Raymond Lewallen in my list of blogs to follow. I read with great sadness the following blog...

Issues tracking members of the sysadmin fixed server role

I received an email from another DBA asking how to track a user who is
probably mapping into SQL Server via...

Determining if it's a SQL login, Windows Login, or Windows group

A recent question on the forums asked how to determine if a database
user was a Windows user or group and...

Kerberos Delegation with SQL Server Reporting Services and SQL Server

I've been dealing with Kerberos delegation setup with respect to
Microsoft's CRM 3.0 product and while the process isn't difficult, if
you...

March/April 2006 Edition of SQL Server Standard Available

The March/April 2006 edition of SQL Server Standard magazine is now
available. This issue focuses on Transact-SQL for SQL Server 2005.
Though...