Posts

Showing posts from September, 2020

HOW TO READ MSSQL TRACE?

GO
DECLARE @tracefile VARCHAR(500)-- Get path of default trace fileSELECT @tracefile = CAST(value AS VARCHAR(500))FROM ::fn_trace_getinfo(DEFAULT)WHERE traceid = 1AND property = 2
PRINT @tracefile-- Get security changes from the default traceSELECT *FROM ::fn_trace_gettable(@tracefile, DEFAULT) trcdata -- DEFAULT means all trace files will be readINNER JOIN sys.trace_events evt ON trcdata.EventClass = evt.trace_event_idWHERE trcdata.EventClass IN (102, 103, 104, 105, 106, 108, 109, 110, 111)ORDER BY trcdata.StartTime

[Solved] Failed to Load Resource 'net::ERR_BLOCKED_BY_CLIENT' Mean and How Can You Fix It?

The issue is that adblocker recognizes the word advertisement in the URL and it thinks it's an ad and blocked the requestSolutionRename controllerNameAvoid advertisement actionmethod name

How do I connect to AWS ec2 SQL Server?

Install mssql on EC2 instanceCreate user like as 'sa; if not alreadyEnable remote connection from sql server instance--> properties-->permissionIn aws security group add rule mssql port 1433In aws ec2 windows server  - window firewall defender-->Inbound rule add port 1433MSSQL configuration manager enable tcp ipRight click on tcpip--> tab IPaddress -- > set tcp port 1433 and remove default port as blankOpen SSMS -  server - ip,1433 user sa and your password to connect sql database