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…
-
-
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
-
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.
-
Architectures to help you design and implement secure, highly-available, performant and resilient solutions on Azure. URL: https://azure.microsoft.com/en-us/solutions/architecture/?_lrsc=fd65b7ab-4a43-4e3f-b000-4c56030f5c69
-
Nice set of design references for your next project. URL: https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/
-
Find the PoserShell script:
-
And I will be speaking about Cognitive Services and give a demo on Text Analytics. Register now at http://kmug-july2018.eventbrite.com. Here goes the quick social media flyer designed by me for the announcement
-
This script will create an SQL Server Agent job, which will take daily database backup to a folder with date appended in the filename.
-
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…
-
A nice read on ‘why you should be careful when dealing with strings’ – https://medium.com/@indy_singh/strings-are-evil-a803d05e5ce3