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

SQL Server 2005 Books Online (April 2006)

by Brian Kelley

Databases – Infrastructure – Security

SQL Server 2005 Books Online has been updated for SP1. The newest
version is labeled SQL Server 2005 Books Online (April...

2006-05-04

1,527 reads

SQL Server 2005 Security Overview Webcast - On Demand

by Brian Kelley

Databases – Infrastructure – Security

I'm catching back up on the TechNet webcasts
I found interesting from April. Most are during the day and with
meetings and...

2006-05-01

702 reads

Checking SQL Server Versions

by Brian Kelley

Databases – Infrastructure – Security

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

2006-04-30

1,611 reads

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,593 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,566 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,451 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,630 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,470 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,918 reads

Blogs

From SQL Saturday to Day of Data

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters

By Eduardo Pivaral

You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...

A New Word: La Guadière

la guadière – n. a glint of goodness you notice in something that you...

Read the latest Blogs

Forums

non ascii columns in a utf-8 .txt file

hi, we couldnt get our upstream data source developers to supply what is sometimes...

PolyBase Trace Flags

Are there any good articles on all the trace flags that are enabled on...

The Data Model Matters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Data Model Matters

Visit the forum

Question of the Day

Running SQLCMD I

I run the SQLCMD utility as follows:

lcmd -S localhost -E

I then type this (the 1> is the prompt):

1> select @@version go

If I hit enter, what happens?

See possible answers