Deployment failure with Azure Analysis Services

Today when I was deploying an Azure Analysis Services in Australia Southeast region, I got the error below. STATUS: Conflict PROVISIONING STATE: Failed TYPE: Microsoft.AnalysisServices/servers System.Fabric.FabricTransientException: The operation failed because the service is currently offline. I tried to deploy AS in another Azure region (WEST US), which was completed successfully. After that, I realized the issue … Read moreDeployment failure with Azure Analysis Services

Exam 70-475 Designing and Implementing Big Data Analytics Solutions

In this post, I would like to share my experience on how to study to Microsoft Exam 70-475 Designing and Implementing Big Data Analytics Solutions. This exam will test your knowledge on Azure HDInsight, Data Lake Analytics, Azure Data Factory, Azure Machine Learning, Azure IoT, Azure Event Hub, Azure Stream Analytics and Azure SQL Database. … Read moreExam 70-475 Designing and Implementing Big Data Analytics Solutions

SQL Server Row-Level Security (RLS)

In this post, I will explain how to setup and use SQL Server Row-Level Security (RLS). RLS is available from SQL Server 2016 and also on Azure SQL database. RLS is used to control access to rows (records) in your database table, restricting employees to ONLY access rows related to their department, region or any … Read moreSQL Server Row-Level Security (RLS)

Azure SQL Database cross-database queries

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 … Read moreAzure SQL Database cross-database queries

Checking Queries Performance on Azure SQL Database (DMVs)

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 … Read moreChecking Queries Performance on Azure SQL Database (DMVs)

Azure SQL Database – Modify file failed – Size is greater than MAXSIZE.

This week, when I tried to move one of the Azure SQL Database from the Elastic Pool, 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 resource operation completed with terminal provisioning state … Read moreAzure SQL Database – Modify file failed – Size is greater than MAXSIZE.

Exam 70-473 – Designing and Implementing Cloud Data Platform Solutions

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 on 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 … Read moreExam 70-473 – Designing and Implementing Cloud Data Platform Solutions

Index Related Dynamic Management Views and Functions

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 the 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 … Read moreIndex Related Dynamic Management Views and Functions