The 10 Basic Concepts of T-SQL

For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the...

Video: How to Use SQL Server 2016 Live Query Statistics for Watching Live Query Execution

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

SQL Server 2016 for Performance Tuning Lovers

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

T-SQL Programming for Developers Course

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

...

Datediff: We’ve Been Doing It Wrong

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

Performance-Oriented SQL Server Development – The Scripts

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

Performance-Oriented T-SQL Development in Belgium

On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days...

If You Need to Think, You’re Doing It Wrong

A month ago, my wife and I were in Barcelona for a short vacation.
In one of the days, we entered...

My PASS Summit 2016 Session Submissions Feedback

I’m excited to say that I will be delivering a session in this year’s PASS Summit in Seattle later this...

Columnstore Index Enhancements in SQL Server 2016

One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they...