Month: May 2020

Data Factory adds new easy way to view estimated consumption of your pipelines. Use it to estimate the number of units consumed by activities while debugging your pipeline and post-execution runs.
 
While designing and debugging your pipelines, cl… Continue reading New ADF pipeline consumption report→

Thriving on Azure SQL Microsoft Advertising is a powerful advertising platform designed to get your ads in front of the right customers. In the fiscal year 2019, search advertising revenue generated $7.6 billion for Microsoft. We have been on a jo… Continue reading Learning from Microsoft Advertising Platform on Azure SQL→

Did you hear of room lists? What is a room list?
A room list is a collection of room mailboxes. Room lists are specially marked distribution groups that you can also use the same way you use ‘regular’ distribution groups. You can only create room lists… Continue reading How to configure the new Room Finder in Outlook→

We recently released an update to Microsoft.Data.SqlClient, version 1.1.3. The update addresses a couple issues that are important to our customers. Updates in Microsoft.Data.SqlClient 1.1.3 are: FixedFixed driver behavior to not perform enli… Continue reading Released: Microsoft.Data.SqlClient 1.1.3→

This week, Microsoft announced the SSIS DevOps Tools extension is now generally available, multi-page scanning is now available for everyone using a OneDrive personal account, and general availability of ‘know your data’ (discovery and r… Continue reading The May 15th Weekly Roundup is Posted!→

Are you attending Microsoft Build this year? You don’t want to miss these human-focused sessions!
 
If you’re planning to attend digital Microsoft Build 2020 from the comfort of your own home this year, be sure to add these two human-focused sessi… Continue reading Join us at Microsoft Build 2020 | Community Spotlight Series→

ADF has added columns() and byNames() functions to make it even easier to build ETL patterns that are reusable and flexible for generic handling of dimensions and other big data analytics requirements.
 
In this example below, I am making a generi… Continue reading New data flow functions for dynamic, reusable patterns→

For production workloads running on your Azure SQL Managed Instance it is very important to continuously understand the resource consumption and any potential performance issues such that you can react in time and have your business running smoothly. T… Continue reading Monitoring options available for Azure SQL Managed Instance→