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,522 reads
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,522 reads
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,753 reads
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,290 reads
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)
710 reads
2013-12-06 (first published: 2011-01-31)
4,667 reads
This script uses the backup tables to get info on the growth of your database files.
2013-05-07 (first published: 2009-02-03)
12,833 reads
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
I am very excited and lucky to be speaking once again at SQLBits along...
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Hello everyone I hope everyone's ok. I have this query and I'm trying to...
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?