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

Sharing Internet Connections?

by Brian Kelley

Databases – Infrastructure – Security

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

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

2006-04-30

1,603 reads

More on xp_logininfo

by Brian Kelley

Databases – Infrastructure – Security

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

2006-04-29

10,576 reads

Fix for SSIS SP1 "service failed to start" issue

by Brian Kelley

Databases – Infrastructure – Security

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

SSIS: Another SP1 problem

The post...

2006-04-28

1,457 reads

Issues with SQL Server 2005 SP1

by Brian Kelley

Databases – Infrastructure – Security

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

2006-04-27

1,636 reads

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,476 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,598 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,932 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,175 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,518 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,368 reads

Blogs

Creating a Local Model Chatbot on Windows

After my session at VSLive last week, I had a few questions from the...

To refer and to be referred

By Mala Mahadevan

Referrals have never been more important in the job market. They’re no longer nice...

A New Word: Dorgone

dorgone– adj. wondering if you could slip away from an event or group conversation...

Read the latest Blogs

Forums

Querying Multiple Tables for the Same Information

I have about 100 Tables that are all suffixed with _Modify. These tables record...

Make It Routine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Make It Routine

Finding Gaps in Sequential Data Using SQL Server

Comments posted to this topic are about the item Finding Gaps in Sequential Data...

Visit the forum

Question of the Day

Negative and Positive Numbers

If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?

See possible answers