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

Power BI – Working with Date – Part II

In the previous post (Working with Date – Part I), I wrote about calculated column for month and year and in this post I will explain how to work with day and week formats. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Read morePower BI – Working with Date – Part II

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

Power BI – Working with Date – Part I

I have been working with Power BI for few years and quite often someone asks me questions about Date functions in DAX (Data Analysis Expressions), that is the reason I am writing this post. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Read morePower BI – Working with Date – Part I

Invoking R script file in SQL Server 2016

The sp_execute_external_script is a stored procedure to execute script at an external location. The system sp_execute_external_script stored procedure was introduced in SQL Server 2016 and only supports R language. This post, I will show how to invoke an R script file in SQL Server 2016. Prerequisites Install SQL Server 2016 with R Server Enable External … Read moreInvoking R script file in SQL Server 2016

Compatibility Level – Tabular Model

Before we talk about Compatibility Level on Tabular model project, it is important to explain what is Compatibility Level. Compatibility Level  is the version of SQL Server with which a Database or Tabular model is compatible. Follow the compatibility level for databases: 80 = SQL Server 2000 90 = SQL Server 2005 100 = SQL … Read moreCompatibility Level – Tabular Model