In this post, I will explain how to setup and use Row-Level Security (RLS) which is available from SQL Server 2016 and on Azure SQL database. RLS enables you to control access to rows (records) in your database table, restricting employees to ONLY access rows related to their department, region or any other criteria required … Continue reading SQL Server Row-Level Security (RLS)
In Azure SQL Database, you need to use Elastic Queries to run a query that access data from other databases, which is called cross-database queries. You probably have done it in SQL Server on-premises or IaaS, where you access tables from other databases by typing <database name>.<schema name>.<table name>. In this post, I will show … Continue reading Azure SQL Database cross-database queries
In this post, I will share a couple of important queries that I am using to check performance on Azure SQL Database. Show locking information: SELECT t1.resource_type, t1.resource_database_id, t1.resource_associated_entity_id, t1.request_mode, t1.request_session_id, t2.blocking_session_id FROM sys.dm_tran_locks as t1 INNER JOIN sys.dm_os_waiting_tasks as t2 ON t1.lock_owner_address = t2.resource_address; For further details read: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql Show Top 5 worst performance … Continue reading Checking Queries Performance on Azure SQL Database (DMVs)
This week I was working with a customer and when I tried to move one of the Azure SQL Database from the Elastic Poll I received the following message: Code: DeploymentFailed Message: At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-debug for usage details. Code: Conflict Message: The … Continue reading Azure SQL Database – Modify file failed – Size is greater than MAXSIZE.
I spent around 2-3 weeks studying for the Microsoft Exam 70-473 (Designing and Implementing Cloud Data Platform Solutions) and I decided to write this post to help anyone in the same journey. This exam will test your knowledge on Microsoft Azure SQL DB, Azure SQL Data Warehouse and SQL Server in IaaS. You also need … Continue reading Exam 70-473 – Designing and Implementing Cloud Data Platform Solutions
Dynamic Management Views (DMV) was introduced in SQL Server 2005 and every SQL Server release Microsoft introduces additional DMVs, which helps to provide information about health of a Server instance, performance and Server issues. There are two types of DMV, the first type is server-scoped DMV which requires VIEW SERVER STATE permission on the Server and … Continue reading Index Related Dynamic Management Views and Functions
It was great to present Streaming data with Azure IoT Hub, Stream Analytics, Blob Storage, Azure SQL DB and Power BI at Perth SQL Server User Group. In this session I presented the following: Overview of IoT and IIoT;Overview and provision of Azure SQL Database;Provision of Azure Blob Storage;Overview and Provision of Azure IoT Hub;Azure … Continue reading Azure IoT Hub – Perth SQL Server User Group