Art of the DBA Rotating Header Image

Presentations

SQL Server Security

An overview of implementing grants, denies, and database roles in SQL Server.  Also included are useful auditing queries.

Presentation
Presentation (SQL Saturday 94)
Scripts:

server_logins.sql
server_roles.sql
server_role_audit.sql – Uses xp_logininfo
database_roles.sql
db_roles_audit.sql – Uses xp_logininfo
object_grants.sql

Eating the Elephant – SQL Server Partitioning

An introduction to SQL Server partitioning, what it does, and how to make it work.

Presentation
Scripts:

0-setup_partition_demos.sql
1-Create_Partitions.sql
1a-Partition_Info.sql
2-Partition_Maintenenace.sql
3-Partition_Fragmentation.sql

Exposing the Core – Intro to SQL 2012 on Server Core

Introducing SQL 2012 on Server Core, with step by step instructions on setting up the server and installing SQL 2012.

Presentation 
Scripts:

FirstSteps.txt
2012-Configure_Server.ps1
SQL2012_Core.ini

Tips and Tricks: MSDB BackupSet

Some helpful information on MSDB’s BackupSet table.

Presentation
Script:

BackupSetDemo.sql

Powershell Two-Step

An introduction (Remember Get-Help and Get-Member!)
Script:

TwoStepScript.ps1

Managing Log File Obesity

Presentation
Script:

Demo_Query_Main.sql
Tran_Query_2.sql

The Hierarchy of Monitoring Needs

Presentation
Script:

Survival_Kit.zip

Powershell Tips and Tricks for SQL Server DBAs

Presentation
Script:

Powershell_tips_tricks.ps1

Powershell Jumpstart for SQL Server DBAs

Presentation
Script:

PowershellJumpStart.ps1

SQL Server Benchmarking: The Powershell Speedometer

Presentation

Script:

SQLBenchmarker

Leave a Reply

Your email address will not be published. Required fields are marked *