Data has become the most valuable resource for modern enterprises. However, the people tasked with managing this valuable resource have one foot out the door. According to the recent State of Database ...

CREATE INDEX idx_portfolio_provider ON portfolio_image(provider_id); ...

-- to recover databases to the latest backup. Note that Differential backups are not included. EXEC dbo.sp_ineachdb @command = ' DECLARE @databaseName sysname; DECLARE @backup_set_id_start INT; ...