Build a Career Radar
A technology radar can help you assess what's important and where to focus your effort. Companies use these, and Steve Jones says you should as well.
Get Set For Speed
Loops are common in application code, but set-based solutions are the way to go with SQL.
"But It Worked in Development!" - 3 Hard SQL Server Performance Problems
You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.
An AI Loophole
We can't always explain how AI systems work. Steve Jones wonders if this is a loophole in the GDPR legislation.
Performance Comparison Between SQL Server 2014 and 2016
This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.
Degree of Duplication
Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe Celko reminisces about the history of database design and how it relates to the concept of ‘Degree of Duplication’ in this article.
Brush Up on Your ETL Skills
The need for data imports, exports, and transformations seems to be growing.
SQL Server Reporting Services 2017 Tutorial
SQL Server Reporting Services has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, web front end and security make SSRS the tool of choice.
Solve Sudoku with T-SQL - Part 1
A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers