List Job Dependencies
A Stored Procedure that lists all Jobs that target a database and the job dependencies
2015-07-29 (first published: 2015-07-02)
2,318 reads
A Stored Procedure that lists all Jobs that target a database and the job dependencies
2015-07-29 (first published: 2015-07-02)
2,318 reads
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,807 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,337 reads
If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.
2015-07-21 (first published: 2015-06-16)
1,504 reads
To monitor SQL service and the host server is up and running, if down send e-mail to DBA
2015-07-16 (first published: 2015-06-15)
2,135 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)
761 reads
This is an expansion of the sys.schemas table.
User schemas are sorted to the top, schema type is decoded, schema authorization is included.
2015-07-14 (first published: 2015-06-10)
1,870 reads
2015-07-10 (first published: 2015-06-11)
1,008 reads
IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.
2015-07-02 (first published: 2015-06-04)
701 reads
This script either generates or execute statements to SQL data and log files from C:\ to D:\
2015-07-01 (first published: 2015-06-03)
2,511 reads
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers