Helpful content! One added note on the Azure SQL DB mirroring with the 100 DTUs: That's only if you use the DTU licensing model. If you use the V-Core licensing model, all sizes are supported for mirroring (according to documentation, I haven't confirmed it yet).
when I run the command EXEC sys.sp_change_feed_disable_db, I get the following error message "Msg 22729, Level 16, State 1, Procedure sys.sp_synapse_link_disable_db_internal, Line 426 [Batch Start Line 5] Could not remove the metadata. The failure occurred when executing the command 'sp_synapse_link_drop_topic_internal'. The error/state returned was 137/1: 'Must declare the scalar variable "@tablecount".'. Use the action and error to determine the cause of the failure and resubmit the request."
Patrick, do you know when temporal tables in Azure SQL will be supported? There was no news on this limitation in the recent announcements, or anywhere else that I could find.
Great and interesting video. Anyone know if the ability to have only one Azure SQL database mirror per workspace will persist? Or, will we eventually be able to mirror multiple databases in a workspace?
Hai @Patrick I was googling and searching all youtube channels I can't see one tutorial connecting Power BI to IMB TM1 is it possible to connect any customer connector we can build & we can run data direct query please help us 🙏🏻🙏🏻🙏🏻🙏🏻
Helpful content! One added note on the Azure SQL DB mirroring with the 100 DTUs: That's only if you use the DTU licensing model. If you use the V-Core licensing model, all sizes are supported for mirroring (according to documentation, I haven't confirmed it yet).
I can confirm that for some V-Core sizes this works, but not all of them. Definitely worth checking specially for small databases with low usage.
when I run the command EXEC sys.sp_change_feed_disable_db, I get the following error message "Msg 22729, Level 16, State 1, Procedure sys.sp_synapse_link_disable_db_internal, Line 426 [Batch Start Line 5]
Could not remove the metadata. The failure occurred when executing the command 'sp_synapse_link_drop_topic_internal'. The error/state returned was 137/1: 'Must declare the scalar variable "@tablecount".'. Use the action and error to determine the cause of the failure and resubmit the request."
Is it possible to create mirror between Synapse dedicated pool and Fabric warehouse?
Patrick, do you know when temporal tables in Azure SQL will be supported? There was no news on this limitation in the recent announcements, or anywhere else that I could find.
Great and interesting video. Anyone know if the ability to have only one Azure SQL database mirror per workspace will persist? Or, will we eventually be able to mirror multiple databases in a workspace?
Great video
Hai @Patrick
I was googling and searching all youtube channels I can't see one tutorial connecting Power BI to IMB TM1 is it possible to connect any customer connector we can build &
we can run data direct query
please help us 🙏🏻🙏🏻🙏🏻🙏🏻
Primary keys! Once you have all that, you do need to prep your tables and the biggest issue is the need for an index.
We read. RTFM