Using Indexing To Solve Blocking and Deadlocking Issues
A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help...
2019-03-20 (first published: 2019-03-05)
3,020 reads
A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help...
2019-03-20 (first published: 2019-03-05)
3,020 reads
This months TSQL Tuesday is hosted by Shane O’Neill (Blog | Twitter) Shane explains the Topic as:
Dipping into the Cookie Jar...
2019-03-12
277 reads
This month’s TSQL Tuesday comes from Shane O’Neil and he’s asking us to ‘dip into the cookie jar’ (or raid...
2019-03-12
234 reads
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
241 reads
Post Updated: Replaced Query 3 with transactions/sec query.
When we first published 7 ways to Query Always On Availability Groups using...
2019-02-19
354 reads
Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.
We’ve spotted an issue where unicode...
2019-02-14
122 reads
It’s 4am in the morning and my phone starts ringing.
A blury eyed, me picks it up to hear the voice...
2019-02-07
327 reads
We’re pleased to announce the release of the Undercover Catalogue 0.2 and can be downloaded from https://github.com/SQLUndercover/UndercoverToolbox/tree/master/SQLUndercoverCatalogue
The new version brings...
2019-02-04
121 reads
During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit...
2019-01-22 (first published: 2019-01-14)
2,045 reads
Unfortunately we discovered a small bug in 1.3, the Database ownership module default warning level was not showing a yellow...
2019-01-16
172 reads
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Comments posted to this topic are about the item 25 Years of SQL Server...
Comments posted to this topic are about the item The Decoded Value
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers