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.
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
Many real-time data projects fail not because of the technology, but because of design assumptions and unnecessary complexity. One of the most common
There’s a UK game show that I like to watch. It’s called Lingo and it’s the standard word game turned into a full TV show. It’s based on a US game sho
Many database developers (and other developers) seem to regard the endless use of abbreviations as some badge of honor. Don’t be one of these people.
