Everybody wants to know about index fragmentation It is an inescapable vortex of malaise and confusion. Like that swamp in The Neverending Story that killed the horse. Sorry if you haven’t seen that movie. The horse wasn’t that cool, any...
Saved by: Huy Vũ
One of the most overlooked aspects when building APIs is how they communicate errors. A well-designed API informs consumers effectively when something goes wrong. Consistent error responses are not just a best practice but a necessity. T...
Saved by: Huy Vũ
In my previous post A Step by Step Guide to Bundling and Minification in ASP.NET Core, I gave you an overview of the different tools and strategies we can use to implement bundling and minification in ASP.NET Core. I also covered the Vis...
Saved by: Huy Vũ
ASP.NET Core introduced many new concepts, which developers need to learn to develop modern web-based applications. One of the concepts is “Middleware” which allows developers to run a series of components (aka Middleware) during a web r...
Saved by: Huy Vũ
The short description of SQL Server unused indexes which covers the reasons why they affect a database execution plan and how they could be found with the help of the sys.dm_db_index_usage_stats system view. It also provides us with a wa...
Saved by: Huy Vũ
4700 times faster than SQLite and achieves zero allocation per query. Also the DB size is small. When SQLite is 3560kb then MasterMemory is only 222kb. Source Generator automatically generates a typed database structure from schemas (cla...
Saved by: Huy Vũ
