SQL Server Always On Read Only Routing Lists
With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...
2019-02-12 (first published: 2019-01-23)
2,611 reads
Justin Figg
Let’s talk SQL Server Waits: Topic 2 – CXPacket
With our effort to talk about SQL Waits we come across another common wait called CXPacket. Last week we reviewed...
2019-01-30 (first published: 2019-01-16)
2,687 reads
SQL Server Transaction Log is full due to XTP Checkpoint Error 9002, Severity 17, State 16
I want to take some time and discuss my experiences with a certain SQL Server error, error 9002. Error 9002...
2019-01-10
14,538 reads
What is the Max Degree of Parallelism setting for SQL Server?
Max Degree of Parallelism is a setting that is often changed to improve performance in SQL Server. What exactly does...
2019-01-07 (first published: 2018-12-21)
2,755 reads
Let’s talk SQL Server Waits: Topic 1 – SOS_SCHEDULER_YIELD
Over the next few weeks we will be reviewing some of the common SQL Server Waits. We will explain what...
2019-01-03
1,560 reads
Seeing WriteLog wait type on your SQL Server?
One of the more common wait types for SQL Server is called WriteLog. In its most basic form it is...
2018-12-27 (first published: 2018-12-18)
3,596 reads
Deadlocks in a SQL Server Database
Deadlocks in SQL Server happen when 2 (maybe more) processes are fighting over a resource in the database and are...
2018-12-18 (first published: 2018-12-03)
3,219 reads
Get Rid of those unused indexes!
Indexes in relational databases are very helpful and increase the speed to access data. However maintaining indexes is just as...
2018-12-11
213 reads
Enabling Query Store
Performance tuning in SQL Server is one of the main jobs a DBA has. Starting with SQL Sever 2016 a...
2018-12-05
1,224 reads
What is the SQL Server Trustworthy database property?
I ran across an interesting property set in a SQL Server database for a customer, the property is called “Trustworthy”. ...
2018-11-29 (first published: 2018-11-19)
26,254 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
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...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
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...
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