check isnull for UniqueIdentifier check table exists Check valid decimal and integer values using TSQL Checking for the existence of a SQL Agent Job Checking how long a Stored procedure has been run? Checking if xp_cmdshell is enabled or not Chinese characters issue with T-SQL. Clear tempDB d...
HKLM\System\CurrentControlSet\Services\TcpIp\Parameters\EnableICMPRedirect1. Recommended value data:02.1(enabled)//Modifying this registry value to 0 prevents the creation of expensive host routes when an ICMP redirect packet is received. 4. Protect Against SNMP Attacks HKLM\System\CurrentControlSet\Servi...
here is what you do. Let's say you want to exclude the ServerIP from this section of the e-mail. All you have to do is to knock of the lines of code which I have highlighted in bold Section A and B. Similarly, if you want to add more information you can copy paste the highlig...
/*** Author: Randeep Singh Date: Aug 2014 Purpose:Script can give DBA a SQL Instance quick quality check. Version:V1 ***/ EXEC sp_configure 'xp_cmdshell', 1 PRINT 'Ignore the line above.' RECONFIGURE PRINT CHAR(13) PRINT CHAR(13) PRINT CHAR(13) USE [DBNAME] GO SET NOCOUNT ON; ...
If this database is in FULL recovery mode and you have all the log backups, you can always recover by: 1) take a tail log backup 2) Restore from a old Full backup with NORECOVERY 3) Apply all the log backups with NOCOVERY 4) Apply the last (tail) log backup with RECOVERY David...
EXEC xp_cmdshell('cat ../../../etc/passwd')#` func init() { rules, _ := wafRules.ReadFile("waf-detect.yaml") - yaml.Unmarshal(rules, template) + err := yaml.Unmarshal(rules, template) + if err != nil { + logging.Logger.Errorln(err) + } } func Scan(target, body string...
check isnull for UniqueIdentifier check table exists Check valid decimal and integer values using TSQL Checking for the existence of a SQL Agent Job Checking how long a Stored procedure has been run? Checking if xp_cmdshell is enabled or not Chinese ...
Check if value is alphanumeric check isnull for UniqueIdentifier check table exists Check valid decimal and integer values using TSQL Checking for the existence of a SQL Agent Job Checking how long a Stored procedure has been run? Checking if xp_cmdshell is enabled or not Chinese characters issu...
check isnull for UniqueIdentifier check table exists Check valid decimal and integer values using TSQL Checking for the existence of a SQL Agent Job Checking how long a Stored procedure has been run? Checking if xp_cmdshell is enabled or not Chinese characters issue with T-SQL. Clear tempDB da...
Check if value is alphanumeric check isnull for UniqueIdentifier check table exists Check valid decimal and integer values using TSQL Checking for the existence of a SQL Agent Job Checking how long a Stored procedure has been run? Checking if xp_cmdshell is enabled or not Chinese characters issu...