DBA Outsourcing tools

[leandrosardi]

Providing DBAs with the tools they need for SQLServer Administration.

[leandrosardi]

1. Create a read-only user for DBA

2. Install these Brent Ozar's scripts

3. Install these sp_whoisactive

4. Gran DBA

use master
go
GRANT EXECUTE ON sp_blitzindex TO ***;
GRANT EXECUTE ON sp_whoisactive TO ***;
GRANT VIEW SERVER STATE TO ***;
GRANT SHOWPLAN TO ***;
GO

use euler
go
GRANT VIEW DEFINITION TO dev
GO

use kepler
go
GRANT VIEW DEFINITION TO dev
GO

use copernico
go
GRANT VIEW DEFINITION TO dev
GO

5. Create database DBA_Tools, make the DBA dbo in it

use master
go

CREATE DATABASE DBA
GO

USE DBA
GO
CREATE USER [dev] FOR LOGIN [dev]
GO
use DBA
go
EXEC sp_addrolemember 'db_owner', 'dev';
GO