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

12-inch grass stem?

Those of us in technology are very, very used to automated systems,
batch jobs, etc., all which run without human interaction...

Internet Explorer Vulnerability

If you're using Internet Explorer, be advised Microsoft has released a
security advisory for Internet Explorer. This would allow an attacker
to...

Rights within the database

This is a follow-on to my post What are the actual rights?

First and foremost, I want to include membership in...

What are the actual rights?

One of the things I've started to work on are some scripts to quickly
be able to pull what a user's...

First Impressions of Professional SQL Server 2005 Integration Services

I received a copy of Professional SQL Server 2005 Integration Services
a few weeks back from Kathi. Because of illness and...

Tool Updates

Catching up on recent updates for tools I've looked at and/or recommended.

SQL Server Tools:

PromptSQL is now up to version 1.4....