Latest From The Blog

Measure Your Productivity in Power BI with Zero Efforts and Instantly

Last week Microsoft released Teams activity reports in Power BI that allows you to analyze how much time you have been spending on meetings, how much you have been talking over various chats, how much time you shared your screens etc. and all this is available instantly. For me, this is how it looked like

Continue reading

Power BI Data Flows Refresh History – Chrome or Firefox…Does it Really Matter?

An interesting observation was made today. I had to check the refresh history of one of our data flows so casually logged into Power BI service using Firefox browser, navigated to the refresh history and saw it as shown in the following snapshot – Anything different or unusual? I didn’t see today’s date and not

Continue reading

Did You Know…Locking is Normal in SQL Server

This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight

Continue reading

ADF Execute Pipeline Activity Error Handling

In the previous post, we saw the basics of catching errors generated by activities during the flow and here we will see all the complexities involved in handling the same for execute pipeline activity. The first step of handling or say catching errors during a pipeline’s execution remains the same that you need to add

Continue reading

Azure Data Factory (ADF): Error Handling

We have been receiving several questions about how to implement error handling in ADF pipelines so let us take a quick look around this concept and how this could be simplified – The very first thing we need to handle the errors is to add a path to the activity so that if there is

Continue reading

DID You Know…ADF Activity Retry Interval Limits

This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight

Continue reading

Azure SQL Database Maximum Concurrent Requests

Whether this is SQL Server on-premise or Azure SQL Database, maximum number of requests which can be processed by database engine simultaneously is limited by its compute size or you can say SKU. Service tier is another factor that you need to consider on Azure in addition to compute size as the size of SKU

Continue reading

Azure Purview – Yes or No? Let us Find Out

We were overwhelmed during the webinar itself when Microsoft launched Azure Purview as their next generation data catalog or say unified governance workspace and it was continuously in the mind to explore it to figure out if it is the right time to plan about it. So, let’s find out together what it offers, what

Continue reading

DATETIME vs. DATETIME2 in Azure SQL Server: How Easily A Husband Explains This to Wife

We all know that DATETIME and DATETIME2 both data types are available in Azure SQL Database or in general, SQL Server database. Let us see which one to go for as it was asked by a wife to her husband – Wife: Honey, I am creating a new SQL table and need to store timestamp

Continue reading

Non Matching Rows in ADF Data Flow Lookup Transformation

If you have been coming from traditional SSIS background then definitely you must have used Lookup transformation there which is the most common transformation in any ETL workload. And one of the native capability of this transformation there, was to route matching and non matching records to different paths…for a quick refresher, this is what

Continue reading