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

All authors

All authors

Blogs

Making a PostgreSQL Backup in a Container

By

I needed to back up a PostgreSQL database as a part of the repro...

Azure SQL offerings

By

There are three Azure SQL products with so many different deployment options, service tiers,...

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

Read the latest Blogs

Forums

RLS Causing RBAR

By danielfountain

Hi all, First I want to ask just a generic question.  Does RLS in...

SQL2019 STANDARD max memory is 128Gb yet my Bufferpool exceeds this value

By PearlJammer1

Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...

Having issues installing SSIS extension for VS 2022 Community

By daniel.manke

I have installed the SSIS extension for VS 2022 community. When I go into...

Visit the forum

Question of the Day

A Simple Choice

I have this data in a table? 

CatIDCatName
3Monitors
What is returned when I run this code? 
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS c
 

See possible answers