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

Preparing for Certification

by Brian Kelley

Databases – Infrastructure – Security

One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...

2012-10-22

1,358 reads

Microsoft Security Bulletin MS12-070 for SSRS

by Brian Kelley

Databases – Infrastructure – Security

Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...

2012-10-15 (first published: 2012-10-09)

4,294 reads

MS12-070 - Should I patch more than Reporting Services?

by Brian Kelley

Databases – Infrastructure – Security

If you're dealing with a version of SQL Server greater than SQL Server 2000, at this point I'm going to...

2012-10-11

1,983 reads

Slides and Scripts from Idera Auditing SQL Server presentation

by Brian Kelley

Databases – Infrastructure – Security

I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...

2012-10-10

1,566 reads

Kathi Kellenberger speaking at Midlands PASS

by Brian Kelley

Databases – Infrastructure – Security

On October 17th, Midlands PASS will welcome Kathi Kellenberger to speak on T-SQL 2012. Here's what her talk will be...

2012-10-05

1,087 reads

Webcast on SQL Server Auditing on October 9th

by Brian Kelley

Databases – Infrastructure – Security

Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...

2012-10-04

1,059 reads

Participate in the PASS Election Process

by Brian Kelley

Databases – Infrastructure – Security

Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...

2012-09-26

1,064 reads

The Reason I Won't Be at the PASS Summit This Year

by Brian Kelley

Databases – Infrastructure – Security

We welcomed daughter #3 and child #5 into this world on Saturday at 9:43 AM. She came a bit earlier...

2012-09-24

1,487 reads

PASS ProfDev VC presentation recording available

by Brian Kelley

Databases – Infrastructure – Security

Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...

2012-09-10

1,131 reads

An important query to remember

by Brian Kelley

Databases – Infrastructure – Security

This is based on a post with respect to where our focus and efforts should be that I wrote at...

2012-08-30

1,863 reads

Blogs

Advice I Like: Respect

“Don’t aim to have others like you; aim to have them respect you.” –...

Blue Sky Programming – The Optimism Trap

By administrator

Many years ago, before I joined Oracle, I was working on a major modernisation...

Setting Up a Mac for Data Engineering and AI Work

By Eduardo Pivaral

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...

Read the latest Blogs

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

Alamat Kantor BCA KCU KUDUS Telp:0817839777

WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...

Alamat Kantor BCA KCU SEMARANG Telp:0817839777

By layanan_Bca88

WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133

Visit the forum

Question of the Day

BIT_COUNT I

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 3;

See possible answers