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

We’re at War – Cyberwar

by Brian Kelley

Databases – Infrastructure – Security

In case you’ve not been following the news with regards to *government* breaches:
White House computers hacked – Russia suspectedUS Postal Service...

2014-11-13

761 reads

Speaking at SQL Saturday #354 – Charleston, SC

by Brian Kelley

Databases – Infrastructure – Security

If you’re looking to warm up for the winter, come on down to Charleston, SC, on December 13, 2014. Charleston...

2014-11-12

658 reads

Consolidating Email Accounts

by Brian Kelley

Databases – Infrastructure – Security

I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my linchpinpeople.com or either...

2014-10-21

542 reads

SQL Server Security Benchmarks

by Brian Kelley

Databases – Infrastructure – Security

If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:
The Mission of the Center for...

2014-10-20

876 reads

#TSQL2sday #59 – My Heroes

by Brian Kelley

Databases – Infrastructure – Security

Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server....

2014-10-14

550 reads

Slides and Code for SSIG Talk

by Brian Kelley

Databases – Infrastructure – Security

Thank you for those who made it out to the SQL Server Innovators Guild last night in Greenville, SC. I...

2014-10-08

608 reads

The Fallacy of Internal Access Only

by Brian Kelley

Databases – Infrastructure – Security

In the wake of Shell Shock, I’ve seen some vendor advisories indicate that while their product is vulnerable, it’s only...

2014-10-07 (first published: 2014-09-30)

7,118 reads

Carolina Technology Conference: Presentation Materials

by Brian Kelley

Databases – Infrastructure – Security

For those able to attend my session at this year’s Carolina Technology Conference, thank you! As promised, here are the...

2014-10-06

804 reads

Four Things PASS gets Right

by Brian Kelley

Databases – Infrastructure – Security

PASS has taken a lot of heat recently. A few folks have pointed out that you only seem to hear...

2014-09-29 (first published: 2014-09-24)

6,782 reads

[Off-Topic] Beating Childhood Cancer

by Brian Kelley

Databases – Infrastructure – Security

Note: I feel this post is important enough to post across all my blogs.
September is Childhood Cancer Awareness Month here...

2014-09-09

553 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