Sql Server Guide for DBA

Find out which database is using the most IO   When there are many databases on one drive and you need to find out  which one is causing IO ...

 You can use below script to start and stop remote SQL services. * Just for one computer (Get-Service -ComputerName YOURCOMPUTERNAME -Name ...

 You must need SqlServer module is the current PowerShell module to use below script. The SqlServer module comes with: PowerShell Provide...

Run below script to generate users and permission in any databases. Mostly it helps to generate users and its permission before refreshing ...

You need to add database name where I put DBNAME in this script. It will give you full, differential and log backup history. I know how impo...

I have script which tells you who is part of groupid. It helps to find some login issue. declare @DomainGroupName varchar ( 50 ) sel...