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

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,274 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,966 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,558 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,055 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

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,126 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,859 reads

Resources for Those Dealing with Security Patches

by Brian Kelley

Databases – Infrastructure – Security

It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...

2012-08-24 (first published: 2012-08-21)

2,571 reads

Blogs

How to Run Databases on Kubernetes: An 8-Step Guide

By Ige Adetokunbo Temitayo

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Episode 11 of Simple Talks: Oracle

The 11th episode is now live, recorded a few weeks ago at the PASS...

A New Word: Mornden

mornden – n. the self-container pajama universe shared by two people on a long...

Read the latest Blogs

Forums

Giving Thanks

Comments posted to this topic are about the item Giving Thanks

What is the best index strategy for a table that gets truncated?

Hi everyone My SSIS package does a bulk insert of csv files into a...

Blob Storage automated downloads

By Brandie Tarvin

Dipping my toes into the waters of Azure and of course before I get...

Visit the forum

Question of the Day

Running Steve's Code

Can you run this code in any of your SQL Server 2019 databases without error?

CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
    
        SELECT Consumer_ID ,
               Trend_Category ,
               Bit_Trace
        FROM    NewWorldDB.dbo.MarketTrend;
    
GO

See possible answers