GitHub - Olumoses/SQLDBAInventory: SQLDBAInventory

Name		Name	Last commit message	Last commit date
Latest commit History 333 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 -- SQL 2012 Always On Status Report		AlwaysOn -- SQL 2012 Always On Status Report
AlwaysOn--AAG DB State Monitoring Report		AlwaysOn--AAG DB State Monitoring Report
AlwaysOn--AlwaysOn Availability Group Read Only Routing Script		AlwaysOn--AlwaysOn Availability Group Read Only Routing Script
AlwaysOn-Add Alwayson to failover cluster		AlwaysOn-Add Alwayson to failover cluster
Audit--AD Accounts		Audit--AD Accounts
Audit--DB Properties		Audit--DB Properties
Audit--DB Users, Roles Report		Audit--DB Users, Roles Report
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--Delete All Database User Accounts for a Given Server Login		Audit--Delete All Database User Accounts for a Given Server Login
Audit--Enabling TDE on Databases in an AlwaysOn Scenario		Audit--Enabling TDE on Databases in an AlwaysOn Scenario
Audit--Extract DB Permissions-2		Audit--Extract DB Permissions-2
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--Read Only access to all databases to a user in a SQL Server Instance		Audit--Read Only access to all databases to a user in a SQL Server Instance
Audit--SQL Instance Details		Audit--SQL Instance Details
Audit--SQL Login Password Audit		Audit--SQL Login Password Audit
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 Change Snapshot		Audit--Security Change Snapshot
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--User database and server roles		Audit--User database and server roles
Audit--Users , Roles and Logins Report		Audit--Users , Roles and Logins Report
Audit--Verify Login SID and Machine SID		Audit--Verify Login SID and Machine SID
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--Backup History		Backup--Backup History
Backup--Backup Status for an SQL Instance		Backup--Backup Status for an SQL Instance
Backup--Backup all SSAS databases using TSQL		Backup--Backup all SSAS databases using TSQL
Backup--Database Backup duration		Backup--Database Backup duration
Backup--Full Backup Duration Report		Backup--Full Backup Duration Report
Backup-Generate Backup Script Dynamically		Backup-Generate Backup Script Dynamically
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
CPU--Capture current queries when cpu is above certain threshold		CPU--Capture current queries when cpu is above certain threshold
Copy Bkp files to remote path		Copy Bkp files to remote path
DB -- database files and free space on disk		DB -- database files and free space on disk
DB Integrity & Backup Report Notification		DB Integrity & Backup Report Notification
DB Mail Settings Scriptout		DB Mail Settings Scriptout
DB Mail--Changing database mail account SMTP servers		DB Mail--Changing database mail account SMTP servers
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--All Tables Row Count		DB--All Tables Row Count
DB--Audit--Database Users and their Corresponding Roles		DB--Audit--Database Users and their Corresponding Roles
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--Change DB Owner to sa for multiple DB's		DB--Change DB Owner to sa for multiple DB's
DB--Change Database Collation		DB--Change Database Collation
DB--Change database compatability level of all databases		DB--Change database compatability level of all databases
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--Data File Information Report		DB--Data File Information Report
DB--Database File Move Generate		DB--Database File Move Generate
DB--Database Growth Audit		DB--Database Growth Audit
DB--Database Growth History based on backup size		DB--Database Growth History based on backup size
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--FileSize and LogUsage for all DBs--New		DB--FileSize and LogUsage for all DBs--New
DB--HealthCheck--Database details for Daily checks		DB--HealthCheck--Database details for Daily checks
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--Track database growth Report		DB--Track database growth Report
DB--Transaction Log VLF Alarm		DB--Transaction Log VLF Alarm
DB--View Autogrowth on a daily basis		DB--View Autogrowth on a daily basis

Olumoses/SQLDBAInventory

Folders and files

Latest commit

History

About

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages