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,594 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,680 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,385 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,749 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,554 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,580 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,211 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
208 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,218 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,083 reads
Blogs
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
PASS Data Summit 2025 Recap
By Tim Mitchell
Last week, I attended the annual PASS Data Summit in Seattle. This was the...
Forums
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers