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

427 reads

All authors

Blogs

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

By

I hosted this month, but I decided to put my own entry in as...

Why Databases Still Fascinate Me

By

I get asked a lot about why or how I began working with databases...

Monday Monitor Tips: ServiceNow Integration

By

Earlier this year I visited a customer that was using the Redgate Monitor webhook...

Read the latest Blogs

Forums

Implementing PostgreSQL with Python for Real-Time Logging and Monitoring

By sabyda

Comments posted to this topic are about the item Implementing PostgreSQL with Python for...

Identify a Slipstream Installation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identify a Slipstream Installation

Internal Staff Growth

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Internal Staff Growth, which is...

Visit the forum

Question of the Day

Identify a Slipstream Installation

I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?

See possible answers