Жыл бұрын
Жыл бұрын
3 жыл бұрын
3 жыл бұрын
4 жыл бұрын
4 жыл бұрын
4 жыл бұрын
4 жыл бұрын
4 жыл бұрын
4 жыл бұрын
4 жыл бұрын
Пікірлер
@indrayne1840 Ай бұрын
What if we have many nested folders inside document drive and we want to copy all files to our azure data lake storage using ADF and maintaining the same hierarchy there also.
@pdsqsql1493 Ай бұрын
Very nice in detailed explained presentation!!! If we once migrate then for actual cutover we can overwrite it?
@user-jh8vn4my9m 3 ай бұрын
Thank you! Super helpful!
@Balamurugan-df4qw 3 ай бұрын
How to raise the mail alert if error occurs in the source table structure is changed
@94089463 4 ай бұрын
Thank you so much for this practical explanation. Question: How do your open Azure windows side by side? That's very useful.
@mquinnusa 5 ай бұрын
This is great. Thank you so much. 😃
@SQLTalk 5 ай бұрын
Thank you @mquinnusa!
@aamirghanchi9487 6 ай бұрын
Thank you for the great video! How is Syncing different from Replication?
@SQLTalk 6 ай бұрын
This sync is based on SQL Server triggers and not ideal for large workloads. Transactional Replication is for larger databases and tables and is based on an initial Bulk Copy (BCP) for the snapshot load and then on stored procedures to keep the tables up to date.
@stephenkemp4809 6 ай бұрын
You've just earned a subscriber. Thank you so much for taking the time to explain this.
@SQLTalk 6 ай бұрын
Glad the video was helpful. Thank you very much for your comment.
@MuhammadWaqas-gr4gg 6 ай бұрын
why didnt you install Ms Integration Runtime here?
@SQLTalk 6 ай бұрын
I didn't install the Integration Runtime on this one since my SQL Server backup files were located in an Azure storage account. See minute 11:25. Thank you for your comment.
@MuhammadWaqas-gr4gg 6 ай бұрын
Hi, in your another video, where destination DB was Azure MI....you didnt install Ms Integration Runtime and here you install that. May i know the reason? and whats its use and benefit?
@SQLTalk 6 ай бұрын
Thanks for the comment. In this video I had my backups on the network share so I needed the Integration Runtime (IR). In the other video I most likely had the backups on an Azure storage account, so I didn't need the Integration Runtime. Thanks!
@VishalSharma-lz6ky 8 ай бұрын
thanks great information
@SQLTalk 8 ай бұрын
Thank you!
@user-dr8qj3ky1z 9 ай бұрын
Thank you, very helpful!
@SQLTalk 9 ай бұрын
Thank you for watching!
@vgwarelearning4057 10 ай бұрын
0:45 i am wondering how you added Power Automate @kirby's Sql talk
@nicholaskipkoechbett8955 11 ай бұрын
the sync agent is intall on on-premise server or we install on azure server?
@SQLTalk 11 ай бұрын
Yes sir! The agent should be installed on the on-prem or cloud VM or bare metal SQL instance.
@aneternall 11 ай бұрын
6 years later and it's non-intuitive that the dataset is created at the beginning of creating a PowerBI report and nowhere else. I don't see options for adding existing SQL tables to a dataset in paginated reports. Anyway, I watched 10+ other videos and this is the only one that actually showed BOTH creating the gateway AND creating a report. That was very helpful so thank you.
@SQLTalk 11 ай бұрын
I am so glad this helped in some way @jgrnht. Thank you for commenting.
@sebainones Жыл бұрын
Great video, a lot of good insights provided. How would you for instance monitor the peak use, discriminated by hours, so I could potentially know that from a certain time range when the DB has more load?
@paraglideheavenuwe7104 Жыл бұрын
Thanks for the video, but, my IoT DevKit is not able to Registering..., show „retry 1, retry 2, retry ...; any idea?
@matthosini9656 11 ай бұрын
Hi mate, could you work it out? I have the same issue.
@shreyaskulkarni720 Жыл бұрын
Can We auto trigger using ADF, whenever the file is updated ?
@kannar6189 Жыл бұрын
Can we migrate to azure SQL managed instance? can I have the steps please if you have?
@SQLTalk Жыл бұрын
Yes, Azure Data Studio allows you to migrate to SQL VM, Azure SQL DB and SQL Managed Instance.
@vigneshshangar1742 Жыл бұрын
Thank you!
@alleveddet118 Жыл бұрын
Thank you..I will note my self this channel...
@aniketangadi Жыл бұрын
how to send the same post request using ADF web activity
@rchenilath Жыл бұрын
Great video - very easy to understand for beginners. Many thanks for sharing this video.
@sarathkumaras Жыл бұрын
Can we able to use "subscribe" at the root management scope sir? Kindly help
@markcuello5 Жыл бұрын
HELP
@filibertogarced Жыл бұрын
Thank you for the tutorial. Great information!
@SQLTalk Жыл бұрын
Thank you very much for watching.
@karthikkannan8206 Жыл бұрын
Hey, This is great but I am wondering how do I achieve other way around ( ADLS/Blob Storage to Sharepoint )
@Vermitude Жыл бұрын
I have been trying to understand what tools to use for single database versus a database estate and this has been perfect in providing me with that insight. Great demo!! Thank you
@SQLTalk Жыл бұрын
So glad it helped Rebecca.
@dmdatamanagement Жыл бұрын
Thank for sharing... It really helps....
@Finezzato Жыл бұрын
thanks for sharing
@markjordan548 Жыл бұрын
I am a big fan of CDC in ADF it has been a great advancement
@ibexy Жыл бұрын
The backup to url sopped working. Keeps returning error 400.
@MuhammadWaqas-gr4gg Жыл бұрын
One question strikes me, What if we use DMA for Assessment and DMS for Migration/cutover......So what would be better migration.........Data Studio with DMS or DMA with DMS?????Any points...
@SQLTalk Жыл бұрын
DMS should be used if your destination is Azure SQL DB. ADS supports Azure SQL MI and SQL VM's as a target and is the preferred method. I assume that Azure SQL DB as a target option will be added to ADS. The ADS migration you set up will show up in DMS (think of it as DMS v2) and you can monitor all your ADS migrations centrally in Azure DMS. DMA UI and command line can still be used but it doesn't have the SKU recommendation feature.
@MuhammadWaqas-gr4gg Жыл бұрын
@@SQLTalk Brother i have checked in Azure Migrate as well as in DMS, Target DB can also be Azure MI apart from Azure SQL...
@SQLTalk Жыл бұрын
@@MuhammadWaqas-gr4gg correct Azure Migrate supports all three target types, Azure SQL DB, SQL MI and SQL on a VM. However, if your target is not going to be Azure SQL DB then you may prefer the experience of Azure Data Studio (ADS) with SQL Migration Extension. You can do everything from ADS, assess the source for compatibility with Azure SQL, get a sku recommendation for Azure SQL and do the on or offline migration.
@MuhammadWaqas-gr4gg Жыл бұрын
@@SQLTalk Agreed brother....Its better to go for ADS then...thanks.
@rameshchandran4854 Жыл бұрын
Thank you so much. It really helps.
@georgeollis Жыл бұрын
Great demo! What headset are you using?
@SQLTalk Жыл бұрын
Thank you. Surprisingly the headset was only $23 from Amazon. I think the brand is XAPROO. These sound better than the $260 cordless ones I have. Thank you for watching and commenting.
@MuhammadWaqas-gr4gg Жыл бұрын
Hello, nice video...So we will also need VPN connection for this setup???? Secondly Data Studio will be installed on every on-premise SQL Server???? What if the SQL servers/DBs are in VMware setup????Same method will be applied???? PLz reply.
@SQLTalk Жыл бұрын
If the destination DB doesn't have a public IP you will at least need a Point to site VPN. Azure Data Studio does not have to be installed on any SQL Server. You can run it from your client or maybe a central server in your destination environment. Yes, you can use ADS to point to SQL on VMWare. For migrating many SQL Servers on VMware you may want to use Azure Migrate.
@MuhammadWaqas-gr4gg Жыл бұрын
@@SQLTalk Still not clear suppose if i have to migrate 50 servers with 100 DBs then what would be the scenario????How many Azure SQL MI will be required??? 1 or 50??? or depends on Service tier??? am confused....
@SQLTalk Жыл бұрын
@@MuhammadWaqas-gr4gg SQL MI will currently support 100 databases per MI.
@MuhammadWaqas-gr4gg Жыл бұрын
@@SQLTalk Wow Thanks brother so it means we can only access a single server having multiple DBs with ADS in a single migration event???? But for every SQL SERVER we need seperate ADS migration operation???
@MuhammadWaqas-gr4gg Жыл бұрын
@@SQLTalk But also we cannot access/connect multiple SQL servers with ADS in one migration go??? one more question, can we migrate DBs from multiple SQL servers to Azure MI in ADS???
@xdaniel3936 Жыл бұрын
Thanks for the great topic. It would be appreciated if you could help me with the following question: Is it possible to create a pipeline that Azure Data Factory scan parse the PDF file stored in Azure Blob Storage, and send the parse result (text content) to the Elasticsearch on Azure? Also, I searched and did not find, for parsing PDF files, doe Azure Data Factory support OCR? Thanks
@rakshitashetty7461 Жыл бұрын
can we extract key words from a text using azure ML studio?
@WDF005 2 жыл бұрын
Hi how to move all files inside a folder in SharePoint?how to create relative URL?
@maximpobihun5469 2 жыл бұрын
I can't find the connections
@NasimaKhatun-jb7qo 2 жыл бұрын
Hi I am interested in metadata copy activity as well. Can you explain that as well
@CTBell-uy7ri 2 жыл бұрын
Please no music on future videos. It's painful for educatioanal stuff.
@SQLTalk 2 жыл бұрын
Thanks for the input.
@andrewangeles2932 2 жыл бұрын
This is a great intro, but how would we extend this to download multiple files from a SharePoint document library. Specifically, if we have a document library with a mixture of file types and names, and we only want retrieve all .CSV with name format of YYYY-MM-DD.csv.
@oscarromero8763 2 жыл бұрын
Really helpful, Thanks a lot. You saved me tons of time!
@SQLTalk 2 жыл бұрын
So glad it helped Oscar.
@dellahidah5860 2 жыл бұрын
how to know the name of the server of my gateway
@SQLTalk 2 жыл бұрын
Go to your datasets in PowerBI.com and then pick Settings. Under settings you should see a section for Gateway Connection.
@simplifylife3227 2 жыл бұрын
Hi, my migration is not working because I get Azure target sql vm is unavailable. I have checked in portal the sqlvm is in running state. Please help what I can do
@SQLTalk 2 жыл бұрын
Double check that you picked the right subscription, location (region) and resource group.
@rikudouensof 2 жыл бұрын
Quick and concise
@jeffz7310 2 жыл бұрын
Love this video, is there any clearer version by any chance? It has been very blurry for me the whole time. Thx
@SQLTalk 2 жыл бұрын
Yes. Go to the settings menu at the bottom right of video and you should be able to change to 1080 HD. Thanks!
@treemanzoneskullyajan711 2 жыл бұрын
Can I download this for free total curious newb
@SQLTalk 2 жыл бұрын
Yes you can and there is nothing to download since it's in Azure cloud. Look here for free subscription options. azure.microsoft.com/en-us/free/search/?OCID=AID2200277_SEM_2926ada25910199591fbcf2dbfbd3668:G:s&ef_id=2926ada25910199591fbcf2dbfbd3668:G:s&msclkid=2926ada25910199591fbcf2dbfbd3668
@guruprasaddangre7603 2 жыл бұрын
Very nicely explained, Thank you very much!