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

I Won't Be at SQL Rally

by Brian Kelley

Databases – Infrastructure – Security

I am excited about the SQL Rally event that's coming up next week. However, I won't be there. I've been...

2011-05-05

872 reads

My PASS Summit Submissions

by Brian Kelley

Databases – Infrastructure – Security

Following Andy Leonard's (blog | twitter) footsteps, here are my PASS Summit submissions. I decided to go a little different this...

2011-05-05

799 reads

Outlook Productivity Tricks

by Brian Kelley

Databases – Infrastructure – Security

I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...

2011-05-05

2,109 reads

Writing Better Emails

by Brian Kelley

Databases – Infrastructure – Security

In January 2009, I made the transition back to being a senior DBA. One of the first things my manager...

2011-05-04

2,939 reads

How often do you check email?

by Brian Kelley

Databases – Infrastructure – Security

If you read the experts, most folks check their emails too many times during the day. Today, while giving a...

2011-05-03

795 reads

Love What You Do

by Brian Kelley

Databases – Infrastructure – Security

I've been dealing with illness the last few weeks, probably due to the rather heavy pollen season here in South...

2011-04-29

1,547 reads

SQL University: Who has access to my SQL Server?

by Brian Kelley

Databases – Infrastructure – Security

Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...

2011-04-26

2,795 reads

If a web page asks you to update Adobe Flash Player

by Brian Kelley

Databases – Infrastructure – Security

You don't want to do so from that web page. Instead you want to go to the Adobe web site...

2011-04-22

1,133 reads

Why having two accounts is a good thing

by Brian Kelley

Databases – Infrastructure – Security

Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...

2011-04-22

701 reads

Evaluating my SQL Connection Scores

by Brian Kelley

Databases – Infrastructure – Security

This evening I received my SQL Connection scores for the following presentations:
Windows Internals for DB ProsFrom the Ramparts: Knowing What...

2011-04-20

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