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

2 Comments

  1. Alex Fleming says:

    Hi Mike,

    Would it be ok if I reference some of your code on GitHub in my PowerShell SQL Saturday session I’m preparing, and if so, do you have preferences on what information I include to give you credit?

    Additionally, I would like to know what your preferences are between researching existing PowerShell scripts and writing your own scripts from scratch. For example, do you rely heavily on dbatools and only write scripts from scratch if you recognize a problem that you think is unique?

    Can I quote your answer to that question in my presentation?

    On a side note, thank you again for helping me get started in PowerShell – your pre con a few years back was awesome.

    Thank you in advance,

    1. Mike Fal says:

      Sure, have at it.

Leave a Reply

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