Explores SQL Server's Memory-Optimized TempDB Metadata feature, which reduces contention by moving system tables into memory, with a performance test demonstration.
A guide to writing and automating UI/integration tests for Flutter apps using Flutter Driver and running them with Codemagic CI/CD.
Explains SQL Server 2019's new support for creating database snapshots that include in-memory (Hekaton) filegroups, a previously unsupported feature.
Guide on configuring Docker and Docker Compose to access private NuGet feeds from Azure Artifacts during containerized .NET builds.
Explains the new Resumable TDE Scan feature in SQL Server 2019 and Azure SQL Database, detailing its commands and benefits for system availability.
Summary of key new features in SQL Server 2019 Standard Edition, including Transparent Data Encryption (TDE) and performance enhancements.
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
An analysis and English translation of Jacek Kaczmarski's poem 'The Statues', exploring the legacy of tyranny.
A developer shares their journey learning React, TypeScript, Gatsby, and Python while transitioning from UWP development and contributing to open-source projects.
Explains the inconsistent browser handling of image EXIF orientation and provides a Node.js solution to fix portrait images uploaded from phones.
A guide to using conditional logic and runtime variables in Azure Pipelines YAML configurations to control step execution.
The article critiques the overuse and devaluation of the titles 'Engineer' and 'Scientist' in modern IT, focusing on data science and engineering roles.
Explores the evolution of the World Wide Web from a simple 'Web of Documents' to the complex 'Web of Applications' we use today.
A developer reflects on building and shutting down feediary, a privacy-focused RSS reader, due to low conversion to paid subscriptions.
Explores the preview feature of ordered Clustered Columnstore Indexes in Azure SQL Data Warehouse, testing syntax and performance benefits.
Explains why Azure Functions with HTTP triggers are not ideal for building full web APIs and should be used for reactive, message-based logic instead.
An article challenging the '10x engineer' myth and proposing the concept of a '+10% engineer' who boosts team productivity through collaboration and support.
Explores the trade-offs between global and scoped dependency access in Flutter, focusing on testability and using Provider for state management.
A tutorial on setting up a headless interface for a Raspberry Pi 3 using a CP2102 USB to UART converter.
An introduction to Python testing using pytest, covering the basics and providing resources from a Python Frederick talk.
