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

Bad Admins: Stealing An Account

by Brian Kelley

Databases – Infrastructure – Security

Yesterday I posted about manipulating group membership to get access to a SQL Server. Today comes attack vector #2: stealing an...

2011-07-14

1,186 reads

Bad Admins: Attacking via Group Membership

by Brian Kelley

Databases – Infrastructure – Security

This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...

2011-07-13

1,869 reads

Gaining Speaker Experience Credentials

by Brian Kelley

Databases – Infrastructure – Security

One of the things I saw on Twitter yesterday was several folks saying their abstract submissions had been turned down...

2011-06-16

1,882 reads

Speaking at the 2011 PASS Summit

by Brian Kelley

Databases – Infrastructure – Security

The emails came in today and 2 out of 4 of my sessions were selected. Both are the ones I...

2011-06-15

889 reads

Planning Your Upgrade Well

by Brian Kelley

Databases – Infrastructure – Security

Yesterday I talked about the importance of having a tested business recovery plan. If you didn't read yesterday's post, the...

2011-06-07

963 reads

The Importance of a Business Recovery Plan

by Brian Kelley

Databases – Infrastructure – Security

Recently I was in one of those chain restaurants (the middle-priced, sit-down types) and shortly after we got there, we...

2011-06-06

1,885 reads

Re-Focusing the Blog a Bit

by Brian Kelley

Databases – Infrastructure – Security

In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...

2011-06-01

731 reads

Project Management: Dedicated vs. Shared Resources

by Brian Kelley

Databases – Infrastructure – Security

As an infrastructure type person, I typically represent a "shared" resource. What that means is I'm not dedicated to just...

2011-05-13

18,656 reads

You Are Responsible for You

by Brian Kelley

Databases – Infrastructure – Security

Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...

2011-05-12

728 reads

Dealing with Frustration in the Workplace

by Brian Kelley

Databases – Infrastructure – Security

Inevitably, even if we work for ourselves, we get frustrated with our workplace. This is true of all aspects of...

2011-05-11

3,009 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