Report Alerts from SQL ErrorLog
Sends Back Critical Alerts from ErrorLog occurred in the last 24 Hrs. You can even modify the data [Check @start and change the value]
2016-05-26 (first published: 2015-05-15)
2,321 reads
Sourav Mukherjee
- Interests: Like to make friendship with people.
Execute All .SQL Script easily
If you have a requirement to create Proc/Tables, etc to a SQL Server taking .SQL scripts from a central location (UNC), then you can use my script.
2016-05-24 (first published: 2015-05-18)
2,379 reads
Delete Backups Older than N Days
SCRIPT TO DELETE OLDER THAN N' DAYS BACKUP FROM A DEFAULT BACKUP DIRECTORY. IF DAYS = 0, PROVIDED,
IT WILL DELETE ALL BACKUP FILES FROM THE BACKUP LOCATION.
2016-03-31 (first published: 2015-03-16)
3,320 reads
Getting transaction log space usage statistics for all databases.
Easy way to get the TLOg space Usage details
2015-12-07 (first published: 2015-11-19)
1,245 reads
Capture the tasks performed in a text file
Creates a record of all or part of a Windows PowerShell session in a text file.
2015-10-02 (first published: 2015-09-17)
1,047 reads
2015-10-01 (first published: 2015-09-13)
1,766 reads
Retrieving XML data to Table from dm_os_ring_buffers
Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose
2015-08-27 (first published: 2015-08-03)
928 reads
Cleanup Older than 30 days of Files & Folder through SQL Job
Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job
2015-08-24 (first published: 2015-08-04)
1,738 reads
Query to Delete all Folders, Sub-Folders and Files located in a Path
A script to help you cleanup Files/Folders & Sub-folders.
2015-08-20 (first published: 2015-07-30)
14 reads
List Out All User Defined Triggers
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2015-08-06 (first published: 2015-07-07)
790 reads
Blogs
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
Daily Coping 14 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
WIT Mental Health and Wellness Videos Posted
By Steve Jones
I was honored to speak at the WIT Mental Health and Wellness day last...
Forums
SSRS report server installation
If we want to install SQL server SSRS service on another server separating it...
prevent certain characters being inserted into table
Hello, So i am assigned a task, that if a user inserts a certain...
Ask SSC