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

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,061 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,100 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

686 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

913 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

926 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

749 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

818 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

916 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

946 reads

Windows Server 2008 R2 Core supports SQL Server

by Brian Kelley

Databases – Infrastructure – Security

First saw this because Jason Massietwittered about it. But apparently there are enough bits of the .NET Framework in R2...

2009-01-09

1,265 reads

Blogs

From SQL Saturday to Day of Data

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters

By Eduardo Pivaral

You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...

A New Word: La Guadière

la guadière – n. a glint of goodness you notice in something that you...

Read the latest Blogs

Forums

Converting Money

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Converting Money

non ascii columns in a utf-8 .txt file

hi, we couldnt get our upstream data source developers to supply what is sometimes...

PolyBase Trace Flags

Are there any good articles on all the trace flags that are enabled on...

Visit the forum

Question of the Day

Converting Money

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;

See possible answers