GitHub - spendem/SQL-DBA-SCRIPTS

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
##040.Set model FileGrowth 256MB.sql		##040.Set model FileGrowth 256MB.sql
##070.sp__DBAdmin_Startup.sql		##070.sp__DBAdmin_Startup.sql
010.Job.msdb DB Backup History Cleanup.sql		010.Job.msdb DB Backup History Cleanup.sql
010.add_database_mail_acct.sql		010.add_database_mail_acct.sql
010.fn_ConvertSecsToFormattedTime.sql		010.fn_ConvertSecsToFormattedTime.sql
010.pr_RebuildIndexes.sql		010.pr_RebuildIndexes.sql
010.tbl CHECKDB_Parms.sql		010.tbl CHECKDB_Parms.sql
020.Alert.Add trans log backup as response.sql		020.Alert.Add trans log backup as response.sql
020.Job.Reindexing.sql		020.Job.Reindexing.sql
020.add_operator.sql		020.add_operator.sql
020.fn_DatabaseDetails.sql		020.fn_DatabaseDetails.sql
020.tbl CHECKDB_Schedule.sql		020.tbl CHECKDB_Schedule.sql
030.add_alerts.sql		030.add_alerts.sql
030.fn_CheckDB_ScheduleDay.sql		030.fn_CheckDB_ScheduleDay.sql
030.pr_SetCmdShell.sql		030.pr_SetCmdShell.sql
035.add_mirror_alerts.sql		035.add_mirror_alerts.sql
040.pr_ExecSQLCmd.sql		040.pr_ExecSQLCmd.sql
040.pr_Set_CheckDB_Schedule.sql		040.pr_Set_CheckDB_Schedule.sql
050.Add SysAdmin Users.sql		050.Add SysAdmin Users.sql
050.pr_CheckDB_Processing.sql		050.pr_CheckDB_Processing.sql
050.pr_DeleteFiles.sql		050.pr_DeleteFiles.sql
060.Enable SQL Agent Mail Profile.sql		060.Enable SQL Agent Mail Profile.sql
060.Job.DBAdmin CHECKDB Processing.sql		060.Job.DBAdmin CHECKDB Processing.sql
080.Job.DBAdmin Failure Test.sql		080.Job.DBAdmin Failure Test.sql
090.sp_getRunningJobs.sql		090.sp_getRunningJobs.sql
1 Create AuditLog Table for DDL.sql		1 Create AuditLog Table for DDL.sql
1 Disable Jobs.sql		1 Disable Jobs.sql
2 Create Server DDL Audit Trigger.sql		2 Create Server DDL Audit Trigger.sql
2 Stop Running Jobs and Log the Step executing.sql		2 Stop Running Jobs and Log the Step executing.sql
20170228-sp_sqlskills_exposecolsinindexlevels.sql		20170228-sp_sqlskills_exposecolsinindexlevels.sql
20170228-sp_sqlskills_helpindex.sql		20170228-sp_sqlskills_helpindex.sql
3 Create Database DDL Audit Trigger.sql		3 Create Database DDL Audit Trigger.sql
3 Start Jobs at the step where they were stopped.sql		3 Start Jobs at the step where they were stopped.sql
4 Enable Jobs Which Were Disabled.sql		4 Enable Jobs Which Were Disabled.sql
AA Install SQL from Command Line.txt		AA Install SQL from Command Line.txt
AA Install SQL from Command Line2.txt		AA Install SQL from Command Line2.txt
AD Access Identification.sql		AD Access Identification.sql
ADMIN - SQL Server Service Restart Send Email.sql		ADMIN - SQL Server Service Restart Send Email.sql
ActiveXESessions_SystemHealthInfo_Ch06_ExpandingTheToolset.sql		ActiveXESessions_SystemHealthInfo_Ch06_ExpandingTheToolset.sql
Add Email Notification For Failed SQL Server Agent Jobs.sql		Add Email Notification For Failed SQL Server Agent Jobs.sql
Add Gmail as Database Mail Account.sql		Add Gmail as Database Mail Account.sql
Add Linked Server.sql		Add Linked Server.sql
Add New Tempdb Files.sql		Add New Tempdb Files.sql
Add SQL Agent Operate and Assign it to All Jobs for Failure.sql		Add SQL Agent Operate and Assign it to All Jobs for Failure.sql
Add User to Azure Database and Add Role Membership.sql		Add User to Azure Database and Add Role Membership.sql
AllDeadLockScripts_Ch08_Deadlocks.sql		AllDeadLockScripts_Ch08_Deadlocks.sql
Alter Database Logical File Names.sql		Alter Database Logical File Names.sql
Attach DB File Without Log File.sql		Attach DB File Without Log File.sql
Attach database using Create Database.sql		Attach database using Create Database.sql
Audit Login Events.sql		Audit Login Events.sql
Azure Handy T-SQL.sql		Azure Handy T-SQL.sql
Azure SQL Database Resoruce Metrics.sql		Azure SQL Database Resoruce Metrics.sql
AzureSQLdatabase_UpdateFirewallRule.sql		AzureSQLdatabase_UpdateFirewallRule.sql
AzureSQLdatabase_UpdateFirewallRule_2.sql		AzureSQLdatabase_UpdateFirewallRule_2.sql
Azure_Database_Firewall_Script.sql		Azure_Database_Firewall_Script.sql
Azure_Delete_Unattached_Managed_Disks.ps1		Azure_Delete_Unattached_Managed_Disks.ps1
Azure_Firewall_Script.sql		Azure_Firewall_Script.sql
BCP Out Sample.sql		BCP Out Sample.sql
BCP out and in dynamic statement.sql		BCP out and in dynamic statement.sql
Backup File CleanUp.sql		Backup File CleanUp.sql
Backup Tlog files Using Powershell.txt		Backup Tlog files Using Powershell.txt
Backup database.sql		Backup database.sql
BackupTDE.sql		BackupTDE.sql
Blocking.sql		Blocking.sql
Bruins_ClientDW_WhoIsActive.ps1		Bruins_ClientDW_WhoIsActive.ps1
Build Comma Seperated Column and Query.sql		Build Comma Seperated Column and Query.sql
CDCScripts_Ch10_ChangeDataCapture.sql		CDCScripts_Ch10_ChangeDataCapture.sql
CPU counts.sql		CPU counts.sql
Cached Exec Plan Query.sql		Cached Exec Plan Query.sql
Calculate Median Value.sql		Calculate Median Value.sql
CalculateAllSQLServerPerformanceCounterValues_Ch05_sys.dm_os_performance_countersHowtoReadCalculate .sql		CalculateAllSQLServerPerformanceCounterValues_Ch05_sys.dm_os_performance_countersHowtoReadCalculate .sql
CalculateCumulativeWaitTimesByWaitType_Chap03_SlowPerformance.sql		CalculateCumulativeWaitTimesByWaitType_Chap03_SlowPerformance.sql
CaptureCfgChangesUsingDefaultTrace_Ch10_DefaultTrace.sql		CaptureCfgChangesUsingDefaultTrace_Ch10_DefaultTrace.sql
Check Azure SQL DB User Role and Role Permissions.sql		Check Azure SQL DB User Role and Role Permissions.sql
Check Database Mail Configuration.sql		Check Database Mail Configuration.sql
Check Free Space And Truncate.sql		Check Free Space And Truncate.sql
Check If The Latest Backup File Exist.sql		Check If The Latest Backup File Exist.sql
Check SQL Server Replication Jobs.sql		Check SQL Server Replication Jobs.sql
CheckPoint Free Proc Cache Clean Buffers.sql		CheckPoint Free Proc Cache Clean Buffers.sql
Clean up Replication.sql		Clean up Replication.sql
Collect Index Usage Statistics.sql		Collect Index Usage Statistics.sql
Collect Job Report From SQL Servers.sql		Collect Job Report From SQL Servers.sql
Comma Seperate Mutiple Rows.sql		Comma Seperate Mutiple Rows.sql
CompareResourceWaitsVsSignalWaits_Chap03_SignalWaits.sql		CompareResourceWaitsVsSignalWaits_Chap03_SignalWaits.sql
Compress Table.sql		Compress Table.sql
Configure Database Mail.sql		Configure Database Mail.sql
Configure Distribution First Time.sql		Configure Distribution First Time.sql
Convert Int to Time Function.sql		Convert Int to Time Function.sql
Create Azure SQL Server And Azure SQL Database From Template Copy.txt		Create Azure SQL Server And Azure SQL Database From Template Copy.txt
Create Azure SQL Server And Azure SQL Database From Template.ps1		Create Azure SQL Server And Azure SQL Database From Template.ps1
Create Credential and SSIS Proxy.sql		Create Credential and SSIS Proxy.sql
Create Database Mail Account And Profile.sql		Create Database Mail Account And Profile.sql
Create Database Mail Profile and Account.sql		Create Database Mail Profile and Account.sql
Create Database With Multiple File Groups.sql		Create Database With Multiple File Groups.sql
Create Dynamic Database SnapShot Daily.sql		Create Dynamic Database SnapShot Daily.sql
Create Dynamic Database SnapShot In Minutes.sql		Create Dynamic Database SnapShot In Minutes.sql
Create Extended Event Session 24HourDataCapture.sql		Create Extended Event Session 24HourDataCapture.sql
Create Function DelimitedSplit8K For Splitting Comma Sepeprated Parameters.sql		Create Function DelimitedSplit8K For Splitting Comma Sepeprated Parameters.sql
Create Function to Parse String.sql		Create Function to Parse String.sql
Create Linked Server to Azure Database.sql		Create Linked Server to Azure Database.sql

spendem/SQL-DBA-SCRIPTS

Folders and files

Latest commit

History

About

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages