sp_what
Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.
*Dont you just love totally non subjective assessments like this?
2018-11-01 (first published: 2018-10-22)
2,948 reads
Nicholas Williams
Email SP Results
Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.
2016-12-05 (first published: 2015-05-29)
2,786 reads
DB Integrity & Backup Report
This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.
2015-07-23 (first published: 2015-06-23)
1,314 reads
Recent Restore History
This script simply returns the most recent restore information about databases for a server.
Returns the destination database name, the device used to perform the restore and the restore date.
2015-07-15 (first published: 2015-06-10)
729 reads
2013-12-06 (first published: 2011-01-31)
4,791 reads
Database Growth History
This script uses the backup tables to get info on the growth of your database files.
2013-05-07 (first published: 2009-02-03)
14,508 reads
Blogs
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
From Chaos to Clarity: How Microsoft Purview Streamlines Data Governance
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers