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,834 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
520 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,570 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,347 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,593 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
488 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,472 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,172 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,957 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,820 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...
Question of the Day
The Decoded Value
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