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

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

700 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,482 reads

Cain does LSA Secrets dump on Vista and higher now

by Brian Kelley

Databases – Infrastructure – Security

Since going back to being a senior DBA, I've not stayed on top of the latest tools like I did...

2011-04-19

2,079 reads

"What's the point?"

by Brian Kelley

Databases – Infrastructure – Security

This is a crucial question with regards to what needs to be done. It really hit home after listening to...

2011-04-18

809 reads

It's not about whether you're a consultant or full-time staff...

by Brian Kelley

Databases – Infrastructure – Security

There's an article that's making its way through the SQL Ranks: Consultants are pros, while corporate IT staff are minor...

2011-04-12

1,335 reads

An Appeal to Those Writing Training Documentation and Labs

by Brian Kelley

Databases – Infrastructure – Security

I'm coming to the end of a week of training in a Microsoft Official Curriculum (MOC) Course. I should expect...

2011-04-08

930 reads

On Leadership - Lead by Example

by Brian Kelley

Databases – Infrastructure – Security

This is the second part of a leadership series I started with On Leadership - Lead from the Front. To recap...

2011-04-07

1,604 reads

SQL Injection: It's not just about your data

by Brian Kelley

Databases – Infrastructure – Security

On the topic of my SQL Connections SQL Server presentation, one of the things I pointed out about recent SQL...

2011-04-06

1,111 reads

SQL PASS ERC: How to Score the Interview?

by Brian Kelley

Databases – Infrastructure – Security

One of the topics the Election Review Committee has discussed is how best to score the interview portion. Because of...

2011-04-06

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

Install SQL Scripts via GUI Wizard

Hallo all! My problem is this: I have quite a bunch of TSQL scripts...

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

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