Toolbox - Fix Your FILEGROWTH
One of the items we usually flag in reports is FILEGROWTH by percentage. It doesn't help that for most versions...
2017-10-10 (first published: 2017-10-05)
1,833 reads
Nebraska SQL from @DBA_ANDY
Come See Me in Minnesota in October!
The schedule for SQL Saturday #682 Minnesota 2017 is out, and I will be giving my talk on Extended Events:
--
Getting...
2017-09-14
517 reads
Toolbox - IO, IO, Why are You So Slow?
This is the next in a series of blogs I am going to create talking about useful tools (mostly scripts)...
2017-09-13 (first published: 2017-09-06)
3,569 reads
The Transient Database Snapshot Has Been Marked Suspect
Yet another tale from the ticket queue...
The DBCC CheckDB was failing on INSTANCE99 and after some investigation it looked like...
2017-09-07 (first published: 2017-08-24)
4,346 reads
Sudden Differential Backup Failures after an Availability Group Failover
As so many stories do, this story starts with a failover - in this case an Availability Group (AG) failover.
https://cdn.meme.am/cache/instances/folder984/400x/59300984.jpg
There were...
2017-07-24
1,592 reads
Toolbox - Which Tables are Using All of My Space?
This is the next in a new series of blogs I am going to create talking about useful tools (mostly...
2017-07-21
487 reads
T-SQL Tuesday #92 - Trust But Verify
It's T-SQL Tuesday time again, and this month the host is Raul Gonzalez (blog/@SQLDoubleG). His chosen topic is Lessons Learned...
2017-07-21 (first published: 2017-07-11)
2,470 reads
Toolbox - Where Did All My Space Go?
This is the first in a new series of blogs I am going to create talking about useful tools (mostly...
2017-07-14 (first published: 2017-07-03)
2,171 reads
9003 is a Scary Number
My last post talked about 9002 errors and how they *might* be corruption.
Recently I moved up to the next consecutive...
2017-06-21
1,953 reads
It's Just Another 9002...another error like all the rest...
11:30pm on a Saturday night, and the pager went off…
Error: 5901, Severity: 16, State: 1.One or more recovery units belonging...
2017-05-05
1,819 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers