Below are some of my key resources:-
- SQLDBA-SSMS-Solution
- Backup-Restore
- Contains TSQL scripts for SQL Server Instance Migration
- Baselining
- Contains TSQL scripts for setting up baselining SQL Server Instance, and all Analyzing the collected Data
- BlitzQueries
- Contains TSQL scripts that can be used for analyzing data using ‘First-Responder-Kit‘
- Blocking Alert
- TSQL Script to setup Blocking Alert on SQL Server
- Deadlock_Detection_SQLTrace
- TSQL Script that can be used to Setup SQL Trace to capture DeadLock graphs.
- Customized for a specific job as well
- LogShipping
- TSQL code to setup Custom Log Shipping
- StackOverflow
- TSQL Code and
help links related to famous StackOverflow dumps provided by StackExchange site.
- TSQL Code and
- sp_HealthCheck
- A procedure that gives currently running queries, CPU and Memory usage, Usage of Data & Log Volumes, Space utilization of data/log files, Lead Blockers, and session details performing Backup/Restore/Rollback.
- Backup-Restore
- Space-Capacity-Automation
- This automation has been designed to eliminate manual efforts on Space Capacity ESC tickets where DBA has to add new data or log files on
new volume, and restrict data or log files onold volume. Apart from this, this procedure can be used forvariety of tasks related to capacity management.
- This automation has been designed to eliminate manual efforts on Space Capacity ESC tickets where DBA has to add new data or log files on
- SQLDBATools
- Powershell Module containing cmdlets for carrying out SQL DBA activities.
- SQL_Lab
- Contains scripts to
steup SQL Server Lab Environment from Scratch using Oracle Virtual Box
- Contains scripts to
DatabaseInventory - Django based UI for SQLDBATools based Inventory Setup.
- SQL DBA/Developer Tricks
- [SQLDBATools] Powershell Module
- Space Capacity Automation
- Build SQL Server Virtual Lab