Updating Statistics on Secondary Replicas of the Availability Groups
A technical guide exploring workarounds to update SQL Server statistics on secondary replicas in Availability Groups, including scripts and methods.
A technical guide exploring workarounds to update SQL Server statistics on secondary replicas in Availability Groups, including scripts and methods.
Explains the relationship between Wald, score, and likelihood ratio tests in statistical modeling using visual diagrams and R code examples.
A personal account of the Stone Soup creativity camp, an experience design event focused on improvisation, workshops, and unique participant-led activities.
A talk on building a serverless reverse package search for NuGet.org using Azure Functions and Azure Search, presented at NDC Oslo.
A software developer's list of past and upcoming tech talks on open-source, Microsoft technologies, cloud, and DevOps.
A guide to designing a decoupled authentication API in Flutter using service classes to wrap FirebaseAuth and improve maintainability.
A tutorial on implementing CallKit for iOS to display native incoming/outgoing call UI and handle VoIP features in your app.
Analyzes the debate on the best location to start a tech startup, arguing the Bay Area's advantages are concentrated and not accessible to most founders.
A tutorial on unit testing an ASP.NET Core Web API controller using XUnit and FakeItEasy, covering mocking dependencies and test structure.
A statistical re-analysis of a published study on the mouse microbiome and autism, examining data and p-values from behavioral experiments.
A developer's monthly update covering open source projects like aerc email client, RISC-V musl libc port, and tools for decentralized blogging.
A guide to improving Jest test clarity by refactoring assertions and using custom error messages for better debugging.
Explains the mathematical derivation of logistic regression from Bayes' theorem, connecting fundamental statistics to machine learning.
Explains how Spring's ProxyFactory and ProxyFactoryBean abstract the complexity of creating AOP proxies, covering JDK and CGLIB proxies.
A developer's personal evolution from preferring the permissive MIT license to embracing the protective GPL license for open source software.
Covers best practices for migrating Microsoft SQL Server databases to AWS, including hybrid architecture and migration methods like AWS DMS.
A statistical analysis discussing the limitations of confidence intervals, using examples from small-area sampling to illustrate their weak properties.
Explores the trade-offs between global and scoped dependency access in Flutter, focusing on testability and using Provider for state management.
A summary of key talks from the Pixel Pioneers 2019 web development conference, covering UX, CSS animation, flexbox, and CSS Grid.
A guide to automating pull request checks and reviews using the Danger tool on CI servers like Travis CI.