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

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. →

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 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 →

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 … Continue reading Power BI – Working with Date – Part II →

Power BI DAX Percentage

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) … Continue reading Power BI DAX Percentage →

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 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 →

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 … Continue reading Power 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 … Continue reading Invoking R script file in SQL Server 2016 →