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.
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
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
There are a couple of ways in Power BI to create a chart to show percentage and I am writing this post to show few different ways to accomplish it. I am using a few tables from AdventureWorks 2016 CTP3 database, as below: For testing propose, I will use Line Total (Sales Order Detail Table) … Read morePower BI DAX Percentage
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
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
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