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

Updated my professional site

by Brian Kelley

Databases – Infrastructure – Security

Slowly reworking my professional site at http://www.truthsolutions.com/
but as of right now it's more of a brochure site than anything else....

2005-11-30

1,284 reads

Update on MSSQL::OlleDB - Name Change

by Brian Kelley

Databases – Infrastructure – Security

SQL Server MVP Erland Sommarskog has announced
a name change to MSSQL::OlleDB. It's now known as Win32::SQLServer.
This is to bring it...

2005-11-27

1,340 reads

New Version of Apex SQL Edit released

by Brian Kelley

Databases – Infrastructure – Security

Looked over at the Apex SQL site and noticed they released a new
version of ApexSQL Edit last weekend. I went...

2005-11-26

1,504 reads

"Predicate Evaluation Order"

by Brian Kelley

Databases – Infrastructure – Security

In writing an article for SQL Server Standard's January issue, I received a tech edit comment from Adam Machanic
about a...

2005-11-25

1,487 reads

PromptSQL - Intellisense for SQL Server

by Brian Kelley

Databases – Infrastructure – Security

Visual Studio has spoiled me. I love the Intellisense feature that has continued to evolve with each new edition of Microsoft's...

2005-11-25

1,512 reads

Writing an article - don't be afraid to get started!

by Brian Kelley

Databases – Infrastructure – Security

Writing at article for SQL Server Central tends to be a very rewarding
experience. Every chance I get, I encourage others...

2005-11-25

1,488 reads

New version of ADO.NET provider for MySQL is available

by Brian Kelley

Databases – Infrastructure – Security

The following announcement came out this morning on the Annouce mailing list for MySQL:

"MySQL Connector/Net 1.0.7, a new version of...

2005-11-21

1,630 reads

Brief from David Litchfield about Administrator Logins to a Database Server

by Brian Kelley

Databases – Infrastructure – Security

David Litchfield has put out a brief (as
he says it, "It's called a brief because there's enough meat to make...

2005-11-19

1,401 reads

Google Base

by Brian Kelley

Databases – Infrastructure – Security

There has been some talk on Google Base on the Full Disclosure security
list. I've also seen on another blog about...

2005-11-19

1,391 reads

MySQL 5.0 Released

by Brian Kelley

Databases – Infrastructure – Security

Catching back up on things. MySQL 5.0 went "RTM" at the end of October.
Haven't had a lot of chances to...

2005-11-19

1,364 reads

Blogs

SQL Server 2025 RegEx and AI

One of the language changes in SQL Server 2025 that I’ve seen a lot...

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

I hosted this month, but I decided to put my own entry in as...

Why Databases Still Fascinate Me

I get asked a lot about why or how I began working with databases...

Read the latest Blogs

Forums

Columnstore index question

Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...

Transactional Replication

Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...

Member was not found in the cube when the string

By giles.clapham

Hey, I've not done a cube for many years but I find myself supporting...

Visit the forum

Question of the Day

Identify a Slipstream Installation

I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?

See possible answers