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

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,510 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,486 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

New Perl Module for SQL Server released

by Brian Kelley

Databases – Infrastructure – Security

For those who use Perl and access SQL Server, MVP Erland Sommarskog has
announced a new module which uses OLE DB...

2005-11-19

1,521 reads

Blogs

Trace Flag 1448 – Lessons from a Technical Interview

In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...

Disable the sa login in SQL Server (and sleep better)

By Peter Skoglund

Disable the sa login in SQL Server (and sleep better)If you run SQL Server...

Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation

Change is inevitable. What separates thriving organizations from those that falter is not the...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

how to write this query?

Hi everyone I am a bit stuck on how to write this query. Below...

Powershell script to generate SQL server Inventory in CSV format

By Srinivas Merugu

Comments posted to this topic are about the item Powershell script to generate SQL...

Visit the forum

Question of the Day

Azure SQL Database MAXDOP

When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?

See possible answers