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,438 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,398 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
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers