Showing posts with the label Azure SQLShow All

Real-Time Data Stream Processing In Azure Part: 2

This article is extend of my previous post “ Real-Time Data Stream Processing in Azure Part: 1 ” on real time analytics. Before I start the core for which you started reading this blog, lets quickly review few basic concepts for Stream Analytics.

Read more

Lambda vs Delta Architecture - Realtime Analytics on Delta Lake

Before I start details for Delta Architecture lets recap Lambda Architecture first, then you will be able to appreciate the beauty of delta Architecture. Lambda architecture is a popular technique where records are processed by a batch system and streaming system…

Read more

Azure Synapse Architecture

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics.  It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources—at scale. SQL Analytics u…

Read more

How to Secure Azure Analysis Services and Azure Synapse?

Azure Analysis Services is a fully managed platform as a service (PaaS) that provides enterprise-grade data models in the cloud. Use advanced mashup and modeling features to combine data from multiple data sources, define metrics, and secure your data in a single, tru…

Read more

How to implement Row-Level Security in Azure SQL Database or SQL Server

Some one of you prefer view-based workarounds for row-level filtering. The benefits of using Row-Level Security (RLS) instead of views include: RLS reduces code complexity by centralizing access logic in a security policy and eliminating the need for an ex…

Read more

DBMS - Concurrency Control

A transaction is a collection of instructions. To maintain the integrity of a database, all transactions must obey ACID properties.  ACID  is an acronym for below Atomicity   − this property states that a transaction must be treated as an atomic unit, that is, …

Read more