Matthew McGiffen

I started my career in IT as a developer with Visual Basic, C# and ASP working with SQL Server backends. For the last ten years though I’ve focused on the SQL Server side of things. Currently I’m working for a leading software vendor for the financial industry as a DBA, doing a mixture of development and data architecture. If I have a speciality it is in making things run faster.

All authors

All authors

Blogs

T-SQL Tuesday #193 – Notes to my past self and from my future self

By

It has been a while since my last T-SQL Tuesday blog. When I saw...

T-SQL Tuesday #193 – Notes to past and future me

By

The last T-SQL Tuesday of the year is hosted by my good friend Mike...

A Note and a Message: T-SQL Tuesday #193

By

This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...

Read the latest Blogs

Forums

What is the PRODUCT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is the PRODUCT

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...

Visit the forum

Question of the Day

What is the PRODUCT

In SQL Server 2025, what does this return? 

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

See possible answers