Articles by Bhavya Singh

Learn why SQL Server parameter sniffing can cause inconsistent query performance, how to identify it with execution plans and Query Store, and which factors to investigate.

Learn how to mock external HTTP APIs in .NET integration tests with a custom HttpMessageHandler, HttpClient, and xUnit to test successful and error responses reliably.

Learn how to create and query SQL Server system-versioned temporal tables to automatically retain row history after updates and deletes.

Learn how SQL Server parameter sniffing affects cached execution plans, how to diagnose it, and how to choose fixes for inconsistent query performance.

Learn how to prevent and diagnose C# time zone bugs using DateTime, DateTimeOffset, UTC storage, TimeZoneInfo, and daylight saving time checks.

Learn how to rotate JWT signing keys in ASP.NET Core without interrupting API access by trusting old and new validation keys during the transition.

Learn how to configure and test passkey authentication in ASP.NET Core Identity using WebAuthn, including relying-party domains, registration flows, and security considerations.

Learn how to use ETags, If-Match headers, and EF Core rowversion tokens in ASP.NET Core to detect stale updates and prevent lost data changes.

Learn how to use BigQuery AI.AGG with Gemini and GoogleSQL to summarize and analyze large collections of unstructured text or supported image data.

Explore F# runtime async preview support in .NET 11 RC 2, including compiler intrinsics, AsyncHelpers.Await, and custom computation-expression builders.

Learn how the .NET 11 RC 2 MSBuild wildcard-matching optimization can reduce project evaluation overhead and how to measure its effect in large solutions.

Learn how to configure SocketsHttpHandler.InitialHttp2MaxConcurrentStreams in .NET 11 to control initial HTTP/2 request concurrency before server settings arrive.

Learn to use Python 3.15's Tachyon sampling profiler to analyze running scripts and processes, generate flame graphs, and choose between sampling and deterministic profiling.

Learn how Python 3.15's UTF-8 default affects text file and CSV handling, and when to specify encoding="utf-8" explicitly.

Explore where Python 3.15's experimental CPython JIT improves performance, including CPU-bound loops, tracing, register allocation, and workload-specific benchmark results.

Learn how Python 3.15's frozendict provides immutable mappings, how it differs from dict, and where it helps prevent unintended configuration changes.

Learn how to create and call managed Python UDFs in BigQuery SQL, including package dependencies, runtime settings, and HTML text extraction with Beautiful Soup.

Learn how Google Cloud Data Agent Kit uses MCP tools and agent skills to connect AI coding agents with BigQuery, databases, pipelines, and other cloud data services.

Explains Python 3.15's experimental CPython JIT, its tracing and optimization changes, and what published pyperformance benchmarks do and do not prove.

Learn how Python 3.15's default frame pointers improve native stack unwinding for compatible profiling tools and support performance investigations.