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:
Powershell Two-Step
An introduction (Remember Get-Help and Get-Member!)
Script:
Managing Log File Obesity
Presentation
Script:
Demo_Query_Main.sql
Tran_Query_2.sql
The Hierarchy of Monitoring Needs
Presentation
Script:
Powershell Tips and Tricks for SQL Server DBAs
Presentation
Script:
Powershell Jumpstart for SQL Server DBAs
Presentation
Script:
SQL Server Benchmarking: The Powershell Speedometer
Script:
I’m tweeting!
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,
Sure, have at it.