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 Article on SQL Server 2005 Logins

by Brian Kelley

Databases – Infrastructure – Security

I wrote a new article for SQL Server Central on SQL Server 2005 Logins. It covers the basics. This is...

2006-07-05

1,404 reads

Microsoft Office 2007 Delayed

by Brian Kelley

Databases – Infrastructure – Security

It looks like Microsoft Office 2007 will be delayed due to performance
issues. It was supposed to release in conjunction with...

2006-06-29

1,362 reads

Idera SQL Check updated for SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

Idera's SQL Check
has been updated to support SQL Server 2005. SQL Check is a free
performance monitoring tool, not anywhere near...

2006-06-28

1,550 reads

WinFS rolled into next version of SQL Server

by Brian Kelley

Databases – Infrastructure – Security

A blog posting from the WinFS team
caught me a bit by surprise today. Apparently I wasn't the only one,
judging by...

2006-06-27

1,556 reads

Top 100 Network Security Tools

by Brian Kelley

Databases – Infrastructure – Security

This is a bit dated (it came out last week), but here is the list of
the top 100 network security...

2006-06-26

1,460 reads

Professional Association of SQL Server (PASS) Local Chapter in Columbia, SC

by Brian Kelley

Databases – Infrastructure – Security

We are starting up efforts again to try and get a local PASS
chapter based in the Columbia, SC area. If...

2006-06-23

1,389 reads

SANS Stay Sharp Course - SEC351: Computer and Network Security Awareness

by Brian Kelley

Databases – Infrastructure – Security

A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...

2006-06-21

2,157 reads

Whitepaper: SQL Server 2005 Physical Database Storage Design

by Brian Kelley

Databases – Infrastructure – Security

Microsoft has released a whitepaper on SQL Server 2005 Physical Database Storage Design
(Microsoft Word document). It's 35 pages in length...

2006-06-15

2,066 reads

Distributing Database Connection Strings Using Active Directory Group Policy

by Brian Kelley

Databases – Infrastructure – Security

I ran into Brian Knight today on the Expo floor here at TechEd.
It was good to catch up a bit...

2006-06-13

2,338 reads

TechEd - DATTLC01 : Troubleshooting Performance Problems in SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

It's
been a few years since I wrote my eBook on SQL Server performance monitoring
but I still keep a strong interest...

2006-06-12

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