2013-04-03 (first published: 2013-03-08)
1,692 reads
Scripts
2013-04-02 (first published: 2008-09-11)
15,391 reads
2013-04-01 (first published: 2013-03-08)
1,809 reads
2013-03-29 (first published: 2013-03-08)
1,439 reads
Backup history details EMAIL (past 24 hours) in HTML format
Get backup status email daily to your inbox in HTML format.
2013-03-27 (first published: 2013-03-14)
2,400 reads
2013-03-26 (first published: 2013-03-15)
792 reads
Monitor current transactions and get all required information
Check which transactions are running, query text, percent complete , query_plan, wait_type, and how long they have been running etc. - with one command.
2013-03-25 (first published: 2013-03-15)
2,314 reads
Powershell - Document your environment
This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".
2013-03-22 (first published: 2013-02-27)
2,408 reads
2013-03-21 (first published: 2013-02-27)
1,267 reads
2013-03-19 (first published: 2013-03-01)
1,061 reads
Blogs
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...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
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