Azure Data Factory V2– Pipeline Functional Testing

This article helps you to understand functional testing with pipelines in Azure Data Factory. Note:- This article applies to Azure Data Factory V2. This article assumes that you have gone through Introduction to Azure Data Factory and the QuickStart Tutorial. Credits – Thanks to ADFv2 Product Group (Anudeep Sharma, Hermine Vermishyan & Abhishek Narain ) for reviewing…


PowerShell PowerTip: Customizing your prompt

I’ve been taking a break from the blog for a while due to some personal reasons, but I had a few people ask me about my PowerShell prompt recently. I like extra horizontal space, so I removed the path from the prompt and put it in the window title bar. I also just display the…


Check out this week’s top reads, it’s the Friday Five!

SQL Server Replication – Of The Duplication Kind Warwick Rudd is a Data Platform MVP, Microsoft Certified Master – SQL Server 2008, Founder and Principal Consultant at SQL Master Consulting. With over 15 years of experience beginning with the release of SQL Server 6.5, he has worked in both Australia and England from small start-ups to Multi-National…


How to create a native PowerShell app registration to connect to Azure SQL DB

How to create a native app registration This guide assumes that you already own an Azure Subscription, an Azure Active Directory properly setup and your PowerShell environment properly set for running scripts.  You might want to refer to this article first: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/10/26/azure-sql-database-token-base-authentication-with-powershell/ Problem summary:  There might be a time when we you will want to…


Azure SQL Database Token-based authentication with PowerShell

How to connect to Azure SQL Database using token-based authentication in PowerShell native apps This guide assumes you already have a deployment of an Azure SQL Database, your PowerShell environment configured and you have an app registration for a native app in Azure Active Directory. How to configure a native app registration: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/10/30/how-to-create-a-native-powershell-app-registration-to-connect-to-azure-sql-db/ Problem summary: There…


Automating the creation of Azure Service Principals with PowerShell

Recently had to give a chalk talk on a Azure Service Bus (ASB). Creating and recreating the various topics and subscriptions is a bit of a pain since there are so many options and parameters to consider. The way I go about it is to create a utility that simply creates and destroys all the infrastructure I need for the chalk talk.


The number 400

What is significant about the number 400? 400 is 20² 400 is divisible by: 1, 2, 4, 5, 8, 10, 16, 20, 25, 40, 50, 80, 100, 200, 400 400 equals 2⁴ * 5² or ( 2*2*2*2*5*5) 400 is a self-number which are generated by this formula:  You can write 400 like this: four hundred,…

1