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

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,155 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,360 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,561 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,419 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,484 reads

Tool Updates

by Brian Kelley

Databases – Infrastructure – Security

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

2006-03-13

1,569 reads

Microsoft MVP Program

by Brian Kelley

Databases – Infrastructure – Security

I think anyone who posts actively in the various on-line forums for
Microsoft products (such as SSC.com) hopes one day to...

2006-02-23

1,372 reads

Mavericks don't make it

by Brian Kelley

Databases – Infrastructure – Security

One of the blogs I most enjoy reading is Life Beyond Code.
This blog allows me to take off my technology...

2006-02-18

1,445 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