Author Posts
Uncategorized

Wannacry – Windows Patches – Check these KBs are installed or not

Windows Vista & 2003 - KB4012598 Windows Windows 7 - KB4012212 | KB4012215 | KB4015549 | KB4019264 Windows Windows 8.1 - KB4012216 | KB4015550 | KB4019215 Windows 10 - KB4013198 | KB4015219 | KB4012606 | KB4019474 | KB4019473 | KB4013429 | KB4019472 Windows Server 2008 - KB4012598 | KB4018466 Windows Server 2008 R2 - KB4012212 | KB4012215 | KB4015549 | KB4019264 Windows Server 2012 - KB4012214 | KB4012217 | KB4015551 | KB4019216 Windows Server 2012 R2 - KB4012213 | KB4012216 | KB4015550 | KB4019215 Windows Server 2016 - KB4013429 | KB4019472 | KB4015217 | KB4015438 | KB4016635 Other Systems - KB4014511 | KB4019112 | KB4014504

Read More
Uncategorized

[Solved] IP blacklisted – Submit removal request on these RBLs and Mailing services

Office 365 ( https://sender.office.com ) Outlook (https://support.microsoft.com/en-us/supportrequestform/8ad563e3-288e-2a61-8122-3ba03d6b8d75) Gmail ( https://support.google.com/mail/contact/msgdelivery) TrendMicro ( https://ers.trendmicro.com/reputations ) MXToolBox (http://mxtoolbox.com/) SenderBase (http://www.senderbase.org ) Cloudmark ( http://csi.cloudmark.com/reset-request ) Proofpoint ( https://support.proofpoint.com/dnsbl-lookup.cgi ) Check MultiRBL for more http://multirbl.valli.org/

Read More
Uncategorized

Windows ARR – Application Request Routing – ARRv2_setup_amd64_en-us.EXE / ARRv3_0.exe

Download link -> https://www.iis.net/downloads/microsoft/application-request-routing Why need ARR -> https://forums.iis.net/t/1238284.aspx?Flush+IIS+Cache+without+recycling+the+application+pool (read very last reply) How to config and clear cache -> https://docs.microsoft.com/en-us/iis/extensions/configuring-application-request-routing-arr/browse-cached-contents-on-disk-on-application-request-routing Static cache -> https://docs.microsoft.com/en-us/iis/configuration/system.webserver/staticcontent/clientcache

Read More
Uncategorized

How to get MSSQL Top High Load / Runtime Queries

Open MSSQL and execute below code in new query. SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2)+1), qs.execution_count, qs.total_elapsed_time/1000000 total_elapsed_time_in_S, qs.last_elapsed_time/1000000 last_elapsed_time_in_S, qs.last_execution_time FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp ORDER BY qs.total_logical_reads DESC -- logical reads -- ORDER BY qs.total_logical_writes DESC -- logical writes -- ORDER BY qs.total_worker_time DESC -- CPU time

Read More