T-SQL Tuesday #89 – The O/S It is A-Changing
It's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...
2017-04-11
590 reads
Nebraska SQL from @DBA_ANDY
Who Left Those Old Components in My New Database???
Recently a client requested some new transactional replication publications on a relatively new pre-production server. The client has plenty of...
2017-04-13 (first published: 2017-04-07)
2,312 reads
Querying SQL and Windows Version Info with T-SQL
Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself. There are...
2017-04-10 (first published: 2017-03-24)
31,796 reads
Embrace The Missing Index DMVs - But Proceed with Caution!
One of the performance tools I use all of the time is the set of Missing Index DMVs: · sys.dm_db_missing_index_details– Detailed...
2017-03-22 (first published: 2017-03-09)
4,137 reads
How many Backups is Too Many?
Does this title seem strange? Of course we know this is the true answer:
https://cdn.meme.am/cache/instances/folder633/58097633.jpg
But here is a story of a...
2017-03-02 (first published: 2017-02-24)
2,678 reads
YouTubing Down the SQL Server River
I recently stumbled on a YouTube channel from one of my favorite SQLPeople - she is sharp (and an MCM) and...
2017-02-10
606 reads
#SQLSpeaking this Fall!
I have some great speaking dates coming up this Fall - here is the list:
--
First - the big one. I am honored...
2016-09-15
425 reads
Thank You SQL Saturday Sioux Falls!
I just finished giving my SQL Saturday presentation on "Getting Started with Extended Events" at SQLSaturday Sioux Falls. The audience...
2016-07-23
460 reads
Finding File Growths with Extended Events
I give a SQLSaturday session called "Introduction to Extended Events" and at a recent presentation I had a pair of...
2016-06-17 (first published: 2016-06-13)
6,431 reads
How Do I Change My Domain Password on Windows Server 2012?
As a DBA I spend a lot of time in RDP sessions, both to SQL Servers and to "jump"/pass-through servers...
2016-05-23
5,961 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