Explore tweets tagged as #SQLPool
Our favorite content for this week! 0105.More info: .#ladataplatform #usergroup #mysql #terraform #azuresql #sqlserver #partitioning #dacpac #serverless #sqlpool
0
1
2
Happy #FrogBlogFriday!🐸 📑 📆 . Today we have a new blog from Jeet - @@ROWCOUNT in Synapse Dedicated #SQLPool!🏊 . @@RowCount workaround below!.
0
0
0
If you are p[lanning using Json with #Fabric please vite for this ideas to support using JSON like we can in SqlPools and SqlDBEngine. I added a small repro that works on say SqlPool but not Fabric.
0
1
2
This week's make-up session - The power of Synapse SQL Pool session by Michelle Gutzait and Christian Cote on March 29, 2023 @ 7PM PST/UTC-8 .RSVP here: .#ladataplatform #synapse #sqlpool #etl
0
1
1
@AzureSupport So I have choose Lake Database not the SQL Database which is why I am unable to see SQLPool in Power BI setup and hence. Now I have to connect Lake database to Power BI.
1
0
0
Ready in few hours - The power of Synapse SQL Pool session by Michelle Gutzait and Christian Cote on March 29, 2023 @ 7PM PST/UTC-8 .RSVP here: .#ladataplatform #synapse #sqlpool #etl
0
0
0
1 day till the make-up session - The power of Synapse SQL Pool session by Michelle Gutzait and Christian Cote on March 29, 2023 @ 7PM PST/UTC-8 .RSVP here: .#ladataplatform #synapse #sqlpool #etl
0
0
0
Sooo, if you want to query XML in SqlPools. - SqlPools dont support XML but they do partially support OPENJSON.- ADF can auto convert XML to Json. So we end up loading XML as Json into a table order to query it in SqlPool. I hope #Syanpse team add OPENXML soon !.
0
0
5
Synapse SQL Pool session by @mgutzait and @Christian_SQL .#ladataplatform #mpvbuzz #synapse #sqlpool #sql #synapsepool #datawarehouse #lakehouse #datalake.
1
1
5
@joanalytics @askpriya Got a simplified repro below . This sample TSQL will create a uncommited tran/leak in FabricDW but will auto rollback in SqlPool (or SQLDB). Try it and check @@TRANCOUNT. BEGIN TRAN;.select * from table_that_doesnt_exist.IF @@TRANCOUNT > 1.COMMIT TRAN.
1
0
0