Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS chapter and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.

Blog Post


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


5,549 reads


Daily Coping 19 Oct 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Commenting a branching IF-THEN-ELSE.


I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an...

External Temp Tables Preventing Plan Reuse in Stored Procedures


Here’s an interesting issue that recently came up. We were seeing very high compilations...

Read the latest Blogs


Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

Grouping , time difference in minutes

By gjoelson 29755

Hi, I'm trying to query the amount of minutes a column value stays below...

Reset of a single column in sys.dm_exec_query_stats

By obouda

Dear friends, I have a custom performance monitor based on snapshotting sys.dm_exec_query_stats, and now...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers