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

What Do You Want Auditors to Know About Auditing SQL Server?

by Brian Kelley

Databases – Infrastructure – Security

Right now it looks like I'll be putting a training session on for my local ISACA chapter on SQL Server...

2009-01-22

1,090 reads

Video: xp_cmdshell execution in SQL Server 2005/2008

by Brian Kelley

Databases – Infrastructure – Security

The video I did for Jumpstart TV on xp_cmdshell execution has hit the front page. Registration on the site is...

2009-01-21

667 reads

Conficker / Downadup Worm One More Time

by Brian Kelley

Databases – Infrastructure – Security

Hopefully by now everyone has seen this, but if not, here's a reminder to continue to spread the details. Denis Gobo...

2009-01-20

903 reads

Fake LinkedIn profiles with links to malware

by Brian Kelley

Databases – Infrastructure – Security

This is a little old (five days based on the last update), but TrendMicro put on their blog about fake...

2009-01-20

912 reads

Have you disabled autoplay yet?

by Brian Kelley

Databases – Infrastructure – Security

If not, you should. Because autoplay being on means any time a removable data device, such as a USB stick,...

2009-01-15

741 reads

Microsoft Solution Accelerators on TechNet

by Brian Kelley

Databases – Infrastructure – Security

I was browsing through the new titles that are on Safari and saw some planning guides around Windows Server 2008...

2009-01-15

805 reads

More About Twitter

by Brian Kelley

Databases – Infrastructure – Security

I've mentioned before that I was on Twitter and I know that for some the question is still out on...

2009-01-12

900 reads

MySQL GUI Tools

by Brian Kelley

Databases – Infrastructure – Security

This came up on Twitter today. I have a search set for "SQL Server" and it pulled up someone who...

2009-01-09

926 reads

Windows Server 2008 R2 Core supports SQL Server

by Brian Kelley

Databases – Infrastructure – Security

First saw this because Jason Massietwittered about it. But apparently there are enough bits of the .NET Framework in R2...

2009-01-09

1,250 reads

Organizing RSS Feeds

by Brian Kelley

Databases – Infrastructure – Security

I have a lot of blogs I subscribe to. Well over 500 at last count. And the truth of the...

2009-01-07

713 reads

Blogs

SQL Server Distributed Availability Groups and Kubernetes

By Andrew Pruski

A while back I wrote about how to use a Cross Platform (or Clusterless)...

Webcast Tomorrow on SQL Server Disaster Recovery

By Brian Kelley

Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL...

SQL Server Quickie #48 – Azure SQL Managed Instance

By Klaus Aschenbrenner

Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking...

Read the latest Blogs

Forums

Converting job_id to join to another table.

By Brandie Tarvin

I need help, please! I have a monitoring table that pulls in information about...

SSMS 20.2 on Windows11 not able to connect to SQL 2005 ??

By Johan Bijnens

We still have a couple of dino's. What should I check to re-enable access...

Agent job security account

By onkarnath.tiwary

Hi All, I have few sql server agent scheduled jobs which are supposed to...

Visit the forum

Question of the Day

What's the Ceiling?

What do I get as the results from this code?

SELECT CEILING (999.999), CEILING (-999.999);

See possible answers