Microsoft SQL Server Error 18456
In a properly managed environment, the security team usually tracks the server logs for any…
0 Comments
File Access Control
System Engineers must follow the security principle of authentication, authorization, and accounting (AAA) as the…
0 Comments
MS SQL: Admin_Report_Notification
/* Admin_Report_Notification */DECLARE @tab char(1) SET @tab = CHAR(9)EXEC msdb.dbo.sp_send_dbmail@profile_name = 'Report DBMail Profile',@recipients =…
0 Comments
MS SQL: Archive and Shrink Database
--Archive Database: with maximum allowed runtime and a set number of recordsdeclare @EndDate datetime, @Recs…
0 Comments
Cisco Fabric Switch – MDS Zoning Template
<# What this script does: 1. Checks to see if an Internet connection via PowerShell…
0 Comments
PowerShell: Microsoft SQL Administration
Script to Install Microsoft Clustering Service $proxy="http://proxy:8080"$exclusionList="localhost;*.kimconnect.com"function checkProxy{try{$connectionTest=iwr download.microsoft.com#$connectionSucceeds=Test-NetConnection -Computername download.microsoft.com -Port 443 -InformationLevel Quietif…
0 Comments