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

Vote for My PASS Summit Sessions

by Brian Kelley

Databases – Infrastructure – Security

Yes, this is absolutely a shameless post for self-promotion. However, since potential attendees get to offer input into what sessions...

2011-05-11

952 reads

Know Your Limits

by Brian Kelley

Databases – Infrastructure – Security

A little over a week ago I roughed up my back moving sound equipment after a ministry event. I have...

2011-05-10

1,706 reads

I Won't Be at SQL Rally

by Brian Kelley

Databases – Infrastructure – Security

I am excited about the SQL Rally event that's coming up next week. However, I won't be there. I've been...

2011-05-05

860 reads

My PASS Summit Submissions

by Brian Kelley

Databases – Infrastructure – Security

Following Andy Leonard's (blog | twitter) footsteps, here are my PASS Summit submissions. I decided to go a little different this...

2011-05-05

787 reads

Outlook Productivity Tricks

by Brian Kelley

Databases – Infrastructure – Security

I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...

2011-05-05

2,100 reads

Writing Better Emails

by Brian Kelley

Databases – Infrastructure – Security

In January 2009, I made the transition back to being a senior DBA. One of the first things my manager...

2011-05-04

2,927 reads

How often do you check email?

by Brian Kelley

Databases – Infrastructure – Security

If you read the experts, most folks check their emails too many times during the day. Today, while giving a...

2011-05-03

787 reads

Love What You Do

by Brian Kelley

Databases – Infrastructure – Security

I've been dealing with illness the last few weeks, probably due to the rather heavy pollen season here in South...

2011-04-29

1,537 reads

SQL University: Who has access to my SQL Server?

by Brian Kelley

Databases – Infrastructure – Security

Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...

2011-04-26

2,775 reads

If a web page asks you to update Adobe Flash Player

by Brian Kelley

Databases – Infrastructure – Security

You don't want to do so from that web page. Instead you want to go to the Adobe web site...

2011-04-22

1,110 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

Issue with CPU Affinity Configuration on a SQL Server VM with 30 vCPUs

By abdalah.mehdoini

Hello , I'm having an issue with a SQL Server VM that has 30...

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

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