Purpose: Configure TempDB on a SQL Server Steps: Find the number of processors available to SQL Server on the server. Download the attached […]
Latest Articles
Read the latest release articles and learn without limits.
0
SQL 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 part of […]
0
SQL DDL Audit Log Trigger
— Audit Log Script USE Configuration GO –All connections to the database must be cleared first before enable broker can complete IF(SELECT […]
0
SQL 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: Author: Date: […]
0
NIST 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