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...
2017-08-29
1,355 reads
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...
2017-05-15 (first published: 2017-05-03)
1,256 reads
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...
2017-05-02
2,110 reads
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?
...
2017-03-13
799 reads
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...
2017-01-23
2,221 reads
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,...
2016-12-30
909 reads
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...
2016-09-29
601 reads
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...
2016-06-29
642 reads
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...
2016-06-24
424 reads
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...
2016-05-10 (first published: 2016-04-27)
6,101 reads
Blogs
The End of Year Vacation Burn
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
Speaking at PASS Summit 2025
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Powershell script to generate SQL server Inventory in CSV format
Comments posted to this topic are about the item Powershell script to generate SQL...
Database Ledger in SQL Server 2022
Comments posted to this topic are about the item Database Ledger in SQL Server...
Question of the Day
Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers