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

SQL Server security bulletin due on Tuesday

by Brian Kelley

Databases – Infrastructure – Security

As part of its advance notification, Microsoft has released the list of security bulletins that should be coming our way...

2009-02-05

827 reads

Read-Only Access to SQL Server Jobs

by Brian Kelley

Databases – Infrastructure – Security

This question comes up a lot: how do I give read-only access to job status to a group of people?...

2009-01-22

4,028 reads

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,099 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

685 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

907 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

916 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

747 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

812 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

908 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

945 reads

Blogs

Flyway Tips: AI Generating Migration Script Names

AI is a big deal in 2026, and at Redgate, we’re experimenting with how...

The Book of Redgate: Get the right stuff done

Another of our values: The facing page has this quote: “We admire people who...

Runing tSQLt Tests with Claude

Running tSQLt unit tests is great from Visual Studio but my development workflow...

Read the latest Blogs

Forums

No Defaults Passwords Ever

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No Defaults Passwords Ever

Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON

Hi, We have low latency high volume system. I have a table having 3...

The Long Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Long Name

Visit the forum

Question of the Day

The Long Name

I run this code to create a table: Create table with unicode name When I check the length, I get these results: Table with length of name shown as 132 characters A table name is limited to 128 characters. How does this work?

See possible answers