Thank you so much for putting this together! My final project for one of my classes is to build a data pipeline and this made way more sense than any of the microsoft learn articles did. You did an amazing job, please continue making videos!!! :)
Hi BeardedDev, Many thanks for this video. It's my first one, I'm only starting with Azure multiverse - via your videos. I see some difference in the functions available nowadays, I guess they have changed in the last couple of years... Most of it is not so important, of course. However, I did get desperately stuck at the step of authentication when connecting to SQL server on my SSMS [Error 18456]. After trying all possible trouble-shooting hints all over the internet, I (purely accidentally) discovered that my authentication method shuld be 'Entra MFI'. I was logged into my Azure account with my usual Microsoft account credentials...probably for that reason [how bad is this idea, btw?]. As far, as I understand, this whole Entra thing is new and slightly differs from the previous options. This might be worse some update on this video in the future or might be just useful info for some other viewers. 🙃 Once I overcame my authentication challenge, the rest went very smoothely - cause your video is really good! Thank you!!!
Hi, a lot does change now at rapid pace in the cloud, UIs can change quite frequently. Entra used to be Active Directory, that's always best practice, the reason I use SQL Server Authentication which is still supported is because I'm working on a personal subscription, I don't have Entra setup but great call its something I should call out. Great work on starting with Azure, it's lots of fun.
is there a way to set the username and password of the sql server through the azure sql ui ? and then just use those credentials to login through data factory without using sql server manager ?
As far as I know can set only set Server Admin or Active Directory Admin when creating but you wouldn't want to use these. Don't have to use SSMS, can do it on the Azure portal on query editor, although I haven't tried this or Azure Data Studio or PowerShell.
@@BeardedDevData I was thinking maybe if my transform in the pipeline is a python script i can use the mysql.connector to connect to the database through the script and query it but i am not sure if it will work but by my logic it should. you have any thoughts ?
That sounds fine as your describing it, as you will be connecting to the database through the connector, Data Factory doesn't need to have access, it's only role would be to execute the script, let me know how it goes.
Please Upload more videos regarding Azure and Data Engineering tasks
Hi Abdul, many more coming over the next couple of weeks.
Thank you so much for putting this together! My final project for one of my classes is to build a data pipeline and this made way more sense than any of the microsoft learn articles did. You did an amazing job, please continue making videos!!! :)
Thanks so much, that means a lot, I do plan to return soon, early next year at the latest.
Hi BeardedDev,
Many thanks for this video. It's my first one, I'm only starting with Azure multiverse - via your videos.
I see some difference in the functions available nowadays, I guess they have changed in the last couple of years...
Most of it is not so important, of course.
However, I did get desperately stuck at the step of authentication when connecting to SQL server on my SSMS [Error 18456].
After trying all possible trouble-shooting hints all over the internet, I (purely accidentally) discovered that my authentication method shuld be 'Entra MFI'.
I was logged into my Azure account with my usual Microsoft account credentials...probably for that reason [how bad is this idea, btw?].
As far, as I understand, this whole Entra thing is new and slightly differs from the previous options.
This might be worse some update on this video in the future or might be just useful info for some other viewers. 🙃
Once I overcame my authentication challenge, the rest went very smoothely - cause your video is really good! Thank you!!!
Hi, a lot does change now at rapid pace in the cloud, UIs can change quite frequently. Entra used to be Active Directory, that's always best practice, the reason I use SQL Server Authentication which is still supported is because I'm working on a personal subscription, I don't have Entra setup but great call its something I should call out. Great work on starting with Azure, it's lots of fun.
Very interesting topic! Would love to know more about data pipelines. Is there a way to reach out if we have a career specific question? Thanks!
Sure, you can contact me at askbeardeddev@gmail.com.
is there a way to set the username and password of the sql server through the azure sql ui ? and then just use those credentials to login through data factory without using sql server manager ?
As far as I know can set only set Server Admin or Active Directory Admin when creating but you wouldn't want to use these. Don't have to use SSMS, can do it on the Azure portal on query editor, although I haven't tried this or Azure Data Studio or PowerShell.
@@BeardedDevData I was thinking maybe if my transform in the pipeline is a python script i can use the mysql.connector to connect to the database through the script and query it but i am not sure if it will work but by my logic it should. you have any thoughts ?
That sounds fine as your describing it, as you will be connecting to the database through the connector, Data Factory doesn't need to have access, it's only role would be to execute the script, let me know how it goes.
@@BeardedDevData
You mention PowerShell. Do you have any videos on that topic?
مفهمتش برايماري كي