• Data - Database - Technology

    Getting started with Azure Databricks

    Introduction What is Azure Databricks? Azure Databricks is the same Apache Databricks, but a managed version by Azure. This managed service allows data scientists, developers, and analysts to create, analyse and visualize data science projects in cloud. Databricks is a user friendly, analytics platform built on top of Apache Spark. Databricks acts as an UI layer, a WYSIWYG dashboard where you can create clusters, manage notebooks, write code and analyse data without knowing the internals of the system. Apache Spark is a unified analytics engine for large scale data processing and currently it supports popular languages such as Python, Scala,…

  • Database

    SQL Server 2016 Row Level Security (RLS) Implementation

    Row Level Security Capability was introduced with 2016 version SQL Server. Same is available in Azure SQL Database also as of today. This blog will detail a novice example on how to implement. This is the planned implementation flow: About the example Prepare Sample data Create Predicate function Apply Security Policy Test Security 1. Plot For the purpose of example, we will take the case of an imaginary Super market. Let us assume there are Supervisors assigned to each department in the shop and we want each supervisor to see only items he is responsible for. RLS is applied on…

  • Technology

    Latency vs Throughput

    Latency is about how fast a request can travel from one point to another. Example: For sending 100Mb of data, the API will take one hour. Throughput is how much data can travel from one point to another in a specific time frame. Example: in one hour, this API can transmit 100Mb of data  

  • Architecture - Bookmark - Technology

    Free eBook – Cloud Application Architecture Guide

    Download from here. Explore these best practices for any cloud. No matter which cloud you choose, certain design principles apply to ensure your app is scalable, resilient and available. Take a structured approach to architecting cloud apps using the best practices, design review checklists and reference architectures in the Cloud Application Architecture Guide eBook.

  • Data - Technology

    Change Server Mode in SSAS

    You can change the Analysis Services mode from Multidimensional Mode to Tabular Mode or vice versa easily by following below steps. I did this on SQL Server Analysis Services 2016 version. Step 1: Edit msmdsrv.ini file Go to folder X:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Config Change X: with your correct installation drive. Open file msmdsrv.ini in notepad It is recommended to take a backup first. There is a chance this folder require additional permission to edit so I would suggest you to open the file “as Administrator” Find the tag <DeploymentMode>0</DeploymentMode> If your current mode is Multidimensional then the DeploymentMode value will be 0 or…