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

Blogs

Friday Flyway Tips: State-based deployment with Flyway Teams

By

I was asked about state-based deployments in Flyway Teams, so I decided to show...

Advice I Like: The Main Thing

By

The main thing is to keep the main thing the main thing. – from...

Sic Transit Gloria Community

By

When Covid took out the PASS organization, I had someone say to me, “Well,...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

ExecutionLog3 table in Reportserver Database

By cooldude001

I have a SSRS report for which users are complaining to be slow, but...

SQL Server Maintenance Plan Feedback

By water490

Hi I set this up today.  I wanted to get some feedback.  I have...

Visit the forum

Question of the Day

Counting Bits IV

What do these two selects return?

SELECT BIT_COUNT (CAST (-1 as smallint))
     , BIT_COUNT (CAST (-1 as bigint))

See possible answers