Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by S M

SQLServerCentral.com profile

   Items 1 to 20 of 46    Older >>
 

Getting transaction log space usage statistics for all databases.

Easy way to get the TLOg space Usage details  Read more...
By S M 2015/12/07 | Source: SQLServerCentral.com | Category: space usage
Rating: |  Discuss |   Briefcase | 1,080 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.  Read more...
Rating: |  Discuss |   Briefcase | 929 reads

Open Transaction details

sql server blocking, open transaction  Read more...
By S M 2015/10/01 | Source: SQLServerCentral.com | Category: transactions
Rating: |  Discuss |   Briefcase | 1,593 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  Read more...
By S M 2015/08/24 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,376 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  Read more...
By S M 2015/08/27 | Source: SQLServerCentral.com | Category: ring buffer
Rating: |  Discuss |   Briefcase | 841 reads

Query to Delete all Folders, Sub-Folders and Files located in a Path

A script to help you cleanup Files/Folders & Sub-folders.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase

Kill all USer Sessions before starting to restore a Database

If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script  Read more...
By S M 2015/08/05 | Source: SQLServerCentral.com | Category: sql restore
Rating: |  Discuss |   Briefcase | 1,645 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.  Read more...
By S M 2015/08/06 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 738 reads

Setup Alerts for SQL Replication

If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.  Read more...
By S M 2015/07/21 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 761 reads

Delete Backup Files From Default Backup Location

IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.  Read more...
By S M 2015/07/02 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 523 reads

Disk Free Space Check

IF you have a requirement to check disk free space and want to report to the team using email, can use my script  Read more...
By S M 2015/06/17 | Source: SQLServerCentral.com | Category: dbmail
Rating: |  Discuss |   Briefcase | 1,401 reads

Disk Free Space Check

IF you have a requirement to check disk free space and want to report to the team using email, can use my script  Read more...
By S M 2015/06/03 | Source: SQLServerCentral.com | Category: dbmail
Rating: |  Discuss |   Briefcase | 203 reads

Backup Growth Trend Check

-- Backup Growth Trend Check To Understand how much disk space you need in future  Read more...
By S M 2015/06/23 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 986 reads

Copy Backup Files to Remote Shared Location & Delete them periodically

If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.  Read more...
By S M 2015/06/18 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,270 reads

Standardizing DBMAIL Profile & Account Setup for Notification

If you have a requirement to setup with a default global dbmail profile and account you can use my script.  Read more...
By S M 2015/06/16 | Source: SQLServerCentral.com | Category: sql server mail
Rating: |  Discuss |   Briefcase | 931 reads

Check Up Size Of Each Folder In a Path

If you have any requirement to check the size of each sub-folders in a path, you can use my script.  Read more...
By S M 2015/06/11 | Source: SQLServerCentral.com | Category: sql directory size
Rating: |  Discuss |   Briefcase | 1,081 reads

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.  Read more...
By S M 2015/06/10 | Source: SQLServerCentral.com | Category: sql script- automation.
Rating: |  Discuss |   Briefcase | 1,597 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2015/06/05 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,028 reads

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]  Read more...
By S M 2015/06/02 | Source: SQLServerCentral.com | Category: sql errorlog
Rating: |  Discuss |   Briefcase | 1,583 reads

Query to find size of each disk file in a location

Query to find size of each file in a location  Read more...
By S M 2015/05/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 972 reads
   Items 1 to 20 of 46    Older >>