Skip to content

Olumoses/SQL-Server-Administration

BranchesTags
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
Authentication & Authorization
Authentication & Authorization
 
 
Blocked Process Report ~ WMI Event
Blocked Process Report ~ WMI Event
 
 
Extended Events
Extended Events
 
 
PowerShell
PowerShell
 
 
SQL Express
SQL Express
 
 
00 Schema, Tables.sql
00 Schema, Tables.sql
 
 
01a Instance Configuration Setup.sql
01a Instance Configuration Setup.sql
 
 
01b Instanct Configuration Values.sql
01b Instanct Configuration Values.sql
 
 
02 Configure Database Mail.sql
02 Configure Database Mail.sql
 
 
03a Misc.sql
03a Misc.sql
 
 
03b Tempdb sizing.sql
03b Tempdb sizing.sql
 
 
03c Backup Encryption.sql
03c Backup Encryption.sql
 
 
04 Other Objects.sql
04 Other Objects.sql
 
 
05 Other Objects.sql
05 Other Objects.sql
 
 
06 Job Category, Schedules.sql
06 Job Category, Schedules.sql
 
 
07 Jobs.sql
07 Jobs.sql
 
 
08 Job Steps.sql
08 Job Steps.sql
 
 
10a Alerts.sql
10a Alerts.sql
 
 
10b Alert Notifications.sql
10b Alert Notifications.sql
 
 
10n Alert Notifications.sql
10n Alert Notifications.sql
 
 
11 SQL Server Agent.sql
11 SQL Server Agent.sql
 
 
13a Event Notification - Backup + Restore.sql
13a Event Notification - Backup + Restore.sql
 
 
13b Event Notification - File Auto Grow.sql
13b Event Notification - File Auto Grow.sql
 
 
13c Event Notification - Logins.sql
13c Event Notification - Logins.sql
 
 
13e Event Notification - Change DB Owner.sql
13e Event Notification - Change DB Owner.sql
 
 
13f Event Notification - DBCC commands.sql
13f Event Notification - DBCC commands.sql
 
 
13g Event Notification - Deadlock Graph.sql
13g Event Notification - Deadlock Graph.sql
 
 
13h Event Notification - Deprecation.sql
13h Event Notification - Deprecation.sql
 
 
15 Server-Scoped DDL Triggers.sql
15 Server-Scoped DDL Triggers.sql
 
 
40 DR - CREATE SCHEMA dr.sql
40 DR - CREATE SCHEMA dr.sql
 
 
42 DR - Stored Procs.sql
42 DR - Stored Procs.sql
 
 
50 Create Event Session DBA-Performance.sql
50 Create Event Session DBA-Performance.sql
 
 
55 Data Collection Setup.sql
55 Data Collection Setup.sql
 
 
56 Data Collection Tweaks.sql
56 Data Collection Tweaks.sql
 
 
57 Collection Item Tweaks.sql
57 Collection Item Tweaks.sql
 
 
README.md
README.md
 
 

Repository files navigation

SQL-Server-Management

Scripts for managing a standalone instance of SQL Server. These are compatible with SQL Server 2008 R2 and above.

About

Scripts for managing a standalone instance of SQL Server.

Resources

Readme
Activity

Stars

0 stars

Watchers

0 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages

  • TSQL 51.9%
  • PLpgSQL 36.6%
  • PLSQL 4.2%
  • SQLPL 3.3%
  • PowerShell 2.2%
  • Batchfile 1.8%