Phil Grayson

I’m Phil Grayson, founder of Aireforge, where we build tools to make database management more efficient, secure, and performance-driven. I’ve been working in the SQL Server space for over 25 years, with a focus on performance tuning, security, and observability. Currently, I’m gearing up to launch dbOptics, a platform designed to simplify database observability and performance tuning across complex estates, as well as Guard, a database firewall set to release next year.

I’m passionate about helping data professionals and organizations get the most out of their database environments. Aireforge has been active in the SQL community since 2016, sponsoring events like Data Relay and SQLBits, and we continue to contribute through knowledge sharing and community-driven events.
  • Interests: SQL Server performance tuning, index management, database security, automation of database tasks, observability and monitoring, knowledge sharing, cloud services, Azure infrastructure, motorcycle touring.

All authors

All authors

Blogs

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

By

The post Lukáš Karlovský: I got the green light from management and built Fabric...

FIRST_VALUE vs. Min: #SQLNewBlogger

By

I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...

Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join

By

This post comes off the back of my last, where I looked at issues...

Read the latest Blogs

Forums

Wahrung der Integrität der Prüfungsumgebung

By sergioblog066

Störsender für Prüfungssignale im Konferenzraum: Wahrung der Integrität der Prüfungsumgebung In der heutigen Zeit...

Subqueries II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Subqueries II

Distributed Monoliths

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Distributed Monoliths

Visit the forum

Question of the Day

Subqueries II

What is wrong (if anything) with this code? 

SELECT *
 FROM Sales.SalesOrderHeader AS soh 
 WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)

See possible answers