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

Server Level Security

by Brian Kelley

Databases – Infrastructure – Security

We'll discuss surface area later in the week. Today let's talk about if you're able to connect to SQL Server....

2012-11-09 (first published: 2012-11-06)

3,421 reads

SQL Server Security: The Sum of Its Parts

by Brian Kelley

Databases – Infrastructure – Security

When it comes to attacking SQL Server, whether we're talking about the security of an installation or as a piece...

2012-11-05

1,462 reads

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,345 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,289 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,973 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,562 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,085 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,056 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,061 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,476 reads

Blogs

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

SQL Clone at Scale with Striped Backups

I had a customer recently reach out to ask if SQL Clone would work...

How to Set Up SQL Server 2025, Ollama and NGINX in Docker Without the Headaches

By MarlonRibunal

Ollama SQL FastStart kit just works out of the box. It makes it easy...

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

Cloud Performance Considerations

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

Testing, testing, please ignore.

By edwardcasbon-nickname

This is a test, please ignore.

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