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.
Explores surprising SQL Server behavior where TRY_CAST and TRY_CONVERT return non-NULL values for empty strings when casting to certain types, with a type-by-type analysis.
Learn how to design fault-tolerant real-time data pipelines using checkpoints, partition replicas, stateless consumers, and failure testing.
A detailed review of 'Causal Inference with Bayesian Networks', covering its content, practical examples, and suitability for data scientists.
Explains replay and reprocessing in Microsoft Fabric RTI, covering event persistence, Delta Lake time travel, and use cases like debugging and audits.
An opinion piece on why IT teams should avoid hiring clones of themselves, emphasizing the value of diverse backgrounds and perspectives in tech and development.
Security and governance are just as important in real-time streaming systems as they are in traditional batch pipelines — and in some cases, even more
Using SQL Server database snapshots to provide large unit testing data with quick restores, avoiding transaction rollback limitations.
Learn how to implement governance and compliance in real-time streaming systems, covering data lineage, auditing, regulatory rules, retention, and sensitive data monitoring.
Explore cost considerations for streaming vs batch in Microsoft Fabric RTI, including compute, retention, and hybrid pipeline strategies.
An analysis of flat adverbs (e.g., 'drive safe') and the debate over the 'ly' suffix in modern English usage.
Learn how to optimize cost and performance in Microsoft Fabric RTI by selective streaming, pre-aggregation, sampling, and logical data tiering.
