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

Updated Thoughts on Antivirus on SQL Servers

by Brian Kelley

Databases – Infrastructure – Security

I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...

2012-04-30 (first published: 2012-04-24)

5,825 reads

Tribal knowledge is no knowledge

by Brian Kelley

Databases – Infrastructure – Security

I've run across several incidents in the last couple of months regarding something that is typically called "tribal knowledge." This is...

2012-04-19 (first published: 2012-04-12)

1,302 reads

Professional Productivity Books

by Brian Kelley

Databases – Infrastructure – Security

Just as with the "soft skills" books, in my professional development presentation, I list the professional productivity books that I have found most helpful in my...

2012-04-18

911 reads

"Soft Skills" books

by Brian Kelley

Databases – Infrastructure – Security

In my professional development presentation, I list the "soft skills" books that I have found most helpful in my career to date. You can find...

2012-04-16

1,578 reads

Re-thinking security for customer service

by Brian Kelley

Databases – Infrastructure – Security

This morning my son woke up to find his eBook reader frozen. It wouldn't unlock. It was fully charged (the...

2012-04-12

1,259 reads

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,345 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,386 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,456 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,047 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,328 reads

Blogs

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By Peter Skoglund

Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By Brian Kelley

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Managing unused indexes

While doing some housekeeping activity on several old but large production databases, I come...

Cloud Performance Considerations

How important to SQL Server is the speed of the SSD and network latency?...

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers