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

You require WHAT for a license?

by Brian Kelley

Databases – Infrastructure – Security

I was trying to acquire a license for a product I was trying to look at using a free program....

2012-01-26

1,037 reads

Discuss

Clicking on Links in Email

by Brian Kelley

Databases – Infrastructure – Security

Every security awareness presentation makes the warning about opening attachments or clicking on links in emails when you don't know...

2012-01-24

1,258 reads

Discuss

New Article: How to audit sysadmin members on multiple servers using PowerShell

by Brian Kelley

Databases – Infrastructure – Security

My first article of 2012 has published over at MSSQLTips.com. This one covers the basic technique for using PowerShell to audit...

2012-01-23

1,943 reads

Discuss

Speaking at Charleston PASS on January 19th

by Brian Kelley

Databases – Infrastructure – Security

I will be presenting on SQL Server security on January 19th in Charleston, SC. You can find the details at...

2012-01-04

858 reads

Discuss

Renewed as MVP for SQL Server

by Brian Kelley

Databases – Infrastructure – Security

I have been renewed as an MVP for SQL Server. This is my 4th award. It's humbling to receive the...

2012-01-02

1,263 reads

Discuss

January Midlands PASS meeting - Hosting Ed Wilson, the "Scripting Guy"

by Brian Kelley

Databases – Infrastructure – Security

On January 10, 2012, Midlands PASS is pleased to welcome back PowerShell expert and teacher, Ed Wilson (blog | twitter), and...

2011-12-30

1,698 reads

What is SQL Saturday?

by Brian Kelley

Databases – Infrastructure – Security

I saw the following post from Andy Warren (blog | twitter), one of the creators of SQL Saturday. He was trying to...

2011-12-29

2,787 reads

SQLRally 2012 - Dallas Registration Is Open!

by Brian Kelley

Databases – Infrastructure – Security

Want 2 days of Microsoft SQL Server training where you can hand-pick what you're learning about for the low price...

2011-11-30

2,039 reads

No SQL Saturday - Columbia, SC in 2012

by Brian Kelley

Databases – Infrastructure – Security

Last week my partner in crime, Bobby Dimmick (blog | twitter) and I sat down for lunch and caught up and...

2011-11-14

1,665 reads

SQL Server security webinar now available on-demand

by Brian Kelley

Databases – Infrastructure – Security

Last week I was able to give a SQL Server security webinar with Quest Software and SQL Server MVP Kevin...

2011-11-08

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