Greg Low is a long-time Microsoft Data Platform MVP and Regional Director, sharing expert insights on SQL Server, Azure SQL, Microsoft Fabric, and real-time data architecture through practical articles and interviews.
34 articles from this blog
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.
A new course on writing SQL queries for Google BigQuery is announced, covering query writing, reporting, and analytics.
Learn how to implement governance and compliance in real-time streaming systems, covering data lineage, auditing, regulatory rules, retention, and sensitive data monitoring.
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.
