Azure, SQL Server, R, Azure Every Day, Azure SQL Database, Machine Learning Services Announcing Machine Learning Services with R in Azure SQL Database I’d like to tell you about an exciting announcement from Microsoft and that is the preview of Machine Learning Services with [...] Bob Rubocki December 6, 2018
Azure, Azure Every Day, Azure IoT Hub, Azure Event Grid, Azure Event Hub How Are IOT Hub, Event Hub and Event Grid Related? IOT Hub, Event Hub and Event Grid are Azure services that have some similarities in name but today I’d like help with any [...] Bob Rubocki November 26, 2018
Azure, Azure Every Day, Azure SQL Database, Data Masking Static Data Masking I’d like to tell you about a newly announced feature called Static Data Modeling. This feature is not exclusive to Azure as [...] Bob Rubocki November 23, 2018
Azure, Azure Every Day, Azure Data Factory Data Flow Azure Data Factory Copy Folders vs Files In this post I’d like to share some knowledge based on recent experiences when it comes to performance of Azure Data Factory [...] Bob Rubocki November 12, 2018
Azure, Azure Data Factory, Azure Every Day, Logic Apps, REST API Authentication REST API Authentication – Azure Data Factory vs Azure Logic Apps Lately we’ve been in conversations with customers about using either Data Factory or Logic Apps for pulling data from [...] Bob Rubocki October 30, 2018
Azure, Power BI, Data Warehouse, Azure Every Day, Star Schema Do I Need a Star Schema? As we’re building a data warehouse for clients, sometimes we’re asked about the need to build a star schema. With all the [...] Bob Rubocki October 23, 2018
Azure, Azure Every Day, Azure Data Warehouse Why Use File Storage in Data Warehouse Patterns? In today’s post, I want to talk about designing a data flow for a warehousing situation. I’ll refer to the reference [...] Bob Rubocki October 22, 2018
Azure, Azure Data Factory, Azure Every Day Azure Data Factory - Execute Pipelines in Sequence When I’m working with Azure Data Factory, I often find some design tips that I like to share with the Azure community. If [...] Bob Rubocki October 3, 2018
Azure, SSIS, Azure Data Factory, Azure Every Day Performance Techniques for SSIS in Azure Data Factory If you’re new to using integration services within Azure Data Factory, you may notice at times it takes a bit longer for [...] Bob Rubocki September 28, 2018
Azure, Azure Data Factory, Azure Every Day, Azure Data Lake Can Azure Data Factory Read Excel Files from Data Lake? Today’s post is in response to a question I was recently asked. It’s about using Azure Data Lake Store with Azure Data [...] Bob Rubocki September 25, 2018
Azure, Azure Data Factory, Azure Every Day Nesting ForEach Loops in Data Factory If you’re working in Azure Data Factory or are just starting out with it, today I’m here with a quick design tip when it [...] Bob Rubocki September 21, 2018
Azure, Azure Data Factory, Azure Every Day, Parallel Processing Parallel Processing in Azure Data Factory If you’re using Azure Data Factory and make use of a ForEach activity in your data pipeline, in this post I’d like to tell [...] Bob Rubocki September 19, 2018
Azure, Azure Data Factory, Azure Every Day Reusable Data Factory Copy Activity We are all looking for ways to save time, right? Today, I want to tell you about a time saving feature of the Azure Data [...] Bob Rubocki September 5, 2018
Azure, Azure Data Factory, Azure Every Day, Logic Apps Why Not Use Azure Data Factory AND Logic Apps? If you’re just starting out with Azure, you may wonder whether you should use Azure Data Factory or Azure Logic Apps when [...] Bob Rubocki September 3, 2018
Azure, Azure Every Day, Logic Apps, Azure Functions When to Use Logic Apps and Azure Functions If you’re just starting out with Azure Logic Apps and Azure Functions, the difference between these two can be a slightly [...] Bob Rubocki August 30, 2018
Azure, Azure Every Day, Azure Portal, Azure Portal Mobile App Azure Portal Mobile App In today’s post I’d like to talk about the Azure Portal Mobile App. For many of us, our work schedule is on the go and our [...] Bob Rubocki August 8, 2018
Azure, Azure Every Day, Azure Data Factory V2, Lookup, Stored Procedure Azure Data Factory Lookup and Stored Procedure In today’s post I’d like to talk about Azure Data Factory and the difference between the lookup and stored procedure [...] Bob Rubocki August 3, 2018
Azure, Azure Every Day, Azure Data Catalog Data Glossary in Azure Data Catalog If you’re just getting started with the Azure Data Catalog, today I’ll talk about the Data Glossary that’s available within [...] Bob Rubocki July 12, 2018
Azure, Azure Every Day, PaaS, DBA Modern Data Management Employment Are you just starting your journey with Azure and cloud technology? We work with many clients in their journey and with [...] Bob Rubocki July 11, 2018
Azure, Data Warehouse, Azure Every Day, Azure Blob Storage, Azure Data Lake Azure Data Lake vs Azure Blob Storage in Data Warehousing In today’s post I’ll look at some considerations for choosing to use Azure Blob Storage or Azure Data Lake Store when [...] Bob Rubocki July 9, 2018