In this episode, we walk through how to integrate with Microsoft Dynamics 365 using its powerful API capabilities, focusing on the REST-based Web API that provides secure and flexible access to CRM data. We start with an introduction to Dynamics 365 as a suite of intelligent business applications and explain how its CRM features—sales, marketing, and customer service—become even more powerful when connected through APIs. You’ll learn about the different API options in Dynamics 365, including the Web API and Organization Service, and why REST APIs are the go-to choice for modern integrations. We cover the essentials of getting started: setting up your Dynamics environment, configuring permissions, authenticating with OAuth 2.0, and making your first API call using standard HTTP methods. The episode also breaks down how to perform key data operations—creating, retrieving, updating, and deleting CRM records—using the Dynamics 365 Web API. We discuss how to handle JSON responses, ma…

In this episode, we dive into Microsoft Fabric, the unified data and analytics platform reshaping how organizations manage, analyze, and act on their data. Designed to bring Power BI, Data Factory, Azure Synapse, and other Microsoft services into one integrated environment, Fabric simplifies everything from data ingestion and transformation to advanced analytics and real-time reporting. You’ll learn what Microsoft Fabric is, why analytics play a central role in modern data platforms, and how Fabric creates a single source of truth across your organization. We break down the major components—Fabric Data Warehouse, Data Factory, data engineering tools, SQL capabilities, data science workflows, and seamless Power BI integration. These features enable businesses to build scalable data pipelines, perform complex analytics, and visualize insights effortlessly. The episode explains how Fabric enhances Power BI through real-time analytics, unified data access, and deeper integration wit…

In this episode, we break down Power Pages—Microsoft’s low-code tool for building secure, data-driven websites—and explain how its licensing, capacity limits, and alternative solutions compare. You’ll learn what Power Pages is, how it integrates with Dataverse and the Power Platform, and why organizations use it to quickly create customer portals, partner sites, and self-service web experiences without heavy custom development. We cover the key features of Power Pages, including its low-code design studio, support for authenticated and anonymous users, and native integrations with Power Apps, Power Automate, Power BI, and Dynamics 365. You’ll hear how these capabilities help teams build interactive sites that connect directly to business data and automate workflows across the Microsoft ecosystem. A major focus of the episode is the Power Pages licensing model—how authenticated and anonymous user licenses work, how page views affect pricing, and how Power Apps or Dynamics 365 lic…

AI isn’t an edge case in your SIEM anymore—it’s a participant. This episode asks a hard question: when Copilot surfaces a confidential file your user can technically access, is that a breach, a policy gap, or “works as designed”? We walk through why AI access alerts don’t fit classic kill-chain thinking and how overshared data + weak labeling turn Copilot into an accidental exfil partner. The fix isn’t panic; it’s alignment: Purview/DSPM to map sensitivity and label history, DLP & label-based exclusions to block AI from high-risk content, Defender XDR to correlate AI access with endpoint movement, and prompt/interaction auditing so investigations have receipts. You’ll get a mental model for AI incidents (“malicious, overreach, or justifiable?”), the signal bridges your SOC needs (label change → AI access → downstream movement), and a prewired combo that turns noisy “Copilot touched a file” events into guided, evidence-backed actions. By the end, you’ll have a practical blueprint to…

In this episode, we dive into how R and SQL Server work together to create a powerful data analytics workflow. You’ll learn why SQL Server excels at storing, organizing, and retrieving large datasets, while R specializes in statistical analysis, visualization, and machine learning. When combined, these two tools streamline data processing, reduce duplication of effort, and enable deeper, more efficient data insights. We explore common use cases—such as running SQL queries from R, analyzing SQL Server data with R’s statistical packages, and using R to create visualizations or predictive models based on SQL data. The episode also walks through how to set up your environment, install the required R packages (RODBC, DBI, odbc, sqldf), and configure ODBC connections so R can query SQL Server directly. You’ll learn best practices for writing SQL queries inside R scripts, using T-SQL features, fetching data into R data frames, and mapping R data types to SQL Server types without losing…

In this episode, we break down how modern development teams can fully automate their CI pipelines using dev containers, container images, and command-line tooling. We explore why containerization has become foundational to DevOps workflows, how development containers ensure consistent coding environments, and how automation tools like Docker, GitHub Actions, and CLI utilities streamline everything from build to deployment. You’ll learn what containers are, why they solve the “works on my machine” problem, and how dev containers—powered by devcontainer.json and VS Code—give developers reproducible, portable workspaces. The episode walks through the core components of a CI pipeline, including source control triggers, automatic builds, container image creation, and deployment stages that rely on Docker and container registries. We explain how Dockerfiles define your application’s build instructions, how base images impact performance and security, and how multi-stage builds can dra…

In this episode, we explore how organizations can turn Dynamics 365 Business Central telemetry into powerful insights using Microsoft Power BI. Telemetry is one of the most valuable—and often underused—capabilities in Business Central. It captures performance data, user behavior, errors, and system activity, giving administrators a complete view of how their environment is running. We begin by breaking down what Business Central telemetry is, why it matters, and how it helps companies identify performance issues, track usage, and optimize their configurations. The episode explains how telemetry is collected through Azure Application Insights and what kinds of data Business Central emits—everything from page views and API calls to background sessions and extension behavior. Listeners learn the practical steps for enabling telemetry in the Business Central admin center and how Azure Application Insights becomes the hub for querying, monitoring, and alerting on system activity. We …

In this episode, we take a deep dive into Microsoft Copilot inside Dynamics 365 Business Central and explore how AI is transforming day-to-day business operations. We start by grounding listeners in the essentials of Business Central—a comprehensive ERP for small and midsized organizations that connects finance, operations, sales, supply chain, and reporting in a unified Microsoft ecosystem. From there, we introduce Microsoft Copilot, the AI assistant woven throughout Microsoft 365 and Dynamics 365. We discuss how Copilot enhances Business Central by automating repetitive tasks, generating insights from business data, improving decision-making, and simplifying user workflows through natural-language interaction. Listeners learn about the standout Copilot features currently available in Business Central, including intelligent bank reconciliation, AI-assisted inventory management, automatic marketing text generation, predictive insights, and context-aware assistance built right in…

In this episode, we unpack two major AI platforms in the Microsoft ecosystem—Copilot Studio and Azure AI Foundry—and help listeners understand when to use each one. Whether you're building conversational AI, custom machine learning models, or enterprise-grade AI applications, choosing the right platform is key to getting the most from Microsoft’s AI stack. We begin by exploring what each platform is designed for. Microsoft Copilot Studio is the low-code, accessible environment inside the Power Platform for building conversational AI agents and workflow-driven bots. It's ideal for customer service chatbots, internal support agents, automated responses, and Microsoft 365-integrated AI experiences. Its biggest strengths: simplicity, rapid deployment, and a natural path for teams with minimal coding experience. On the other side, Azure AI Foundry is built for developers, data scientists, and AI engineers who need advanced control, scalability, and custom AI model development. It sup…

In this episode, we dive into one of the core engines behind Microsoft Fabric’s modern analytics ecosystem—Dataflows Gen2. We explore how this next-generation data ingestion and transformation tool is shaping the way organizations prepare, refine, and deliver data for analytics. We start with an overview of Microsoft Fabric, Microsoft’s unified analytics platform that brings together data engineering, data science, real-time analytics, Power BI, data factory, and lakehouse capabilities in a single integrated environment. Fabric is designed to simplify complex data estates, and Dataflows Gen2 plays a pivotal role in achieving that simplicity. Listeners get a clear explanation of what Gen2 actually means: improved architecture, better performance, expanded connectivity, stronger data prep features, and support for more complex data ingestion scenarios. Gen2 builds on traditional Power Query–based dataflows but offers scalability and reliability fit for enterprise-grade pipelines.…

In the evolving world of Microsoft Fabric, the Digital Twin Builder preview emerges like a quiet shift that changes everything without announcing itself loudly. You start by taking the world you already know—machines, rooms, sensors, movements, transactions—and giving it a second life inside the Fabric environment. This second life isn’t static or symbolic; it breathes with real-time data, always adjusting, always reflecting what’s happening right now. Data from sensors, logs, or operational systems flows into the Fabric lakehouse, and the builder reshapes it into a digital form that mirrors the physical world. The semantic canvas becomes the place where these connections come alive, letting you see how everything relates, how one action affects another, and how the digital counterpart shifts as the real world does. You wire event streams into the model, and suddenly the quiet digital structure begins to pulse with updates—temperature changes, equipment activity, stock movement, envir…

In this episode we walk through what really happens when Azure AI Foundry doesn’t behave the way you expect, especially when the Agent Service or deployments start acting up. Azure AI Foundry is supposed to feel smooth, almost invisible, tying together OpenAI models, search, storage, and all the moving parts behind an AI application. But sometimes things slip, the agent stops talking to its resources, deployments stall, endpoints go quiet, and suddenly you’re trying to figure out what broke where. Most of the time the story starts with the Agent Service, the piece that quietly moves requests around, calls other Azure services, handles identities, and keeps the internal wiring alive. When it stumbles you see failed API calls, permissions errors, or models that never fully deploy. You open the portal, you dig through the logs, you check whether the managed identity has access to Cosmos DB, Storage, or Search, and you make sure nothing in the network layer or a recent security update cut…

The real shift is autonomous AI agents – systems that don’t just answer a prompt and wait for the next human nudge, but notice, decide, and act on their own. Not a “bot that replies in Teams,” but a worker that reads the situation, picks a plan, executes it, and learns from whatever broke along the way. An autonomous AI agent is basically an AI-powered loop: sense, think, act, learn. It pulls in signals from APIs, logs, documents, sensors, whatever you feed it. It builds an internal picture of “what’s going on,” runs that through models and planning logic, picks an action, executes it, and then uses the outcome as feedback to adjust its strategy. No one is there hand-holding it through each click. You set goals and constraints; it figures out the steps. They come in flavors. Some are laser-focused goal agents: “keep this metric green,” “close as many tickets as possible,” “optimize this schedule.” Some are reflexive: “if this happens, do that, instantly.” Others are true learnin…

power bi keeps showing up in the background of every conversation about data because it does something most tools struggle with: it doesn’t just help you look at numbers, it helps people work together around them. the reports, the dashboards, the visuals—those are great, but the real power is how easily a team can gather around the same set of insights without fighting through email attachments or version chaos. you start with data from wherever it lives, pull it into power bi, shape it, build something that actually makes sense. but the magic happens the moment you hit share. suddenly the report isn’t just yours; it becomes something the whole team can poke at, question, filter, and react to. in the service, everything lives in the cloud, so no one needs to hunt for the right file or worry about sending the wrong version. everything updates in place. everyone sees the latest truth. workspaces add another layer, turning what used to be a solo project into a team studio. people c…

This episode argues that Syntex being folded into SharePoint Premium is not a naming joke — it’s Microsoft consolidating content processing, content experiences and governance into one platform so Copilot can stop guessing and start delivering real answers. SharePoint Premium = Brain (content experiences) + Muscle (content processing) + Bouncer (governance) When those three are unified → content becomes structured + governed + queryable → and that is what finally makes Copilot useful. Real-world proof: orgs like London Stock Exchange cut document processing time from hours → minutes. The real danger isn’t bad AI — it’s good AI running without guardrails and multiplying bad classification + oversharing mistakes. Governance is not optional. It’s the safety net. Key tactic: start with 1 high-value process (invoices/contracts), use prebuilt models first, measure time saved, then scale.

when people first open power bi, they usually jump straight into visuals. charts, slicers, maps—it feels like that’s where the real action is. but the longer you work with it, the more you realize that the real magic is happening underneath, in the way the data is shaped and modeled. the model is the engine, and without the right engine, even the best-looking report falls apart. that’s where the star schema comes in. it’s the moment power bi stops feeling confusing and starts making sense. think of power bi desktop as the workshop. it brings in data from wherever it lives, lets you clean it up with power query, and gives you a canvas to shape how everything relates. but the trick isn’t just getting the data in—it’s organizing it so power bi can think clearly. when you structure your data in a star schema, something clicks. suddenly measures work the way you expect. filters behave predictably. visuals respond faster. and the model becomes easy to explain to anyone, even people who’v…

the moment people hear “data activator,” they assume it’s just another automation tool tucked somewhere inside microsoft fabric. but once you actually see it in action, it feels more like watching data wake up. instead of dashboards that wait for someone to notice a problem, the activator notices it for you. instead of a report that quietly updates in the background, the activator jumps in and does something the second a condition is met. it turns fabric from a place where you look at data into a place where data reacts, nudges, alerts, and responds. the idea behind it is simple: anything that changes in your data—anything that spikes, drops, drifts, or falls out of pattern—can automatically trigger an action. and the best part is that you don’t need code to make any of this happen. the activator listens to your streams from power bi, event hubs, and other sources, and you just tell it what to look for. when the pattern appears, the action fires. maybe it’s a teams message. maybe i…

every organization that takes data seriously eventually hits the same crossroads: the reports are getting bigger, the models are getting more complex, more people are asking for changes, and suddenly a single workspace with everyone pressing publish just doesn’t work anymore. this is usually the moment someone brings up deployment pipelines in power bi, and the whole process of managing reports starts to feel less like chaos and more like an actual system. the concept is simple enough. instead of pushing everything straight into production, you move through stages. you build in one place, you test in another, and only when you’re ready do you send it to the environment where everyone depends on it. but the moment you start using deployment pipelines, you realize it’s not just about structure—it’s about control, quality, and avoiding the kind of mistakes that ripple across a whole organization because someone replaced a measure at the wrong time of day. what makes pipelines feel …

people often hear the words sql and t-sql thrown around as if they’re interchangeable, and for a while they feel like they are. you write a query, you get your results, and everything seems straightforward. but the deeper you go into database work, the more you notice that not all sql behaves the same, and the moment you start working with microsoft sql server or azure sql, t-sql shows up and quietly becomes its own world. and suddenly the differences matter—not because they’re confusing, but because they’re the key to building things that are faster, safer, and smarter. sql itself is the foundation. it’s the shared language every relational database speaks, the set of rules for selecting data, joining tables, filtering results, and reshaping information. it’s the common grammar behind mysql, oracle, postgresql, and sql server. if sql were a language like english, the basic structure would always be the same everywhere you go. t-sql is what happens when microsoft adds its own di…

sharepoint has this way of becoming everything and nothing all at once. a place meant for structure slowly turning into a maze of lists, libraries, document versions, old folders nobody remembers creating, and columns added by someone who left the company four years ago. people rely on it because it’s everywhere, because it’s part of microsoft 365, because it’s the easiest place to drop things when you don’t know where else they go. but with enough time, the whole thing starts to feel like a storage closet that everyone uses and nobody organizes. and then power bi steps in—not as a cleanup crew, but like someone who can walk into that same chaotic room and immediately understand where everything belongs. power bi doesn’t care how messy the source looks. as long as it can connect, it can make sense of it. once you point it at a sharepoint site, especially one running on sharepoint online, it starts reading those lists and libraries for what they really are: structured data waiting t…

This episode breaks down model-driven apps in Power Apps and shows you exactly how to master them using Microsoft Learn. If you’ve ever wondered when to use a model-driven app, how Dataverse fits into the picture, or why business logic matters so much, this is your crash course. We walk through the core components—tables, views, forms, dashboards, custom pages—and explain how a solid data model becomes the backbone of an enterprise-grade app. You’ll learn how Dataverse powers secure, structured data management, why business rules and process flows save you from bad data, and how to customize tables so your app mirrors real business processes—not the other way around. We also cover publishing, sharing, and securing your app, including how to use security roles to control access and drive adoption. Then we map out the best Microsoft Learn modules and learning paths so you know exactly where to start, how to level up, and how to connect the dots between Dataverse, Power Automate, a…

This episode cuts through the confusion around Dataverse data migration and explains, in plain language, how to move data between environments without breaking your schema, losing your relationships, or waking up to a support queue full of duplicate records. You’ll hear why data migration has quietly become one of the most essential skills for Power Platform teams, and how the right mix of tools—Configuration Migration Tool, dataflows, Power Automate, and the broader Power Platform stack—turns a painful, error-prone process into a predictable, governed pipeline. We start by grounding everything in what Dataverse actually is: not just tables and rows, but a secure, relational, cloud-first data backbone built around business logic, unique identifiers, and strict data integrity rules. From there the episode dives into the real decisions teams face when migrating—how configuration data behaves differently from transactional data, why alternate keys matter more than people assume, and h…

This episode goes straight into the uncomfortable truth behind Microsoft Copilot: the same AI that accelerates your workflows can also expose your most sensitive data if you don’t govern it correctly. We unpack how Copilot for Microsoft 365 pulls information from across SharePoint, OneDrive, Teams, and the Microsoft Graph, and why that deep integration becomes a double-edged sword the moment your permissions, classifications, or data boundaries fall even slightly out of alignment. You’ll hear how real data leaks happen—not through hacking, but through perfectly normal Copilot behavior. Meeting summaries pulling restricted content. Auto-generated documents mixing in confidential details. Presentations created from SharePoint libraries the user shouldn’t have access to in the first place. We break down why Copilot doesn’t “invent” exposure, it amplifies whatever access model your tenant already has, for better or worse. From there, the episode zooms out to the bigger issue: modern…

Microsoft Fabric Git Integration is changing the game for anyone building modern data platforms, and in this episode we break down exactly how it works and why it matters. Discover how Microsoft Fabric seamlessly connects to Azure DevOps and GitHub, giving you full version control, automated deployments, and a true end-to-end CI/CD workflow for everything from semantic models to Power BI reports. This episode shows how Fabric unifies your data engineering, data warehousing, and analytics tools while Git integration brings collaboration, code tracking, and environment consistency to the entire process. We also explore how Azure DevOps Pipelines and GitHub Actions can automatically build, test, and deploy your Fabric content, helping teams ship updates faster, avoid errors, and maintain total governance across dev, test, and production environments. If you're ready to level up your data operations, streamline deployments, and unlock the full power of Microsoft Fabric with Git, Azure Dev…