Use of Application Insights

Monitor Install Application Insights in your app, set up availability web tests, and: Set up a dashboard for your team room to keep an eye on load, responsiveness, and the performance of your dependencies, page loads, and AJAX calls. Discover which are the slowest and most failing requests. Watch Live Stream when you deploy a new release, to know immediately about any degradation. Detect, Diagnose When you receive an alert or discover a problem: Assess how many users are affected. Correlate failures with exceptions, dependency calls and traces. Examine profiler, snapshots, stack dumps, and trace logs. Build, Measure, Learn Measure the … Click here to continue…..

How to upload and download Media to or from MSSQL Server Database

This code shows you how to upload media files to the SQL Server Database to store it and then how to download it from the Database in your ASP.NET website using C#. First you have to create a database named “MediaDB” in your SQL Server. Then create a table named “MediaTable” in your newly created database. Now create 4 columns in “MediaTable” as given below- ID (int, not null, IsIndentity: Yes) FileName (text, allow nulls) MediaData (varbinary(MAX), allow nulls) Extension (text, allow nulls) Then save all. Now create a new Visual C# type website in your Visual Studio. Here is … Click here to continue…..

Why we use comments in C# code

Comments in coding plays a vital role when we work in a team or individual. Now we will get to know why to use comments while coding and how its help us. Now We will discuss about the benefits of comments in C# Normally, when we were were fresher in IT industry, completing the task given to us by our seniors or deeds which we used to set to do in particular day or duration. So during the phase when we were coding the steps and methods output we and God know, but after some weeks or month that codes … Click here to continue…..

Top Interviews Question and Answer

1. What is your salary expectation? A nasty question, do not give the salary number to them exactly as every company have its own structure of salary. Telling your salary number may lead to loss of the interview.  If you are fresher then instead, say something like, That’s a tough question. Can you tell me the range for this position? In most cases, the interviewer, taken off guard, will tell you. If not, say that it can depend on the details of the job. Then give a wide range.If you guys are experienced then 25% to 35% increment is ideal, … Click here to continue…..

Sql Server Interview Questions and Answers

1) SQL Server query to split the Field into 2 Column. This query the developer can use when the name consists of numeric value like Ram1, Ram2

Note – First 3 Character will be in First Column and the Last One in another Column 2) SQL Server query to returns the index of First numeric in the column

Note – The SQL Server (Transact-SQL) PATINDEX functions returns the location of a pattern in a string. The search is not case-sensitive. 3) SQL server query to remove special characters from a string value. Here all characters except 0-9, a-z … Click here to continue…..