Chapter 23) SQL Server Profiler

USE AdventureWorks2012;
IF(OBJECT_ID('dbo.uspGetDepartments')) IS NOT NULL
DROP PROC dbo.uspGetDepartments
GO
CREATE PROC dbo.uspGetDepartments
AS
SET NOCOUNT ON
WAITFOR DELAY '00:00:07'
SELECT * FROM HumanResources.Department
SET NOCOUNT OFF

Error: ** – Not able to save as Trace File
Error: ** – Select File | Save As | Trace Template. Not able to save

Chapter 21) Managing and maintaining indexes and statistics

Chapter 22) Maintenance plans

Chapter 23) SQL Server Profiler

Chapter 24) Extended events

Chapter 25) SQL Server security

Chapter 26) Resource Governor

USE master
GO
CREATE FUNCTION sbsClassifier()
RETURNS SYSNAME WITH SCHEMABINDING
BEGIN
DECLARE @Group sysname
IF(SUSER_SNAME()) = 'daled'
BEGIN
SET @Group = 'sbsSSMSgroup'
END
RETURN @Group
END
GO

USE MASTER
GO
ALTER RESOURCE GOVERNOR with (CLASSIFIER_FUNCTION = dbo.sbsClassifier)
ALTER RESOURCE GOVERNOR RECONFIGURE
GO

Chapter 27) SQL Server Agent

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\LOG\

Nightly full backup of the AdventureWorks database that runs at midnight every day including weekends.

use master
go
BACKUP DATABASE AdventureWorks2012
TO C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\AdventureWorks2012.bak