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

410 reads

All authors

Blogs

Parsing EXE Output in PowerShell

By

I saw a post internally that asked this question: Anyone have a handy powershell...

Connect With More Clients: Our Partner Directory Has Arrived

By

The partner directory connects your agency with new customers.

Can You See Who Forced a Plan

By

I had an excellent group of people in Gothenburg Sweden when I taught there...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

Output to flat file with no delimiter

By stricknyn

Hello all, Is there an easy way to output my records to a flat...

Refactoring Databases: Evolutionary Database Design

By Site Owners

Comments posted to this topic are about the item Refactoring Databases: Evolutionary Database Design

Visit the forum

Question of the Day

Concat Addition

What is the result of this code? 

SELECT CONCAT(1, 2, 3) + 4

See possible answers