A collection of lesser-known but powerful PostgreSQL features and tips shared by the developer community, from data types to performance tricks.
Explains how oversized VARCHAR columns in SQL Server can negatively impact query performance by inflating memory grant requests.
A technical article discussing debugging tricks for complex statistical models with symmetries, focusing on verification and small-sample testing.
A developer shares practical recommendations and lessons learned from using Terraform to provision Azure PaaS services, based on real-world experience.
A .NET developer's 2017 blog retrospective, analyzing traffic stats, top posts about CLR internals, and the impact of Hacker News.
Explores the R-CNN family of models for object detection, covering R-CNN, Fast R-CNN, Faster R-CNN, and Mask R-CNN with technical details.
An overview of the PostgreSQL community structure, including its unique license, core team, and contributor hierarchy.
Live coverage and highlights from PASS Summit 2017, focusing on Microsoft Data Platform updates, Azure services, and SQL Server.
Explains the five common forms of Clojure keywords, their use cases, and provides recommendations for idiomatic usage.
Discusses how Docker is a tool that can be misused, arguing that its problems stem from implementation, not the technology itself, and connecting it to DevOps culture.
An analysis of nine code quality tools for Clojure, evaluating their functionality and issues in a real-world project with cljc files and spec.
Guide to finalizing receipt validation in Swift by computing and comparing GUID hash using OpenSSL.
Guide to finalizing receipt validation in Swift by computing and comparing the GUID hash for your app.
A technical guide on migrating from Azure VMs to VM Scale Sets, focusing on modifying a VSTS build pipeline to create a VM image for scalable API deployment.
A plea to Clojure developers to adopt clojure.spec for data validation and instrumentation to improve code safety and readability.
Argues that Shadow IT, often seen as a risk, can be a valuable incubator for digital transformation and agile practices within organizations.
Explains how to use Azure Application Insights telemetry processors to filter, sample, and enrich server-side telemetry data before it's sent to the backend.
A GitHub engineer shares eight key lessons for new hires, focusing on shipping early, learning workflows, and adapting to the company's unique culture.
A nostalgic guide to installing a TCP/IP stack on Windows for Workgroups 3.11 to enable internet connectivity on the 1993-era OS.
Discusses operational best practices and ownership in serverless architecture, emphasizing responsibility despite outsourcing.
