Verify Login SID and Machine SID

This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.

Find no of records in each table in database (against Clustered Index)

If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.

PowerShell Query to remove backup folders against multiple servers

Remove backup folders from multiple servers.

Trace Flag

Trace Flags

Extract SQL Server Key details

Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.

Parameters may improve SQL Backup Performance in SQL Server 2008

Simple script to list out SPID, Program_name and login details

If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.

Lock Escalation Limit

Backup Database Size calculation Report - Monthwise

The script helps to calculate the size of the backup of the databases monthwise. This will help to understand the database growth rate from the backup file if we do not have any data collection utility to find the exact details of the DATA File growth.