GitHub - wondisha/SQLDBAInventory: SQLDBAInventory

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 241 Commits
10-Find DB Name Using SP		10-Find DB Name Using SP
15-List Of All SSIS Packages In MSDB Database		15-List Of All SSIS Packages In MSDB Database
AG HeathCheck		AG HeathCheck
AlwaysOn-Add Alwayson to failover cluster		AlwaysOn-Add Alwayson to failover cluster
Audit--DB--All DB Read Access		Audit--DB--All DB Read Access
Audit--DB--Database schema wise size detail		Audit--DB--Database schema wise size detail
Audit--DB--Identify backup tables within production databases		Audit--DB--Identify backup tables within production databases
Audit--DB--Orphaned login report for all databases		Audit--DB--Orphaned login report for all databases
Audit--Enabling TDE on Databases in an AlwaysOn Scenario		Audit--Enabling TDE on Databases in an AlwaysOn Scenario
Audit--Identify_All_Logins_With_No_Associated_Default_Database_User.sql		Audit--Identify_All_Logins_With_No_Associated_Default_Database_User.sql
Audit--Move DB roles		Audit--Move DB roles
Audit--SQL Instance Details		Audit--SQL Instance Details
Audit--SQL Server Check		Audit--SQL Server Check
Audit--SQL Server Configuration		Audit--SQL Server Configuration
Audit--SQL Server System Audit Report		Audit--SQL Server System Audit Report
Audit--Script All Logins_Users_and Roles		Audit--Script All Logins_Users_and Roles
Audit--Security Queries: Database-level		Audit--Security Queries: Database-level
Audit--Security Queries: Server-level		Audit--Security Queries: Server-level
Audit--Security_Audit_Report		Audit--Security_Audit_Report
Audit--Show all permissions in a database		Audit--Show all permissions in a database
Audit--Size Of Each Folder In a Path		Audit--Size Of Each Folder In a Path
Audit--Sync Logins		Audit--Sync Logins
Audit--Trace File Report		Audit--Trace File Report
Audit--View Server Roles and Permissions per Login		Audit--View Server Roles and Permissions per Login
Audit--Windows logins not in AD		Audit--Windows logins not in AD
Audit--dba_CopyLogins		Audit--dba_CopyLogins
Audit-DB--DBGrowth		Audit-DB--DBGrowth
Audit-Delete All Database User Accounts for a Given Server Login		Audit-Delete All Database User Accounts for a Given Server Login
Audit-SP_WHO5		Audit-SP_WHO5
Auto Generate Database Detach and Attach Scripts		Auto Generate Database Detach and Attach Scripts
Backup Audit		Backup Audit
Backup- Backup & Restore Status		Backup- Backup & Restore Status
Backup--All DB's at once with copy_only		Backup--All DB's at once with copy_only
Backup-History		Backup-History
Blocking Queries Report		Blocking Queries Report
Blocking--Alert to DBA		Blocking--Alert to DBA
Blocking--Head Blocker		Blocking--Head Blocker
Blocking-Lead Blocker Script		Blocking-Lead Blocker Script
Blocking-Tree Script Report		Blocking-Tree Script Report
Copy Bkp files to remote path		Copy Bkp files to remote path
DB Integrity & Backup Report Notification		DB Integrity & Backup Report Notification
DB Mail Settings Scriptout		DB Mail Settings Scriptout
DB- DB owner to SA		DB- DB owner to SA
DB--All DB's Size Report		DB--All DB's Size Report
DB--All DB's free space report		DB--All DB's free space report
DB--AutoGrowth Events Report		DB--AutoGrowth Events Report
DB--AutoGrowth Frequency Report		DB--AutoGrowth Frequency Report
DB--AutoGrowth Settings Report		DB--AutoGrowth Settings Report
DB--AutoGrowth of all DB Report		DB--AutoGrowth of all DB Report
DB--Backup Growth Trend Check		DB--Backup Growth Trend Check
DB--Create Database using dynamic SQL		DB--Create Database using dynamic SQL
DB--DB Files Size & Free space on disk		DB--DB Files Size & Free space on disk
DB--DBSnapShot		DB--DBSnapShot
DB--Database File Move Generate		DB--Database File Move Generate
DB--Database Size and Growth Report		DB--Database Size and Growth Report
DB--Database and Log sizes, free space and location		DB--Database and Log sizes, free space and location
DB--FileSize and LogUsage for all DBs		DB--FileSize and LogUsage for all DBs
DB--Kill all connections		DB--Kill all connections
DB--Log File Growth Report		DB--Log File Growth Report
DB--Migration Steps		DB--Migration Steps
DB--Move database files to another Drive		DB--Move database files to another Drive
DB--Quick DBSnapshot		DB--Quick DBSnapshot
DB--Smart--Adaptative Files Autogrow		DB--Smart--Adaptative Files Autogrow
DB--Tempdb AutoGrowth Report		DB--Tempdb AutoGrowth Report
DB--Transaction Log VLF Alarm		DB--Transaction Log VLF Alarm
DB--configure Log File Size for Large DBs		DB--configure Log File Size for Large DBs
DB--database restore COMPLETION datetime		DB--database restore COMPLETION datetime
DB--move of DB files from one location to another		DB--move of DB files from one location to another
DB-Data & Log Files Space Report		DB-Data & Log Files Space Report
DB-Refresh-Permissions Extract		DB-Refresh-Permissions Extract
DBCC CHECKDB Email Automation		DBCC CHECKDB Email Automation
DBCC--CheckDB Last Run Report		DBCC--CheckDB Last Run Report
DBCC-Last Run Report		DBCC-Last Run Report
Database and Log backups using PowerShell		Database and Log backups using PowerShell
DeadLock--ShredDeadlockGraph		DeadLock--ShredDeadlockGraph
DeadLocks--Monitor_Deadlocks_with_Extended_Events		DeadLocks--Monitor_Deadlocks_with_Extended_Events
Deadlock graph from SQL Extended Events		Deadlock graph from SQL Extended Events
Deadlock--Deadlock details from ErrorLog		Deadlock--Deadlock details from ErrorLog
Disk--Server Disk Space report		Disk--Server Disk Space report
Email SP Results		Email SP Results
Execute All .SQL Script easily		Execute All .SQL Script easily
FileGroup--Split-FileGroup		FileGroup--Split-FileGroup
FileGroup--Which_Filegroup_is_that_Partition_Using		FileGroup--Which_Filegroup_is_that_Partition_Using
Find DB Name using SP Name		Find DB Name using SP Name
HTML Table Results For Email		HTML Table Results For Email
HealthCheck-Useful Scripts		HealthCheck-Useful Scripts
Index -- Missing Index Script with Create Statement		Index -- Missing Index Script with Create Statement
Index recommendations from SQL Server Database		Index recommendations from SQL Server Database
Index--All DB Frag Report		Index--All DB Frag Report
Index--Duplicate Index Report		Index--Duplicate Index Report
Index--Index Breakdown Report		Index--Index Breakdown Report
Index--Index Rebuild Script(Smart)		Index--Index Rebuild Script(Smart)
Index--Missing index with change impact percentage		Index--Missing index with change impact percentage
Index--Rebuild Report & Action--Careful		Index--Rebuild Report & Action--Careful
Index--SQL Server Missing Index		Index--SQL Server Missing Index
Index--Smart Index reorganize and rebuild		Index--Smart Index reorganize and rebuild
Index-DB Missing Index Report Alert		Index-DB Missing Index Report Alert
Index-Missing Index find		Index-Missing Index find
Index-Rebuild Index Script Generate		Index-Rebuild Index Script Generate
Index-Rebuild-ReOrganize-Report		Index-Rebuild-ReOrganize-Report