SQL Server 2022 Performance - Buffer Pool Scan 

Considering the significant performance improvements and the elimination of buffer pool scan issues in SQL Server 2022, upgrading your SQL Server environment to this latest version is highly recommended. 

1. .NET has better Performance 
2. Node.js requires to mix & match languages to compensate for performance 
3. C# is an amazing language 
4. Best tooling available 
5. Easier built-in development loop 
6. Stable ecosystem 
7. Compliance, privacy, and security 

Can database-style sharding improve the performance of a multi-threaded C# application? This tutorial talks about the performance bottlenecks in sophisticated C# concurrency operations and how sharding can solve these issues.  

Performance counters are really important for monitoring and troubleshooting problems with your .NET applications. The full .NET Framework provides a wide array of performance counters that are very useful for troubleshooting application problems. 

Damian Edwards talks about types of performance, startup time considerations, throughput, latency / response time, scale and memory overhead. He then digs into the benchmarking work the team has been doing, showing some live demos running in the team's performance lab. 

 Cannot open database "DecisionDB" requested by the login. The login failed.
Login failed for user 'xxxxx'.
Description:  An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Line 172:
Line 173: foreach (var role in from record in standardRoles
Line 174: let role = this.FindByName(record.RoleName)
Line 175: where role == null
Line 176: select new Role

Source File:  C:\Users\Majid\Desktop\Decision-master\src\Decision.ServiceLayer\EFServiecs\Users\ApplicationRoleManager.cs   Line:  174

 <add name="DefaultConnection" connectionString="Data Source=.;Initial Catalog=DecisionDB;Integrated Security = true" providerName="System.Data.SqlClient"/>

Build Accelerator, BuildXL for short, is a build engine originally developed for large internal teams at Microsoft, and owned by the Tools for Software Engineers team, part of the Microsoft One Engineering System internal engineering group. Internally at Microsoft, BuildXL runs 30,000+ builds per day on monorepo codebases up to a half-terabyte in size with a half-million process executions per build, using distribution to thousands of datacenter machines and petabytes of source code, package, and build output caching. Thousands of developers use BuildXL on their desktops for faster builds even on mega-sized codebases. 

This post shows how to import and export .xls or .xlsx (Excel files) in ASP.NET Core. And when thinking about dealing with excel with .NET, we always look for third-party libraries or component. And one of the most popular .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx) is EPPlus. However, at the time of writing this post, this library is not updated to support .NET Core. But there exists an unofficial version of this library EPPlus.Core which can do the job of import and export xlsx in ASP.NET Core. This works on Windows, Linux and Mac. 

Validot's performance explained 

Data Structures Performance Comparison