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

The Cost of Not Having a DBA

By

Does skipping a DBA save money? Wait until your system grinds to a halt,...

Who are you? Building an identity map.

By

I admit that until I read the article, Who are you as a Leader?,...

Call a Fabric REST API from Azure Data Factory

By

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...

Read the latest Blogs

Forums

How to update using data from three tables?

By mjdemaris

I am in the process of migrating from MySQL to SQL Server. I have...

Select Returning Blank Rows

By JP789

I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...

How to update a history table with changes.

By bswhipp

Good morning to all.  I am a novice when it comes to SQL so...

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022?

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers