Brian Kelley

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as an infrastructure and security architect. He has also served as a senior Microsoft SQL Server DBA, database architect, developer, and incident response team lead.

Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology

When life intrudes

by Brian Kelley

Databases – Infrastructure – Security

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

2006-04-26

1,462 reads

Issues tracking members of the sysadmin fixed server role

by Brian Kelley

Databases – Infrastructure – Security

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

2006-04-25

1,589 reads

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

by Brian Kelley

Databases – Infrastructure – Security

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

2006-04-06

3,908 reads

Kerberos Delegation with SQL Server Reporting Services and SQL Server

by Brian Kelley

Databases – Infrastructure – Security

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

2006-04-05

2,150 reads

March/April 2006 Edition of SQL Server Standard Available

by Brian Kelley

Databases – Infrastructure – Security

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

2006-04-03

1,509 reads

12-inch grass stem?

by Brian Kelley

Databases – Infrastructure – Security

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

2006-03-29

1,355 reads

Internet Explorer Vulnerability

by Brian Kelley

Databases – Infrastructure – Security

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

2006-03-28

1,559 reads

Rights within the database

by Brian Kelley

Databases – Infrastructure – Security

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

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

2006-03-14

1,418 reads

What are the actual rights?

by Brian Kelley

Databases – Infrastructure – Security

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

2006-03-14

1,447 reads

First Impressions of Professional SQL Server 2005 Integration Services

by Brian Kelley

Databases – Infrastructure – Security

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

2006-03-13

1,482 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers