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

Slides from SQL Server Auditing Class

by Brian Kelley

Databases – Infrastructure – Security

Here are the slides from the SQL Server Auditing Class held on June 2, 2010.
Hour 1 - Attacking SQL Server
Hour 2...

2010-06-03

1,029 reads

Providing Quality to the Community

by Brian Kelley

Databases – Infrastructure – Security

This has been on my mind since last week after a conversation with a friend of mine, Bobby Dimmick (twitter)....

2010-05-19

1,199 reads

Microsoft Certified Architect - Infrastructure and Solutions Are No More

by Brian Kelley

Databases – Infrastructure – Security

A friend of mine had been out to the Microsoft Certified Architect site recently and noted that the Infrastructure and...

2010-05-14

1,963 reads

Join the Community - AKA, "Where did he go, George?"

by Brian Kelley

Databases – Infrastructure – Security

In recent days I've kind of dropped off the map with respect to SQL Server, including with the Security and...

2010-05-11

766 reads

Why I Don't Look for a Telecommuting Job

by Brian Kelley

Databases – Infrastructure – Security

I just got done reading Brent Ozar's post about why folks don't get the telecommuting job they want. It's a...

2010-05-07

3,117 reads

SQL University Post Coming Tomorrow

by Brian Kelley

Databases – Infrastructure – Security

This is a short note to say that the SQL University post will arrive tomorrow. Today we're dealing with the...

2010-04-28

1,447 reads

SQL Saturday - Columbia, SC - October 2, 2010

by Brian Kelley

Databases – Infrastructure – Security

This is the official announcement that we are officially scheduled for holding a SQL Saturday in Columbia, SC, on October...

2010-04-27

891 reads

SQL University: Auditing SQL Server, Part I

by Brian Kelley

Databases – Infrastructure – Security

Welcome to the Security and Auditing Week for SQL University. Last semester we looked at the basics of SQL Server...

2010-04-26

2,790 reads

2010 Scripting Games

by Brian Kelley

Databases – Infrastructure – Security

Since I've decided it's time for me to learn Powershell, naturally the best way to learn it is to dive...

2010-04-21

765 reads

Thoughts on the SQL Server 2008 R2 Press Conference

by Brian Kelley

Databases – Infrastructure – Security

If you weren't aware, Microsoft held a BI telelconference today which announced the release to manufacturing (RTM) of SQL Server...

2010-04-21

1,195 reads

Blogs

New article – migrating from a named instance

By Brian Kelley

Do you have a case where you have a named instance you'd like to...

Using the SIGN() Function: #SQLNewBlogger

I was trolling the docs and noticed the SIGN() function. I have never written...

T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?

The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...

Read the latest Blogs

Forums

Admin Rights for Everyone

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Admin Rights for Everyone

Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles

By Arvind Toorpu

Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...

RegEx Functions I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions I

Visit the forum

Question of the Day

RegEx Functions I

Which of these RegEx functions need compatibility level 170 in SQL Server 2025?

See possible answers