Explores how improving developer experience (DX) boosts team productivity, with real-world examples like hot reloading and memory leak detection.
Learn key design principles for building reliable and resilient real-time streaming systems, including redundancy, failover, durability, and monitoring.
Compares two methods for bulk reloading SQL Server clustered columnstore indexes, recommending drop/recreate for best performance and packing.
Learn key strategies for designing scalable real-time architectures, including partitioning, hot/cold path separation, bottleneck identification, and realistic load testing.
Discussion on whether databases should use foreign key constraints, addressing common developer objections and advocating for their use.
Learn to monitor and manage Activator triggers in Fabric RTI, including viewing trigger events, editing rules, and avoiding loops.
Learn how to trigger Teams messages, emails, and workflows from Fabric Activator for real-time notifications and hybrid automation.
Review of 'The Orange Book of Machine Learning: Green Edition', a practical ML book focused on supervised learning with Python, pandas, scikit-learn, and Jupyter.
Explains how Microsoft Fabric Activator triggers Azure Logic Apps for enterprise IT workflows, comparing Logic Apps with Power Automate and highlighting DevOps support.
Explores SQL Server's auto page repair feature in database mirroring and Availability Groups, its usefulness, limitations, and underlying storage issues.
Learn how to integrate Power Automate with Microsoft Fabric Activator for real-time event-driven business automation, using no-code workflows.
A SQL Server developer criticizes poorly normalized databases with polymorphic columns like ObjectID/ObjectType, advocating for nullable specific columns instead.
Learn how Fabric Activator triggers internal and external actions after detecting conditions, turning real-time analytics into operational responses.
Learn how to design SQL databases to minimize damage during intrusions by using schemas, views, and least-privilege user permissions.
Learn how to detect event patterns in Microsoft Fabric's Activator for real-time intelligence, using rules and KQL to identify sequences and trends.
Review of Python for Algorithmic Trading Cookbook, covering practical recipes for building algorithmic trading strategies with Python, from data to deployment.
Learn how to handle backpressure in real-time data systems with strategies like buffering, scaling, and prioritization.
Troubleshooting SQL Server error 'Failed to update the database because the database is read-only', caused by availability group failover and connection to wrong server.
Learn best practices for handling retries in real-time streaming systems, including exponential backoff, idempotency, poison queues, and logging.
