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...

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

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

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...

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

On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days in Belgium, and this time it’s...

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

The best thing about being an SQL Server consultant is that you get called in on the most interesting cases. By “interesting” I mean...

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

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