Posts

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...

UI Automation Problems with Blazor

UI Automation Problems  with Blazor 1. The Shadow DOM and Custom Web Components Some Blazor libraries wrap standard JavaScript or fast web components (such as components utilizing the Microsoft Fluent Design System ). These components frequently isolate their inner elements inside a Shadow DOM . Standard UI test locators cannot pierce this shadow root without specialized configuration, rendering the internal buttons, inputs, or text invisible to naive test scripts.  2. Canvas-Based Rendering Highly complex UI controls—such as 3D charts, advanced data visualization heatmaps, data grids, or digital signatures (found in suites like Syncfusion Blazor or Infragistics Ignite UI)—often skip standard HTML element trees entirely. They render directly into an HTML5 <canvas> element. Because the canvas is just a flat matrix of pixels to a browser, standard automation tools cannot find specific text blocks or button elements inside it, forcing you to rely on fragile coordinate-base...

World of Postgres DB

World of Postgres DB    Postgres is an OLTP (Online Transactional Processing) powerhouse. It is optimized for rapidly writing, updating, and fetching single rows (e.g., a user profile, a single order, a financial transaction). To do this efficiently, it stores data sequentially by row on disk. Postgres uses highly compliant Standard ANSI SQL for its commands.  Postgres is free and open-source database that usually runs in a Cloud-native, Linux, Unix, Kubernetes environment.    Postgres appends new row versions directly to the data pages. Old row versions remain until an automated " VACUUM"  process purges them. So high-write DBs can have "table bloat" if not tuned properly.     Postgres is probably the most extensible DB in existence. You can write custom procedures in Python, JavaScript, or C#. It offers powerful native geospatial data via PostGIS and handles modern AI workflows cleanly with the vector similarity engine pgvector. ...