Taking Backup Of All DBs

Wrote the script to take compressed backup with combining many other features.

Taking backup of the databases to the Active server alone

If you have Always On and need to stop running database backups to the stand by server, use the script.

Use Of Cursor Vs Simple While Loop

You can eliminate CURSOR many a places using WHILE Loop.

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.

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

Delete Windows Service

Different ways to find Powershell Version

SQL Jobs

Maximum number of supported Partitions in SQL 2014

Trace Flag