-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSCRIPT_TEMPLATE.sql
More file actions
28 lines (26 loc) · 1.24 KB
/
Copy pathSCRIPT_TEMPLATE.sql
File metadata and controls
28 lines (26 loc) · 1.24 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
/*******************************************************************************
Script Name: descriptive_script_name.sql
Purpose: Describes the single DBA question answered by this script.
Scope: Current database or SQL Server instance
SQL Server: 2016+
Azure SQL: State supported platforms and limitations
Permissions: State the least privileges required
Risk: Read-only; state expected query cost and generated-SQL risk
Output: Priority, Category, Object, Finding, Evidence, Recommendation, SuggestedSql, Risk
Author: TheMax-Lab
Version: 1.0
License: MIT
*******************************************************************************/
/*
Declare configurable thresholds here. Keep diagnostics read-only by default.
Return corrective commands as text and never execute them automatically.
*/
SELECT
'Low' AS [Priority],
'Category' AS [Category],
QUOTENAME(DB_NAME()) AS [Object],
'Finding supported by evidence' AS [Finding],
'Relevant measurable evidence' AS [Evidence],
'Conservative next step requiring validation' AS [Recommendation],
'-- Reviewable SQL or investigation command; do not execute blindly.' AS [SuggestedSql],
'Low: read-only diagnostic; describe the risk of any suggested change.' AS [Risk];