Explores a fast algorithm for estimating principal components via subsampling, analyzing its application to genetics and statistical tests.
A hands-on workshop from AWS re:Invent 2018 on using PowerShell to automate AWS infrastructure, featuring practical challenges.
Explores SQL Server 2019's improved DBCC CLONEDATABASE command for automatically extracting Columnstore Index statistics into a cloned database.
A talk exploring strategies for implementing rate limiting and request throttling in web applications to handle user traffic and prevent abuse.
A technical guide on setting up a self-hosted video livestream using ffmpeg, DASH, and nginx, bypassing services like Twitch.
Announcing two full-day SQL Server workshops at SQLSaturday Lisbon 2018, featuring Query Store troubleshooting and performance tuning.
A critique of speakers who cancel free tech events, arguing they disrespect attendees' time and organizers' resources despite no ticket revenue.
Explains the Terraform keys() function, which extracts and sorts keys from a map, with practical examples.
Explains the Terraform length() function for counting characters, list items, and map entries in infrastructure code.
Announcing four in-depth tech workshops on SQL Server, Git/GitHub, Cassandra, and Microsoft Azure at the Tuga IT 2018 Summer Edition conference.
Explains the Terraform cidrhost() function for calculating specific IP addresses within a CIDR range, including examples and use cases.
A developer troubleshoots and solves a Windows 10/Office 2016 issue where PowerPoint and Word fail to open by identifying and removing problematic registry keys.
Presentation slides for a Power BI tips and tricks talk at DataBISummit, available for download.
A tech worker shares a costly lesson about US tax compliance for foreign assets, relevant for expatriates with equity or accounts abroad.
A guide on conducting effective post-incident retrospectives for software teams, focusing on process and improvement.
Explores statistical estimation for complex samples, focusing on design-weighted U-statistics and their Hoeffding projections for pair-based analyses.
Explores using C# operator overloading to create cleaner syntax for cross-platform file path concatenation, inspired by ReSharper's code.
Sway developer explains why future versions will drop Nvidia proprietary driver support, criticizing Nvidia's lack of open standards support.
Overview of Azure Data Factory V2 Preview's new features, including SSIS package execution, Integration Runtimes, and enhanced orchestration capabilities.
How to use Visual Studio's debugger to step into and debug .NET library code while running it from a LINQPad script.
