Posts

HOW TO READ MSSQL TRACE?

 GO DECLARE @tracefile VARCHAR(500) -- Get path of default trace file SELECT @tracefile = CAST(value AS VARCHAR(500)) FROM ::fn_trace_getinfo(DEFAULT) WHERE traceid = 1 AND property = 2 PRINT @tracefile -- Get security changes from the default trace SELECT * FROM ::fn_trace_gettable(@tracefile, DEFAULT) trcdata -- DEFAULT means all trace files will be read INNER JOIN sys.trace_events evt ON trcdata.EventClass = evt.trace_event_id WHERE 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 request Solution Rename controllerName Avoid advertisement actionmethod name

How do I connect to AWS ec2 SQL Server?

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

What is Aws?

Image
What is Aws? Amazon Web Services is widely used secure cloud services platform, offering computing power, content delivery, database storage, and other functionality to help businesses scale and grow. Comparison between Azure and AWS Parameters AWS Azure Launched Date Launched in 2006. Launched In 2010. Market Share 31% Share of the global computing market 11% Share from the worldwide market. Availability Zone 61 Availability Zone 140 Availability Zones Storage services S3 Buckets EBS SDB domains Easy to use SQS CloudFront AWS Import/Export Blob Storage Containers Azure Drive Table Storage Tables Storage Stats Databases Services MySQL Oracle DynamoDB MS SQL SQL Sync Deployment Services Amazon Web Services Amazon Machine Instance (AMI) Traditional Deployment Models Fine-grained updates Elastic Beanstalk Cloud Formation Cspkg (fancy zip file) Upload via portal or API via blob storage Course-grained updates "click to scale." Mo

How IIS Process ASP.NET Request

Image
Introduction When request come from client to the server a lot of operation is performed before sending response to the client. This is all about how IIS Process the request.  Here I am not going to describe the Page Life Cycle and there events, this article is all about the operation of IIS Level.  Before we start with the actual details, let’s start from the beginning so that each and everyone understand it’s details easily.  Please provide your valuable feedback and suggestion to improve this article. What is Web Server ? When we run our ASP.NET Web Application from visual studio IDE, VS Integrated ASP.NET Engine is responsible for executing all kind of asp.net requests and responses.  The process name is “ WebDev.WebServer.Exe ” which takes care of all request and response of a web application which is running from Visual Studio IDE. Now, the name “ Web Server”  comes into picture when we want to host the application on a centralized location and wanted to access from many

Cannot run when setup is in progress upon launching Visual Studio

I cleared out my %temp% folder and Visual studio launched successfully

Introduction to Agile development

Image
Agile in Software Development: Agile is one of the world’s most widely used and recognized software development framework. Most of the organizations have adopted it in some form or the other but there is still a long way to go in the maturity of their adoption programs. The sole aim of this series of tutorials is to onboard technology and non-technology professionals into the Agile World. We will take you through the agile journey in a step by step manner until you understand the philosophy behind using Agile, its advantages and how to practice it. This series aims to equip and enable the readers to apply Agile and Scrum learning into their work. This particular tutorial is dedicated to explaining to you why there was a need for Agile and how it got created. The fundamental here is to make you understand the concept of Agile Adoption in Software Development Industries. History of Agile Agile was born when on one fine day when 17 people with different development methodolo