Blog | Madeira Data Solutions

My Session about SQL Server Parameterization

Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the session...

May 10, 20172 min read

In this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution flow for running queries, and how...

May 3, 20171 min read

Last week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of fun and...

May 2, 20171 min read

Are you a software developer? Did you ever get to develop a software that works with a Microsoft SQL Server database? Perhaps you started...

Mar 13, 20172 min read

The Challenge One of our clients in the gaming industry wanted to set up a high availability solution in their data center in the UK....

Feb 1, 20179 min read

Let’s talk about the DATEDIFF vs. DATEADD functions in SQL Server. Each one performs a different task. The former calculates the...

Jan 26, 20174 min read

One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and perhaps the most common of...

Jan 23, 20172 min read

Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel. It was a...

Dec 31, 20161 min read

On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was “SQL Server DBA...

Dec 12, 20169 min read

Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I had the pleasure of attending Summit...

Oct 31, 20165 min read