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.
Explore SQL Server's CONCAT and CONCAT_WS functions for concatenating column values with delimiters, handling NULLs, and simplifying string aggregation.
An expert's guide to scaling SQL Server performance, focusing on reducing database calls and improving application design.
Many real-time data projects fail not because of the technology, but because of design assumptions and unnecessary complexity. One of the most common
Opinion piece criticizing overly restrictive IT censorship that blocks developers from doing their jobs, urging companies to treat staff as adults.
Real-time fraud detection using Fabric RTI: streaming pipelines, KQL anomaly detection, Power BI dashboards, and automated actions.
Learn to build a real-time IoT telemetry dashboard using Microsoft Fabric, Eventstream, KQL, Power BI, and Activator for proactive maintenance.
Monitoring brand reputation has become a continuous challenge in the age of social media. Platforms like X, Facebook, and Reddit can amplify sentiment
I’ve never liked how the LEN function works in T-SQL for SQL Server. To test out what others thought, I recently posted a short quiz on my social netw
