Відео

Hi! great video. I am actually trying to something that is very similar to this. I need the communication line to be not connected to public internet, and the data flow is only legal from on prem sql to fabric as a push mechanism using ADF. In your solution, do I have to do anything to make the line completely secure? The data is highly sensitive that is why I need to do it this way. By the way, are you using Synapse or ADF in your example?

Can we use managed identity instead of SAS?

Hey, What if I want to execute the fabric pipeline only if there is data blob created on a specific container and folder. I dont wanrt to trigger it for all the blob uploads ??

Thank you for the above Sir, very informative and helps. I kinda have the same scenario with encrypted SPs, would you know how anything about how to do this.

*Customer wants a test run of upgrading an application, and needs a PITR snapshot in SMI in case of need to rolback* Googles how to.... finds this video, PHEW! Thankyou for dropping this, very handy!

I am using it now... and it works. Reminder ... set a batch limit on the downstream foreach activity that is consuming the .json output.

The SID comes as an encrypted value. Anyone had the same issue?

Nice video . I want to know if this service is free or do we have to pay for using this service? I mean does it billed in my monthly billing?

Joseph Masengesho is the best! Very helpful article

Thank you for the overview of Elastic jobs. However, I have jobs to run on Azure Managed Instance. Is it the same as Azure Database? Because when I tried to create an Elastic Job Agent, the database selection column is empty (I have a SQL Managed Instance with 2 databases on my Azure tenant).

Amazing video!! Can you send me TSQL scripts and all the steps how to secure and setup?

Thanks for keeping it real

can you please copy/paste the script in the description

so how much your ADF that does only this cost monthly?

Love the video. Thanks!

Another brilliant video. Thank you!!

This is more than great! I am running a notebook that runs multiple notebook and I wanted pass the notebook names that failed for further processing. Thank you for sharing!

What happens when you promote those storage event triggers to the next environment (workspace)? How do you get it to update the subscription / storage account name etc? Currently in ADF you have to use the ARM template overrides per trigger which is painful

May I ask a security/ permission question please ? I guess on Fabric notebooks, we are fully UPN SSO regarding permissions ? Permission to access Workspaces objects like Lakehouses & Power BI semantic model ( via semantic link library) fully SSO on interactive notebook sessions , but what happen on "batch" sessions , with data pipeline runs ? - Is it the notebook creator UPN (the owner) which is used on batch pipelines runs ? - What happen during Life cycle CDCD deployment pipeline ? Along side Workspaces - Do we need the notebook owner to be granted access on each environment WS ? - Sounds Microsoft works on a substitution UPN for pipelines runs Thanks a lot for any help

Thanks! This solves one of many problems I have right now. Also good to know, if you pass a boolean from a notebook you can not use True and False, but 1 and 0. In the Pipeline variables it will be set as true and false then.

Great video Bradley! Are you coming to the European Fabric Community Conference?

Inspiring! For a pseudo data scientist

what if i have a private db at rds mysql this method will be valid if i white list the subnet?

Thanks for the Demo. I investigated mirroring several months ago and saw disclaimers not to use this on production databases. Do you know if it is safe at this point?

Awesome video✨!! I have one question. After publishing, we get an endpoint, and you ran that endpoint in a Fabric notebook. Suppose I want to run the code outside the workspace, for example, in VS Code, but it's throwing an error for the synapse.ml.mlflow model. Is there any solution for this?

Beautiful views!

Amazing!!

Incredible!

What a beautiful view!!❤

This is amazing. I am actively looking for something to replace our current approach to simulate real-time data from on-perm SQL database to a storage account. This is a true solution in my opinion. Can’t wait to test it out. Thank yoi

Can I create folders within Lakehouse in a workspace ? Basically I want to create bronze/silver/gold in all my workspaces like dev/test/prod and create folder related to sales, product, customer, marketing, hr, finance etc. Then I can give access to users on logical folders

Hello, I appreciate your explanation thank you. Could I ask how to restore the SQL MI Database with the same name?

very simply put! thanks

how to pass the value of a fabric pipeline variable to a variable in Notebook ?

same request as the previous one. Can you share your TSQL script, with details on where to run each of the section?

I encountered the following error: "The database cannot be mirrored to Fabric due to below error: User does not have permission to mirror the database." How can resolve this issue?

Nice.What are the use cases of this ?

Thanks so much for doing this video! This will be my first time at Live 360 this fall. One question, what do most people typically wear to the conference? I've been to some where it was all business casual/professional and others like SpiceWorld or Ignite where people even wore shorts and t-shirts. Just don't want to be the odd one out when I go!

You guys ROCK

Where did you get that username and password from ??

To be precise, it only works on F64 and larger. The reason is to drive more revenue for the product if people want to use AI skill. To be fair, it make economic sense but not very friendly to SME though.

Please detail more how you added the API and parameterized it

Cool! Does this work with ADLS Gen2 configured as a shortcut in Fabric?

Very interessting, can you please provide tsql that you used in video ? I know it can be downloaded from Ola Hallengren but you did some changes to it and it would be much easier to get it from you. Thank you

How can Parameterize the database name in notebook from other notebook which use SparkSQL.

awesome vid, man! Thanks for the detailed information

I also still don't have the AI skills option. I have a paid subscription but I don't currently have the F64 or higher. Can anyone confirm whether this is why?

Great video! How were you able to get AI skills working in a Fabric trial capacity? I tried it myself and I'm able to setup an AI skill, but upon asking questions in the chat window I get a FT1 SKU Not Supported error

Very helpful video! Thanks so much, this really clears up some of my questions.

You just saved my day. Copied 5GB data within 1 minute :)