Costin Manda articles - 100 total
Sparse arrays in JavaScript
Original post: https://siderite.dev/blog/sparse-arrays-in-javascript/ Intro Welcome to...
Array.from - more powerful than you think
Original post: https://siderite.dev/blog/arrayfrom---more-powerful-than-you-think/ Array.from is a...
Bypassing blocking Chrome certificate screens
Original URL: https://siderite.dev/blog/bypassing-blocking-chrome-certificate-screens Yep, it's is...
Data access in code, using repositories, even with ORMs
Intro In the .NET world one of the most used method of accessing databases is with Entity...
MockManager in unit tests - a builder pattern used for mocks
A few years ago I wrote about this, but in less detail. Here is a more refined version of the same...
Migrate data from an SQL Server table to another, without locking it
Here is the scenario: you have two tables: a source of recent data and an SQL Server destination...
SELECT INTO quirk I had no idea about
What is the structure of a table created from another via SELECT * INTO [Second] FROM [First] ? A...
Firefox and content_scripts.world
I have been maintaining a Chrome browser extension I wrote for more than a year now and I always get...
Huge SQL performance gains from using INTs
Just a few days ago I was writing on how important it is to tell Entity Framework what SQL type to...
EF Core 6 - correct types halving the execution time!
I've built an application and, like any lazy dev out there, I focused on the business logic, the...
EF Core 6 - This SqlTransaction has completed; it is no longer usable.
Intro This post is about the System.InvalidOperationException: This SqlTransaction has...
In class members which are functions, this is not defined unless you ask for it
Original post at: https://siderite.dev/blog/in-class-members-which-functions-not-defined-unles/ You...
Disabling OneDrive in Microsoft Office
Original post at: https://siderite.dev/blog/disabling-onedrive-in-microsoft-office/ Microsoft Office...
Disable CSP (headers AND meta tag) in Chromium based browsers
Original post: https://siderite.dev/blog/disable-csp-headers-and-meta-tag-in-chromium-based/ Note:...
SQL Server - Timing out because of table variables
Original post at: https://siderite.dev/blog/sql-server---timing-out-because-of-table-variables/ Some...
Better options than object and collection initializers
Original post at: https://siderite.dev/blog/better-options-than-object-and-collection-initiali C#...
Custom resolve handler in Microsoft's ServiceProvider (enabling property injection)
Original post at: https://siderite.dev/blog/custom-resolve-handler-in-microsofts-serviceprovid/ ...
XmlSerializer memory leak
Original post at: https://siderite.dev/blog/xmlserializer-memory-leak/ So I was happily minding my...
String.Join in Excel
Original post at: https://siderite.dev/blog/stringjoin-in-excel/ There is a common task in Excel...
Fast fuzzy searching of a string in a list
Original post: https://siderite.dev/blog/fast-fuzzy-searching-of-string-in-list Sift4 algorithm:...
Temporary tables better than table variables!
Original URL at: https://siderite.dev/blog/temporary-tables-better-than-table-variables Today I had...
Windows start menu search not working, search textbox not accepting input
Original post at:...
Careful with table partitioning in SQL
Original post at: https://siderite.dev/blog/careful-with-table-partitioning-in-sql I had this...
Introduction to SQL (Microsoft SQL Server)
Original post at: https://siderite.dev/blog/introduction-to-sql-microsoft-sql-server This is a very...
Careful with VIEWs with SCHEMABINDING in Microsoft SQL Server
Original URL: https://siderite.dev/blog/careful-with-views-with-schemabinding-in-microsoft I was...
Quick SQL hint: Use Application Name in connection strings
Original URL: https://siderite.dev/blog/quick-sql-hint-use-application-name-in-connection-/ When we...
Game idea: Candidate Chess
Original post at: https://siderite.dev/blog/game-idea-candidate-chess/ As always, everything that...
Unpin apps from Windows 11 Start Menu
Installing Windows 11 is a trip. Not only does it comes with its own idea on how your taskbar and...
Chess engines are optimizing for the wrong thing!
Original post at: https://siderite.dev/blog/chess-engines-optimizing-for-wrong-thing Chess is a...
READPAST your problems in SQL
Original post at: https://siderite.dev/blog/readpast-your-problems-in-sql/ Interesting SQL table...