NEW ⚡ Making decisions about when to choose which items in Fabric is a common problem: Lakehouse vs Warehouse, Pipeline vs Dataflow vs T-SQL vs Notebook etc, and it can cause some confusion... These decisions come up a lot during the DP-700 exam also, many times you will be presented with a particular scenario, and you will be asked which item is best suited to the problem - both in terms of data storage and transformation. In our latest video (just released now!), we take a look at the Microsoft Decision Guides for Fabric data stores, and data ingestion/ transformation. Plus we also cover Shortcuts and Mirroring. 👉 📽️ WATCH HERE: https://youtu.be/lPCBGOStKU4 👉 📽️ Also, earlier this week, I posted about Orchestration in Microsoft Fabric, watch that one here: https://youtu.be/U7t9j95d1WA This marks the halfway point for our DP-700 series, but we've still got a lot of big topics to come! Next week, we'll start diving into Data Transformation using T-SQL and PySpark - see you then!

NEW 🔥 Today, we continue our DP-700 Exam Preparation course on YouTube with a new video, this time the topic is... 𝗢𝗿𝗰𝗵𝗲𝘀𝘁𝗿𝗮𝘁𝗶𝗼𝗻 𝗶𝗻 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗮𝗯𝗿𝗶𝗰! In this video, we: ✔️ look at Data Pipelines (for orchestration, and ingestion), ✔️ look at a few common Data Pipeline orchestration patterns, and how to implement them, ✔️ look at orchestration in Fabric Notebooks, using notebookutils, and ✔️ explore schedule & event-based triggers. 👉 Watch here: https://youtu.be/U7t9j95d1WA Please leave a like and a comment in video if you're feeling generous! And if you have any questions, let me know! 😀

Yesterday, Microsoft introduced two new functions to the Fabric Data Warehouse, you can read more about them in their blog posts here: OPENROWSET ( Press Release || Documentation ) OPENROWSET allows you to preview the data inside a CSV or Parquet in ADLS GEn2 or Azure Blob. Can also be used with INSERT INTO to pre-filter/ transform data from a CSV/Parquet into a Warehouse table. BULK INSERT ( Press Release || Documentation ) BULK INSERT is very similar to COPY INTO, but provides a few extra configuration options: - CODEPAGE: This option allows you to load textual files encoded using national encoding. - DATAFILETYPE: This option enables you to read single- or double-byte file formats or native formats produced by SQL Server on-premises. - FORMATFILE: This option allows you to define column and type mappings in a separate textual or XML format file. How are you going to be using OPENROWSET and BULK INSERT?

Welcome to a new week, how are we all doing?! Do you know your RLS from your OLS from your CLS? Any how to implement them in a Data Warehouse? PLUS dynamic data masking, OneLake data access & data governance? 👉🔗 Find out more in VIDEO 4 of our DP-700 Exam Preparation Course: https://www.youtube.com/watch?v=pFvVAZCyYhc&list=PLug2zSFKZmV2Ue5udYFeKnyf1Jj0-y5Gy&index=4 Leave a like/ comment/ share the video - much appreciated.

Hey everyone, happy Friday! Something for the weekend for you... Video 3 of the DP-700 series is out NOW: https://www.youtube.com/watch?v=JhTl_fDZsE0&list=PLug2zSFKZmV2Ue5udYFeKnyf1Jj0-y5Gy&index=3 We cover Version Control, Deployment Pipelines and Database Projects. Enjoy!