Purpose: Generates create object scripts from a specified database Steps: Download the attached script Update the $SourceServer, $db, $path, $IncludeTypes, $ExcludeSchemas,
Continue readingThings to read
SQL Configure Temp DB
Purpose: Configure TempDB on a SQL Server Steps: Find the number of processors available to SQL Server on the server. Download
Continue readingSQL Server: Troubleshoot Login Trigger
Purpose: To document the procedure required to remediate a loss of SQL Server access caused by a logon trigger. Background As
Continue readingSQL DDL Audit Log Trigger
— Audit Log Script USE Configuration GO –All connections to the database must be cleared first before enable broker can
Continue readingSQL Default Template for Query Window
Edit the sqlfile.sql file located in: (SSMS 2008) C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql (SSMS 2005) C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql /* Description:
Continue readingNIST updates Cybersecurity Framework
It’s a big day, NIST has released their much anticipated Cybersecurity Framework, version 1.1 is now available here: https://www.nist.gov/cyberframework Credit: N. Hanacek/NIST
Continue reading