Find Mismatched Views and Stored Procs
Find missing and mismatched views and stored procs between 2 Databases
2012-09-03 (first published: 2008-05-29)
1,592 reads
Script Table or View structure
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,177 reads
SQL Server Database Backup Status
Lists the Databases and their Backups status in a neatly formatted HTML Email
2009-05-26 (first published: 2009-04-23)
2,798 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Review Early and Often
Comments posted to this topic are about the item Review Early and Often
SQL Agent jobs - script to get what jobs failed
I have been trying to find SQL that shows what SQL Agent jobs failed...
Need help desperately
I accidentally ran this on a dev server which has locked my acct and...
Ask SSC