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

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

862 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

788 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,102 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,928 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

793 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,541 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,787 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,120 reads

Why having two accounts is a good thing

by Brian Kelley

Databases – Infrastructure – Security

Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...

2011-04-22

699 reads

Evaluating my SQL Connection Scores

by Brian Kelley

Databases – Infrastructure – Security

This evening I received my SQL Connection scores for the following presentations:
Windows Internals for DB ProsFrom the Ramparts: Knowing What...

2011-04-20

1,475 reads

Blogs

2025 Wrapped for Steve

I’ve often done some analysis of my year in different ways. Last year I...

The Book of Redgate: Spread across the world

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...

Merry Christmas

Today is Christmas and while I do not expect anybody to actual be reading...

Read the latest Blogs

Forums

Database security permissions save script

By Srinivas Merugu

Comments posted to this topic are about the item Database security permissions save script

Database backup job steps

I have a SQL Agent job for backing up a set of Analysis Services...

SQL Server 2025 Backup Compression Algorithm

By Johan Bijnens

Comments posted to this topic are about the item SQL Server 2025 Backup Compression...

Visit the forum

Question of the Day

The Large Encoded Value

I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?

See possible answers