An update on the svy2lme R package for fitting linear mixed models with complex survey data, including a comparison with Stata.
A guide to using Azure Functions with Java, covering the v2 runtime, local development, and the Java worker for serverless applications.
SQL Server 2019's Master Data Services (MDS) finally replaces the Silverlight-based web interface with a modern, browser-agnostic HTML front-end.
A developer shares their experience and practical tips for successfully preparing for and passing the Certified Kubernetes Administrator (CKA) exam.
A developer shares 10 frequently violated clean code principles, covering naming, comments, duplication, and formatting.
A tutorial on using R to reproduce and analyze map projection distortions, focusing on the Web Mercator projection with reproducible code.
A guide to deploying the EFK (Elasticsearch, Fluentd, Kibana) logging stack on Azure Kubernetes Service (AKS) using a custom Helm chart.
Explains the APPROX_COUNT_DISTINCT function for faster, memory-efficient distinct counts in SQL, comparing it to exact COUNT(DISTINCT).
An introduction to flow-based deep generative models, explaining how they explicitly learn data distributions using normalizing flows, compared to GANs and VAEs.
Explores limitations of Batch Execution Mode on Rowstore Indexes in SQL Server, including heuristics and missing operators.
Using KSQL to flatten nested CDC data from Kafka for use with the JDBC Sink connector.
A developer's struggle with accessibility in modern frameworks, highlighting the conflict between new tools and inclusive web development practices.
A wish list for Veeam Backup for Microsoft Office 365 v3, requesting features like console integration and more granular OneDrive backup controls.
A tutorial on creating an animated world population cartogram from 1800 to 2100 using R, open data, and open-source geospatial libraries.
A developer explains how Go 1.11's module system solved their biggest frustration (GOPATH), leading them to appreciate Go's simplicity, concurrency, and stability.
Explores the heuristics and conditions under which SQL Server's Query Optimizer decides to use Batch Mode execution for query processing.
A developer details troubleshooting Windows Media Center on Windows 10, explaining DLL Hell and a COM-based workaround for a broken system component.
A mathematical optimization problem to find the ideal speed bump shape that minimizes vertical acceleration, using calculus of variations.
Explores SQL Server 2019's new Batch Execution Mode for Rowstore indexes, covering basics, enabling it, and analyzing performance.
Argues that method chaining should be a core language operator, analyzing its problems in JavaScript/jQuery and proposing a built-in solution.
