Froid vs Freud: Scalar T-SQL UDF Inlining
Explains SQL Server 2019's Froid feature for inlining Scalar T-SQL UDFs to improve performance, with caveats and function type context.
Explains SQL Server 2019's Froid feature for inlining Scalar T-SQL UDFs to improve performance, with caveats and function type context.
Explains how to correctly use Dapper's IN clause with collection parameters to avoid SQL syntax errors from double parentheses.
Explains Azure AD Service Principals, their relationship to application objects, and how to create them for automation and permissions.
A technical guide on extending the R survey package to support instrumental variable regression (ivreg) with complex survey data.
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 statistical re-analysis of a published study on the mouse microbiome and autism, examining data and p-values from behavioral experiments.
An ARM template to enable the Container Monitoring Solution on an existing Azure Log Analytics Workspace.
A product manager shares practical tips for using email more effectively to communicate, collaborate, and get better engagement in a tech work environment.
Explains how to expose multiple services through a single Azure Application Gateway Ingress in AKS using path-based routing and annotations.
A technical guide on creating a Persistent Volume in Azure Kubernetes Service (AKS) using an existing Azure Storage Account, including YAML templates.
A technical guide on configuring the default audio card in Linux, addressing common issues like card numbering and multi-source playback.
A guide to creating cross-platform debugger extensions using ClrMDExports for both WinDbg and LLDB, enabling .NET debugging on Linux.
A developer's personal account of learning and troubleshooting Azure DevOps Release Pipelines, focusing on configuration and deployment strategies.
Using R and the yacas library to solve a microeconomics optimization problem: finding the optimal consumption of pizza and yogurt given a budget and utility function.
A guide for college students on the benefits and application process for Google Summer of Code (GSoC), an open-source software development program.
A developer shares solutions and analysis for three LeetCode problems: Flipping an Image, Leaf-Similar Trees, and Maximum Depth of N-ary Tree.
Analyzes the evolution of hybrid cloud strategies, contrasting traditional application bursting with modern, consistent deployment models for legacy systems.
A tutorial on using Swift 5's new StringInterpolation to create NSAttributedStrings with a clean, expressive syntax for styling text and embedding images.
A developer's personal journey to improve workspace ergonomics by switching to a more comfortable mouse and a split keyboard to alleviate neck and shoulder pain.