SQLServer

Scripts that can be run on SQL Server 2008 and up that are part of the CIS controls for a security audit

July 2020

now includes scripts that must be run before implementing TDE which is a recommendation of the CIS checklist

Name		Name	Last commit message	Last commit date
Combined Scripts		Combined Scripts
DatabaseScripts		DatabaseScripts
OSScripts		OSScripts
TDE		TDE
CIS-Controls-7-1-Mapping-to-Implementation-Groups.xlsx		CIS-Controls-7-1-Mapping-to-Implementation-Groups.xlsx
CIS-Controls-Version-7-1.pdf		CIS-Controls-Version-7-1.pdf
CISQueries.sql		CISQueries.sql
CISQueriesByVersion.txt		CISQueriesByVersion.txt
CISQueriesV2.sql		CISQueriesV2.sql
CIS_Microsoft_SQL_Server_2008_R2_Benchmark_v1.5.0.pdf		CIS_Microsoft_SQL_Server_2008_R2_Benchmark_v1.5.0.pdf
CIS_Microsoft_SQL_Server_2016_Benchmark_v1.0.0.pdf		CIS_Microsoft_SQL_Server_2016_Benchmark_v1.0.0.pdf
Combined Discovery Scripts		Combined Discovery Scripts
Login_Trigger.sql		Login_Trigger.sql
README.md		README.md
SQL Server 2008 Security Request.pdf		SQL Server 2008 Security Request.pdf
SQL Server Security Checklist.pdf		SQL Server Security Checklist.pdf