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

Forums for Atadore's PromptSQL

by Brian Kelley

Databases – Infrastructure – Security

Atadore has opened up forums for support and feature requests of its
PromptSQL tool. You can find them on the PromptSQL...

2006-01-26

1,345 reads

The Greatest Trick

by Brian Kelley

Databases – Infrastructure – Security

In reading Gianpaolo Carraro's blog I came across this entry: The architect greatest trick?!

In it he's talking about having seen...

2006-01-26

1,536 reads

PromptSQL Review

by Brian Kelley

Databases – Infrastructure – Security

I had the opportunity recently to take a look at PromptSQL and offer a
review on it. That review hit SSC.com's...

2006-01-18

1,427 reads

Awesome Interview on Windows Vista Kernel Architecture

by Brian Kelley

Databases – Infrastructure – Security

This actually premiered on Channel 9 right before Christmas. It is an
interview with Rob Short, a Microsoft VP in charge...

2006-01-07

1,476 reads

Guidance on .WMF patch from Mike Nash, Microsoft Corporate VP

by Brian Kelley

Databases – Infrastructure – Security

There is a new posting from Mike Nash on the Microsoft Security Response Center blog:

http://blogs.technet.com/msrc/archive/2006/01/05/416980.aspx

Relevant quote:

So the thing that I...

2006-01-05

1,452 reads

Microsoft .WMF Security Patch Releasing Today (out-of-cycle)

by Brian Kelley

Databases – Infrastructure – Security

Microsoft has announced they will release a security hotfix at 2 PM PST for the WMF design flaw. More details...

2006-01-05

1,410 reads

Sample Chapter from Professional SQL Server 2005 Integration Services

by Brian Kelley

Databases – Infrastructure – Security

Brian Knight posted a sample chapter for Professional SQL Server 2005 Integration Services
to his blog a few days ago. Last...

2006-01-04

1,468 reads

Simple Script to Report Tables Sizes in a SQL2K Database

by Brian Kelley

Databases – Infrastructure – Security

Last week we had an issue with a database growing unexpectedly. The
database in question supported an infrastructure type 3rd party
application...

2006-01-04

1,322 reads

Philosophy on Soldiering

by Brian Kelley

Databases – Infrastructure – Security

This is taken from the book About Face:The Odyssey of an American Warrior.
The author is Col. David "Hack" Hackworth, one...

2006-01-01

1,403 reads

Unpatched Microsoft Windows WMF Vulnerability

by Brian Kelley

Databases – Infrastructure – Security

If you haven't heard by now, there is an unpatched exploit in how
Windows handles WMF files. Since this handling is...

2005-12-28

1,426 reads

Blogs

Use a slicer to filter a visual based upon a measure in Power BI

By Meagan Longoria

Have you ever wanted to filter a visual by selecting a range of values...

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

I wrote a post recently about pruning branches in git. That’s part of the...

Microsoft Fabric shortcuts

I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...

Read the latest Blogs

Forums

SQL Server software and windows version compatibility level

Is there a specific platform or website where I can verify the compatibility between...

Truncate tables where Referential Integrity exists

By Perry Whittle

Comments posted to this topic are about the item Truncate tables where Referential Integrity...

Blocking question

Hi all, We have a SSIS package that does 2 things in parallel: moves...

Visit the forum

Question of the Day

Post Restore Tasks for the Resource Database

I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?

See possible answers