DATEDIFF vs. DATEADD

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

SQL Server DBA Tips that Can Save Your Ass

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

A Recap of PASS Summit 2016

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

Machine Learning – What is It Good For?

Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it,...

Recap of My 24HOP Session – From XML to JSON

Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There...

Why Would I Want to Use JSON in SQL Server?

SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...

Query Timeout of the Distribution Agent

Last week I got a call from one of our clients. They issued an ALTER TABLE command in order to...

SQL Server 2016 Cumulative Update 1

On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to...

Who the Hell is Going to Listen to SQL Server on the Radio

About 3 years ago Matan Yungman contacted me and said he has an interesting proposition. We met and talked about...

We Must Wait for SP1 before Upgrading to SQL Server 2016

This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016

I’ve been...