Add database role(s) in multiple databases
Add login to same database roles in multiple databases can be time consuming. You find this useful when you need to add some login to instance. Especially when application using...
Jobs overview
Quick overview of all SQL Agent jobs. You can check how many SQL Agent jobs you have created and their basic information. Returns jobs schedule information and status. Something similar...
Identify missing backups
Quick check if all your databases are backed up. It is important for every DBA that databases you are responsible of are properly backed up. Use this script to identify...
Get backup by LSN
Find backup to complete your restore operation with missing LSN. Sometimes when you have to restore database to point in time you need to find all backup files from backup...
TempDB configuration check
TempDB is heavily used database in every instance, time to check it. As every DBA know TempDB database is shared for all sessions within DB engine. This makes its performance...
Datafile auto-growth events
Looks for auto-growth events in default SQL Server trace. You can find this information in SSMS built-in database standard report Disk usage under charts. This part of report is available...
Set simple recovery model
Switch recovery model to SIMPLE for all databases in loop. This simple cursor query is useful when you need to keep your transactions log maintained automatically by SQL Server. And...
Is database part of an Availability Group?
Check databases membership in Availability Groups. This very nice handy script from Dimitri Janczak can help you in various situations when dealing with Availability Groups. You can handle conditional logic...
Set Single-User mode
Set database to SINGLE_USER mode do something and set MULTI_USER mode. Alter database mode using simple T-SQL statements....
Set Read-Only mode
Set database to read only mode do something and set read write mode. Alter database mode using simple T-SQL statements....