Did Not Know That - Redirecting CMD to the Clipboard
One of the items I frequently deal with as a Production DBA is drive alarms. I have written previously about...
2018-09-12 (first published: 2018-09-04)
2,865 reads
Nebraska SQL from @DBA_ANDY
The Mystery of the Exploding T-Log
There were a stack of errors overnight in the DB123 database on SQL01, including one horror show error:
--
Log Name: ApplicationSource: MSSQLSERVERDate: 5/24/2018...
2018-08-20 (first published: 2018-08-02)
2,887 reads
Speaking This Weekend in Iowa City!
Come out to SQL Saturday Iowa at the University of Iowa this Saturday 06/23/2018 for a SQL Saturday that never...
2018-06-21
413 reads
Revoke the permission(s) before dropping the server principal
As a remote DBA I often have to log in to client systems for a fixed amount of time and...
2018-06-27 (first published: 2018-06-15)
14,026 reads
Double Win- Watch DeWitt and Help SQLSoldier's Loved Ones!
Brent Ozar (blog/@BrentO) is sponsoring a special webcast in a couple weeks, with an amazing presenter:
https://www.brentozar.com/archive/2018/06/announcing-a-very-special-sqlfamily-webcast-with-dr-david-dewitt/
The webcast (“SQL Query Optimization....
2018-06-09
823 reads
Speaking at PASS Summit 2018!
I found out a few days ago that one of my sessions was selected for Summit this Fall - I will...
2018-06-06
281 reads
Toolbox - How Long Has My Server Been Up?
https://imgflip.com/i/2axp6yNo..not that Up (although it is awesome!)
--
As a remote service provider a common request is to follow up after a server...
2018-05-24
327 reads
When Good Query Plans Go Bad
Today's story starts again with a page escalation:
--
We are seeing very high CPU usage on DistServer01. Could you please take...
2018-05-25 (first published: 2018-05-18)
3,146 reads
Why Don't I have a Preferred Replica?
The client reported that the log file on their main database was growing unusually large, and when they checked the...
2018-04-27 (first published: 2018-04-18)
4,128 reads
Toolbox - Do You Have Current Backups?
On our managed servers we run a job each day to check that either a FULL or DIFF has run...
2018-04-04
679 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers