main

BranchesTags

Go to file

Code

Open more actions menu

Latest commit

 

History

103 Commits

103 Commits

Folders and files

Name		Name	Last commit message	Last commit date
DB name		DB name
Drop logins		Drop logins
AG_Check_Cluster_Replicas		AG_Check_Cluster_Replicas
Change Tracking		Change Tracking
ChangeAuditlevel.sql		ChangeAuditlevel.sql
Check Fill Factor		Check Fill Factor
Check Index Frag % on all Tables in a DB		Check Index Frag % on all Tables in a DB
Check SQL server agent status		Check SQL server agent status
Check Status of running backup		Check Status of running backup
Check blocking like whoisactive		Check blocking like whoisactive
Check integrity of UserDB's		Check integrity of UserDB's
Check logfile size of DB		Check logfile size of DB
Check_for_Database_Encryption_sql		Check_for_Database_Encryption_sql
CommandExecute.sql		CommandExecute.sql
CommandExecute_sql		CommandExecute_sql
CommandLog - SCL		CommandLog - SCL
CommandLog_sql		CommandLog_sql
Create DBA database		Create DBA database
Create a ServiceNow Login for monitoring		Create a ServiceNow Login for monitoring
Create logins-Users-Assign roles		Create logins-Users-Assign roles
CreateDB_DBA		CreateDB_DBA
DBIntegrityCheck-SCL		DBIntegrityCheck-SCL
DBMail Troubleshoot failure		DBMail Troubleshoot failure
DBMail create from scratch		DBMail create from scratch
DB_MaintenanceSolution_OlaHallengren_sql		DB_MaintenanceSolution_OlaHallengren_sql
DatabaseBackup_sql		DatabaseBackup_sql
DatabaseIntegrityCheck_sql		DatabaseIntegrityCheck_sql
EnableAllSQLServerDefaultAlerts		EnableAllSQLServerDefaultAlerts
File Factor		File Factor
Find large tables - Estimate DB size		Find large tables - Estimate DB size
Fix Users login mapping		Fix Users login mapping
Get DB encryption status		Get DB encryption status
Index Fragmentation %		Index Fragmentation %
IndexOptimize-SCL		IndexOptimize-SCL
IndexOptimize_sql		IndexOptimize_sql
List Indexes and their sizes on DB		List Indexes and their sizes on DB
List TDE encrypted DB in server		List TDE encrypted DB in server
List active processes		List active processes
List all SQL agent jobs		List all SQL agent jobs
List all triggers in the database		List all triggers in the database
LogShipping DR		LogShipping DR
Monitor Backup - Restore operation		Monitor Backup - Restore operation
Monitor Running queries and execution details		Monitor Running queries and execution details
Move Database Files		Move Database Files
OlaHallengrenMaintenanceSolution		OlaHallengrenMaintenanceSolution
Payroll		Payroll
PowerShell - GetClusterResource Owner List		PowerShell - GetClusterResource Owner List
PowerShell - Patching steps		PowerShell - Patching steps
PowerShell_Check_Pending_Reboot_Status		PowerShell_Check_Pending_Reboot_Status
PowerShell_GetPossibleResourceOwnerList		PowerShell_GetPossibleResourceOwnerList
PowerShell_ServerPatching-Server_Reboots		PowerShell_ServerPatching-Server_Reboots
Reseed DB_AG		Reseed DB_AG
SP_Configure_16GB		SP_Configure_16GB
SP_Configure_18GB		SP_Configure_18GB
SP_Configure_32GB		SP_Configure_32GB
SP_Configure_64GB		SP_Configure_64GB
SP_Configure_8GB		SP_Configure_8GB
SP_HelpSSRS_Report		SP_HelpSSRS_Report
SQL HA Heartbeat		SQL HA Heartbeat
SQLServerAlerts_for_AG_SS2012		SQLServerAlerts_for_AG_SS2012
SQLServerPatching_v2		SQLServerPatching_v2
Script and Apply source login role + Permissions to Target login		Script and Apply source login role + Permissions to Target login
Script out logins b4 migration		Script out logins b4 migration
Script out logins before refresh		Script out logins before refresh
Script to list SQL server Authenticated logins		Script to list SQL server Authenticated logins
Script to show ALwaysON dashboard		Script to show ALwaysON dashboard
Server Scoped DMV's		Server Scoped DMV's
Server info + Svc acct details		Server info + Svc acct details
Setup DBMail (First time)		Setup DBMail (First time)
Setup LogShipping		Setup LogShipping
Setup Replication		Setup Replication
Setup_DBMail_Firsttime		Setup_DBMail_Firsttime
Sp_configure - 32GB		Sp_configure - 32GB
SystemDB Maintenance Plan		SystemDB Maintenance Plan
SystemDB_Maintenance_Plan		SystemDB_Maintenance_Plan
TSQL to check SQL jobs running during outage window		TSQL to check SQL jobs running during outage window
TSQL to retrieve SQL Server Product key		TSQL to retrieve SQL Server Product key
Take Copy Only backups		Take Copy Only backups
Take-Restore TLOG backup		Take-Restore TLOG backup
TempDB sizing		TempDB sizing
Troubleshoot LogShipping -LSAlert failure		Troubleshoot LogShipping -LSAlert failure
Tsql to find jobs owned by a particular login		Tsql to find jobs owned by a particular login
Tsql to list SQL agent jobs that update data in the DB		Tsql to list SQL agent jobs that update data in the DB
Tsql to retrieve triggers in a DB		Tsql to retrieve triggers in a DB
Tsql to script out DB owners on an instance		Tsql to script out DB owners on an instance
Tsql to script out server-level roles & db user roles + perms		Tsql to script out server-level roles & db user roles + perms
Tsql to view tables tracked by CDC		Tsql to view tables tracked by CDC
UserDB_MaintenancePlan1		UserDB_MaintenancePlan1
UserDB_MaintenancePlan2		UserDB_MaintenancePlan2
UserDB_Maintenance_Plan_v1		UserDB_Maintenance_Plan_v1
UserDB_Maintenance_Plan_v2		UserDB_Maintenance_Plan_v2
VLF management script		VLF management script
azure Create-Alter User statements		azure Create-Alter User statements
gMSA		gMSA
retrieve server details		retrieve server details
sp_configure - 64GB		sp_configure - 64GB
sp_configure 16GB		sp_configure 16GB
sp_configure 18GB		sp_configure 18GB
sp_help_revlogin		sp_help_revlogin
View all files

About

No description, website, or topics provided.

Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks

Report repository

Releases

Packages

Contributors

Languages