Posts

Testing In Blazor

Testing In Blazor Component Testing with bUnit     Use bUnit , a dedicated, open-source testing library built specifically for Blazor components. bUnit renders your components in an in-memory, headless environment using C#. It is  incredibly fast (executing in milliseconds) and integrates natively with standard C# test  runners like xUnit , NUnit , or MSTest. Key Features of bUnit: No Browser Needed: It creates a virtualized Blazor architecture directly in memory. Dependency Injection (DI) Mocking: You can inject mock data stores or mock HTTP clients straight into the component context. Semantic HTML Verification: It compares HTML outputs structurally, ignoring irrelevant formatting quirks like whitespace variations or attribute ordering. End-to-End (E2E) Testing with Playwright Why Playwright Beats Selenium and Cypress for Blazor: SignalR WebSocket Resilience: Blazor Server apps rely heavily on a constant, streaming WebSocket connection. Playwright handles ...

Best Additions to MSSQL

Best Additions to MSSQL (since 2005) 1. High Availability & Disaster Recovery Always On Availability Groups (2012) : Replaced database mirroring, allowing admins to group multiple DBs and fail them over together to multiple readable secondary replicas.    Contained Databases (2012) : Logins are contained in the DB. The old way was a Master system DB with Logins and a specific DB with its Users, you lose the Logins that go with the Users. This broke on backup and restores of the DB from DEV to QA or to PROD.   Link for Azure SQL Managed Instance (2022) : Introduced near real-time, bi-directional disaster recovery linking on-premises servers directly to the Azure cloud. 2. Quantum Leaps in Performance Columnstore Indexes (2012 / 2016) : Built highly compressed, column-based data storage natively tailored for data warehousing, accelerating analytical query speeds by 10x to 100x. In-Memory OLTP / "Hekaton" (2014) : Added memory-optimized tables and natively...