Noam Brezis is a technology expert and a senior SQL Server consultant at Madeira SQL Server Services. With over 10 years of experience in various technologies, he enjoys a wide knowledge range, from Visual C#, .Net, C++, MFC, COM and VB, through UNIX and Oracle and up to a deep and thorough understanding of SQL Server. In his work, Noam deals on a daily basis with a broad and varied clientele, designing, developing and troubleshooting their SQL Server systems. Noam also spends part of his career teaching SQL Server and frequently speaks at events such as the Israeli SQL Server User Group.

All authors

Blog Post

Pro and Cons of Parameter Sniffing

Look at the following 3 scripts:
-- 1. Hardcoded
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime < '19900101'

-- 2. Variable
DECLARE @FilterDate DATETIME = '19900101'
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime...

2012-01-02

439 reads

All authors

Blogs

Why I stopped using MCP for AI coding stuff

By

Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...

AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning

By

Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...

AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention

By

Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...

Read the latest Blogs

Forums

Dynamic Unpivot

By pietlinden

I have a table I didn't design that has tons of repeating groups in...

Writing as an Art and a Job

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Writing as an Art and...

String Similarity II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item String Similarity II

Visit the forum

Question of the Day

String Similarity II

What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?

See possible answers