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,621 reads
vitamindba
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,689 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
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,759 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,640 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,228 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,221 reads
Database Stuck in Suspect Mode
My holiday week did not started off very good. I come in and find a UAT environment database in suspect...
2018-11-27
25,974 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers