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

Preparing for Certification

by Brian Kelley

Databases – Infrastructure – Security

One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...

2012-10-22

1,361 reads

Microsoft Security Bulletin MS12-070 for SSRS

by Brian Kelley

Databases – Infrastructure – Security

Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...

2012-10-15 (first published: 2012-10-09)

4,300 reads

MS12-070 - Should I patch more than Reporting Services?

by Brian Kelley

Databases – Infrastructure – Security

If you're dealing with a version of SQL Server greater than SQL Server 2000, at this point I'm going to...

2012-10-11

1,990 reads

Slides and Scripts from Idera Auditing SQL Server presentation

by Brian Kelley

Databases – Infrastructure – Security

I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...

2012-10-10

1,567 reads

Kathi Kellenberger speaking at Midlands PASS

by Brian Kelley

Databases – Infrastructure – Security

On October 17th, Midlands PASS will welcome Kathi Kellenberger to speak on T-SQL 2012. Here's what her talk will be...

2012-10-05

1,091 reads

Webcast on SQL Server Auditing on October 9th

by Brian Kelley

Databases – Infrastructure – Security

Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...

2012-10-04

1,061 reads

Participate in the PASS Election Process

by Brian Kelley

Databases – Infrastructure – Security

Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...

2012-09-26

1,068 reads

The Reason I Won't Be at the PASS Summit This Year

by Brian Kelley

Databases – Infrastructure – Security

We welcomed daughter #3 and child #5 into this world on Saturday at 9:43 AM. She came a bit earlier...

2012-09-24

1,489 reads

PASS ProfDev VC presentation recording available

by Brian Kelley

Databases – Infrastructure – Security

Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...

2012-09-10

1,137 reads

An important query to remember

by Brian Kelley

Databases – Infrastructure – Security

This is based on a post with respect to where our focus and efforts should be that I wrote at...

2012-08-30

1,865 reads

Blogs

Au Revoir for now

No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...

Goodbye, Microsoft

By Randolph West

A few years ago I took a new job at Microsoft, working as a...

The SUM of Nothing: #SQLNewBlogger

I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...

Read the latest Blogs

Forums

Building a SQL Server Fleet Audit That Leadership Actually Reads

By Mayank Sethi

Comments posted to this topic are about the item Building a SQL Server Fleet...

Smart AI Agents and Data Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Smart AI Agents and Data...

RegEx Functions IV

By Steve Jones - SSC Editor

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

Visit the forum

Question of the Day

RegEx Functions IV

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^D', 'i')
 AND BusinessEntityID IN (7,8)

See possible answers