Server Backup History Report (Full DB Backups only) 1. lists all databases with no backup history 2. lists last backup for other databases includes Date, User, Size, Duration, Age, Finish Date & Location Includes system databases Excludes TempDB Excludes backup history data where backupmediafamily.device_type = 7 these are typically created by Veritas BackupExec Tested on […]
2006-04-28 (first published: 2006-03-23)
4,575 reads
Useful in dev environments when you need to periodically assign execute permissions on all procs in a db (drop/create scripts may have been run without re-assigning permissions)Accepts DB name, ProcLike for matching 'starts with' pattern against proc names in DB, revoke (optional - defaults to 0/True) specifies wheter to GRANT or REVOKE permissions
2002-11-21
386 reads
By Arun Sirpal
Just a really quick FYI for the readers. If you are using Managed Instances...
It has been some time since I last wrote about Azure SQL Database. Although...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Do I still need to run sp_updatestats if I execute DBCC DBREINDEX(tablename) for tables...
Hello. I am looking into setting up a Distributed Availability Group between 2 availability...
Hi guys Setting up a new SQL Server on Azure (Managed Instance). I have...
Ask SSC