My upcoming Speaking Schedule
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Over the next...
2013-09-23
766 reads
Klaus Aschenbrenner
Announcing the SQLpassion Online Academy
Over the last weeks it was a little bit silent on my Weblog for a very good reason: I’m very...
2013-09-16
823 reads
How to become a better, well-rounded SQL Server DBA
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
People are sometimes...
2013-09-04
855 reads
Extreme Transaction Processing (XTP, Hekaton) – the solution to everything?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
My complete last...
2013-08-12
2,167 reads
Survey: Are you a SQL Server Professional and running on Mac?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
I know a...
2013-08-08
1,146 reads
SQL Server Quickie #7 – TempDb Latch Contention
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...
2013-07-23
1,274 reads
SQL Server Quickie #6 – THREADPOOL Starvation
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...
2013-07-07
1,548 reads
Improved Temp Table Caching in SQL Server 2014
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Under some preconditions...
2013-06-27
3,184 reads
Non-Clustered Indexes on Table Variables in SQL Server 2014
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Earlier today I...
2013-06-26
7,372 reads
First steps with Extreme Transaction Processing – Hekaton
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
A few hours...
2013-07-02 (first published: 2013-06-25)
3,848 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Expensive CPUs
Comments posted to this topic are about the item Expensive CPUs
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers