Why Choose File Storage in Data Warehouse Architectures?

In this article, we’ll explore the strategic role of file storage within data warehouse design patterns, particularly in cloud-based environments. Referencing Microsoft’s published data warehouse architecture, we’ll focus on the common practice of extracting data from source systems and storing it as files—often in Azure Blob Storage or Azure Data Lake—before loading it into the… Read More

Copilot in OneNote: Transform Your Digital Note-Taking Experience

Discover the future of digital organization with Copilot in OneNote, an immersive new course led by Devin Knight, President. This preview introduces a hands-on learning experience designed to elevate productivity, streamline task management, and unleash creativity using Microsoft’s powerful AI tool—Copilot—integrated directly into OneNote. Unlocking Copilot in OneNote: A Revolutionary Note-Taking Journey The integration of… Read More

Understanding PowerApps Canvas vs. Model-Driven Applications: Key Differences Explained

Are you familiar with the distinctions between PowerApps Canvas and Model-driven applications? Whether you’re a seasoned PowerApps user or just starting out, understanding these two app types is crucial for selecting the right approach for your project. In this article, Brian Knight breaks down the differences and helps you decide when to build a canvas… Read More

Understanding PowerApps Canvas vs. Model-Driven Applications: Key Differences Explained

Are you familiar with the distinctions between PowerApps Canvas and Model-driven applications? Whether you’re a seasoned PowerApps user or just starting out, understanding these two app types is crucial for selecting the right approach for your project. In this article, Brian Knight breaks down the differences and helps you decide when to build a canvas… Read More

How to Move Files Between Folders on Your FTP Server Efficiently

Downloading files from an FTP server is straightforward. Uploading files? Even easier. But what about moving files between folders on the server, especially as part of an automated ETL process? For many SSIS developers, this can be a tricky task. Fortunately, with recent updates in Task Factory, managing file movements on your FTP server has… Read More

Power Automate and HubSpot Integration Guide

Devin Knight returns with the latest installment in the Power Automate and HubSpot integration series. Previously, we covered connecting these platforms using private apps and APIs. Today, we focus on an alternative approach—utilizing HubSpot’s native workflows to trigger Power Automate flows effortlessly. Unlocking the Power of HubSpot Automation with Workflows In today’s digitally transformed business… Read More

How to Filter Records for the Current User in Power Apps

One of the most common questions asked during PowerApps training sessions is: Can I filter gallery records to show only those created by or assigned to the logged-in user? The good news is — absolutely, yes! Filtering records by user is not only possible, but it’s also a best practice for creating personalized and secure… Read More

Enhance PySpark Development with the AI Assistant in Databricks

In today’s data-driven world, efficient coding and quick debugging are crucial. Databricks’ AI Assistant offers a groundbreaking way to simplify PySpark development by helping you write, debug, and optimize code directly within the platform. In this tutorial, Mitchell Pearson walks through practical use cases of this intelligent tool, showing how it enhances productivity for data… Read More

How to Build Power Apps for Disconnected and Offline Use

Have you ever needed to use an app without internet or Wi-Fi but still wanted to save your data to a database? In this guide, I’ll explain how to design a Power Apps application that works seamlessly offline or in disconnected environments. This app stores data locally on your device and automatically syncs it to… Read More

Understanding Static Data Masking: A Powerful Data Protection Feature

Today, I want to introduce you to an exciting and relatively new feature called Static Data Masking. This capability is available not only for Azure SQL Database but also for on-premises SQL Server environments. After testing it myself, I’m eager to share insights on how this feature can help you protect sensitive data during development… Read More

Power Automate and HubSpot Integration: A Deeper Dive

Devin Knight continues his comprehensive series on integrating HubSpot with Power Automate. In this second installment, he focuses on the Power Automate side, guiding you through creating a secure flow that communicates effectively with HubSpot’s API to perform tasks like searching contacts by email. Let’s explore the key steps and concepts covered in his detailed… Read More

Step-by-Step Guide to Creating PDF Documents from Power Apps

If you’ve ever wondered how to generate a PDF file directly from Power Apps, you’re not alone. Many organizations require PDF outputs for reports, invoices, permits, and other business documents. Fortunately, you can achieve this seamlessly using Power Apps in combination with Power Automate—without relying on expensive third-party tools. Unlocking the Value of PDF Document… Read More

Understanding Data Governance: The Essential Framework

Data security remains a top priority for organizations worldwide, and effective data governance policies are key to achieving this. In this first installment of our two-part series on data governance, we’ll explore the foundational concepts you need to know to build a strong data governance strategy. Understanding the Three Fundamental Pillars of Data Governance Data… Read More

The Power of Walking Around: Discover Hidden Business Challenges

Many years ago, while leading a Finance IT team, I developed a habit that proved incredibly valuable—walking around and checking in with my clients. One day, I stopped by Joe’s office and noticed something unusual on his screen. “Morning, Phillip,” Joe greeted me as I passed his cubicle. His screen flickered strangely. Instantly curious, I… Read More

Power Automate Templates: Your Essential Starting Point for Building Flows

Are you new to Power Automate and unsure where to begin? No worries! I’ve just launched a new YouTube series titled Power Automate Basics, designed specifically to guide beginners through everything they need to know to get started with flow automation. Automation is transforming how businesses operate by streamlining repetitive tasks and optimizing workflows. Microsoft… Read More