Sarang Jahagirdar

I am Saran Jagirdar. I have 23 years of IT experience. I have earlier experience in.NET and 9 years of experience in SQL Server. I have experience in AWS and Docker for 1 year. And I'm currently working for Vivo Technology for the last 14 years. So that's about me. I have 3 years of on-site experience in the USA for client Microsoft. I'm basically a Microsoft.NET developer, and I have experience in ASP.NET Core, ASP.NET MVC, ASP.NET, Web API, SQL Server, AWS, and Docker.

If query is complex, then I will first see if I can simplify it using CT or temporary table or a table variable. And, I will also see that indexes are properly utilizing in the where clause and join clause and group by clause. And I will check, only those columns which are required are taken and not select star columns are taken. So these are the few things I will look into. I will also see that if it is a stored procedure, then set nocount on is placed at the top of the statement. And, the cursors are not used that also. I will check. So this way, I will check how to optimize slow performing queries.

Blazor gives a single-page application without using Angular and other things. That is the advantage of Blazor. So you can write C# instead of JavaScript or client-side scripting, and it automatically converts it into JavaScript. That is the benefit of Blazor, and that is why we use Blazor. So, a programmer does not need to be experienced in JavaScript development. He can use his family language, C#. That is the advantage of Blazor.

So if we have to use a CICD pipeline using AWS services, I'm not very sure because I have not used a CICD pipeline for AWS. I use CICD for on-premise servers. So for AWS servers, it should be similar and it requires three stages and the same three stages, but instead of one PM I server, we have to give an ADS server that will be used for deployment. So that's what we will use with AWS and a CodePipeline.

So to monitor the target application on AWS, I will use a performance log or log format, like an application to log every important method and that will log the time it takes to call a particular method. So that's it, basically. And I will also see that the target application is using caching and other things, like that, before running the performance monitor on it. And, yeah, that is the basic thing I will do for the performance monitor of the AWS application.

So to join multiple tables, I will ensure that those tables have indexes on the join clause because that will run the application faster. And if it is complex, I will try to use CTE or a temporary table. I will see that only the required columns are taken and not select star columns. And I will see if isolation level is not too high, then I can use no lock on table so that will make it faster. So these are the things I will look for to run the query efficiently and with maximum speed.

To make it thread safe, I can put lock on instance, and that way, I will make it thread safe because without that, it is very difficult to make a thread safe instance. So you see, after the get, I will put a log statement, log instance, lock in bracket instance, and give a curly bracket and close it, at the before the end of get statement. And, I will say that if instance is equal to null, then instance is equal to new singleton and return instance. So that way, I will make it thread safe.

So we have to declare post ID as an integer and set the value of ID so that we can execute this true statement. And I think that is the only way we can make this statement wrong, and another thing is required.

I'm not sure about that. I haven't faced any problems. Your Docker configuration has minimized latency and other issues. So I'm not sure on this question. I'll like to skip these questions, and I'm unsure about this one.

So, basically, to migrate to Blazor based on the application from on-premise to AWS cloud, the things we had to do is, basically, we had to run a laser assembly on AWS cloud in.NET Core, and that is the major thing we should do. I'm not very sure about the answer because I haven't written a Blazor application.

I will do services with nothing but as your community service means, but nothing but the ability to speak in English and communicate using English. So we can integrate Azure community service by putting the URL and making it read the application. So that way we can integrate Azure Community Service into blazer.data.