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

Why an employer should never ask about accessing your Facebook page

by Brian Kelley

Databases – Infrastructure – Security

There's a brilliant piece of work posted as a fictitious resignation letter that gives some scenarios as to why an employer could...

2012-04-03

1,355 reads

Why you can't provide your Facebook credentials

by Brian Kelley

Databases – Infrastructure – Security

I know this isn't related to SQL Server, but it is related to security and privacy.
If an employer or...

2012-04-02

2,397 reads

T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It

by Brian Kelley

Databases – Infrastructure – Security

If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?

Being a specialist means you're...

2012-03-13

1,463 reads

SQL Saturday #110 - Tampa - The Dirty Business of Auditing Presentation Materials

by Brian Kelley

Databases – Infrastructure – Security

For those who might want the materials for my presentation at SQL Saturday #110, I've posted them to the site.

SQL...

2012-03-10

1,053 reads

SC Midlands Chapter of ISACA - SQL Server Auditing Course Materials

by Brian Kelley

Databases – Infrastructure – Security

If you attended my SQL Server Auditing course held for the SC Midlands Chapter of ISACA, I finally was able...

2012-03-09

1,332 reads

T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It

by Brian Kelley

Databases – Infrastructure – Security

If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?

Being a specialist means you're...

2012-03-06

1,229 reads

Speaking at oPASS on March 8th

by Brian Kelley

Databases – Infrastructure – Security

I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...

2012-03-01

1,031 reads

New Article: Exploiting SQL Server via CONTROL SERVER permissions

by Brian Kelley

Databases – Infrastructure – Security

I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...

2012-02-27

1,740 reads

Presenting Two Sessions at SQLRally

by Brian Kelley

Databases – Infrastructure – Security

I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....

2012-02-27

982 reads

A Plea: Have your guidance documentation reviewed

by Brian Kelley

Databases – Infrastructure – Security

Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it...

2012-02-23

1,234 reads

Blogs

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

Monday Monitor Tips: Configuring Access to the MCP Server

I have been experimenting with MCP servers in a few ways, including the Redgate...

The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection

I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...

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