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

PromptSQL purchased by Red Gate Software

by Brian Kelley

Databases – Infrastructure – Security

It appears that PromptSQL has been purchased by Red Gate Software. I
haven't seen a news announcement about it, and there's...

2006-05-04

1,529 reads

SQL Server 2005 Books Online (April 2006)

by Brian Kelley

Databases – Infrastructure – Security

SQL Server 2005 Books Online has been updated for SP1. The newest
version is labeled SQL Server 2005 Books Online (April...

2006-05-04

1,527 reads

SQL Server 2005 Security Overview Webcast - On Demand

by Brian Kelley

Databases – Infrastructure – Security

I'm catching back up on the TechNet webcasts
I found interesting from April. Most are during the day and with
meetings and...

2006-05-01

700 reads

Checking SQL Server Versions

by Brian Kelley

Databases – Infrastructure – Security

This question comes up enough on the forums and with SP1 for SQL Server
2005 released, I'll cover it again. You...

2006-04-30

1,603 reads

Sharing Internet Connections?

by Brian Kelley

Databases – Infrastructure – Security

This study out of the University of Illinois at Urbana-Champaign sounds great:

Software Allows Neighbors To Improve Internet Access At No...

2006-04-30

1,593 reads

More on xp_logininfo

by Brian Kelley

Databases – Infrastructure – Security

In this post,
I talked about using xp_logininfo in order to get the permission paths
for a particular Windows account. If you've...

2006-04-29

10,559 reads

Fix for SSIS SP1 "service failed to start" issue

by Brian Kelley

Databases – Infrastructure – Security

I was catching up on my blog reading and found the following post from Jamie Thomson:

SSIS: Another SP1 problem

The post...

2006-04-28

1,451 reads

Issues with SQL Server 2005 SP1

by Brian Kelley

Databases – Infrastructure – Security

There have been reports of some issues with SQL Server 2005 SP1, especially
with SQL Server Integration Services not starting as...

2006-04-27

1,620 reads

When life intrudes

by Brian Kelley

Databases – Infrastructure – Security

I have MVP Raymond Lewallen in my list of blogs to follow. I read with great sadness the following blog...

2006-04-26

1,461 reads

Issues tracking members of the sysadmin fixed server role

by Brian Kelley

Databases – Infrastructure – Security

I received an email from another DBA asking how to track a user who is
probably mapping into SQL Server via...

2006-04-25

1,588 reads

Blogs

Using CAT for Testing of Data Agents

By Joyful-Craftsmen

In last months one of the scenarios where you can use AI has been...

Are you getting value from your reporting?

By ChrisJenkins

Do you spend so long manipulating your data into something vaguely useful that you...

The Book of Redgate: SQL Server Central

It was neat to stumble on this in the book, a piece by me,...

Read the latest Blogs

Forums

Foreach Loop still executes after process and delete all the folders

I have two challenges XML source control not displaying the XML file parent node...

Which 'Where' statement conditional upon a variable

Thanks in advance for any clues on this. I am trying to write a...

Backup to Immutable Storage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backup to Immutable Storage

Visit the forum

Question of the Day

Backup to Immutable Storage

In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?

See possible answers