Showing posts with the label 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

Real-Time Data Stream Processing In Azure Part: 1

There are multiple ways to do real time analytics on Azure, depends on source type and the analytics which we want to perform. This article will introduce the major services in Azure which are involved for real time data solution and at the end will compare all to kno…

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

Benchmarking of Relational DB

To show benchmarking, below General Purpose mysql RDS created SHOW VARIABLES  LIKE   "%version%" ;

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