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

New Tool: ApexSQL Audit Viewer

by Brian Kelley

Databases – Infrastructure – Security

ApexSQL has announced a new viewer tool for ApexSQL Audit. ApexSQL Audit does a lot of the dirty work of...

2007-04-11

1,729 reads

The Final Word on SQL Server 2005 SP2?

by Brian Kelley

Databases – Infrastructure – Security

Bob Ward posted on the PSS SQL Server Engineers blog a fairly long post on SP2 and the hotfixes thereafter:...

2007-04-11

1,442 reads

Thoughts from Never Eat Alone

by Brian Kelley

Databases – Infrastructure – Security

Watching a Chefograpy on Giada De Laurentiis, I learned that she was considered very much an introvert and had a...

2007-04-10

1,447 reads

Help Johnny, Help Kids

by Brian Kelley

Databases – Infrastructure – Security

I had heard of Johnny Long before I attended his briefing at Black Hat 2004. Well known for his research...

2007-04-09

1,512 reads

Microsoft CRM Security Internals

by Brian Kelley

Databases – Infrastructure – Security

On the Microsoft Dynamics CRM Team Blog, Jay Grewal has posted information about the CRM Security Model Internals.

CRM is...

2007-04-09

1,640 reads

More information about SQL Server 2005 and SP2

by Brian Kelley

Databases – Infrastructure – Security

SQL Server MVP Aaron Bertrand has posted an update (April 6, 2007) on the version numbers of post SP2 hotfixes....

2007-04-09

1,374 reads

How to pick a combination lock in 30 seconds

by Brian Kelley

Databases – Infrastructure – Security

This is just frightening. A piece of a beer can, a pair of pliers, and the combo lock pops open.

...

2007-04-07

1,501 reads

SQL Server Samples on CodePlex

by Brian Kelley

Databases – Infrastructure – Security

Like many other SQL Server focus area, SQL Server Samples has its own blog. A recent post there indicates that...

2007-04-06

1,417 reads

Thoughts from The Cuckoo's Egg

by Brian Kelley

Databases – Infrastructure – Security

The Cuckoo's Egg by Clifford Stoll has been around for a while, having been published in 1989. It details how...

2007-04-06

1,655 reads

Updated Website

by Brian Kelley

Databases – Infrastructure – Security

I've taken some time to update my website. In particular I have updated:
ArticlesReading ListChess Reading List
Nothing fancy or special, but...

2007-03-20

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