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
0
0
0
Happy #FrogBlogFriday!🐸 📑 📆 . Today we have a new blog from Jeet - @@ROWCOUNT in Synapse Dedicated #SQLPool!🏊 . @@RowCount workaround below!.
0
0
0
As promised. Sample code on GitHub to read from ASDL and write to SQL or Synapse SqlPool. This is using the latest DataLakeClient and Azure.Identy Classes in VS 2019.
0
1
11
if you are using HashBytes on Fabric, I noticed what may be a bug in that it returns data that is too short. Upvote if you use this . Try this example on say Fabric DW v SqlPool.SELECT len(HASHBYTES('MD5', 'a')).
1
1
2
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
Vote here to add SET XACT_ABORT ON|OFF to Fabric. Without this we can run into breaking Migration and behaviour changes between Fabric, SqlPool and SqlDBEngine.
0
1
3
Writing a c# Azure function to extract non standard CSV (1,000 pivoted column frankenstein) using SqlBulkCopy API and ASDL API. 144MB file times at 7 seconds to read and transform, 3.6 seconds to write to a basic DW100 SqlPool. Maybe should use ADF Copy less and more C#, lol. .
6
1
13
Cost for dedicated SqlPool at the low end are disgustingly cheap. I'm running a DW100 24x7 for a critical DW project and the monthly run cost of the SqlPool is only €78. The ADF cost is €250 a month and the GW+IR VMs only €60 a month. (we turn those off when not needed).
2
0
9
Im writing a blog article on what might "block" our customers migrating to Fabric from say sqlPool for DW workloads. I have these hard block.1. private network (keep data safe). and these on nice to have.1. identify.2. dns names for server (eg clearly label PRD!). Any more ?.
6
0
8
Dohh. Dedicated SqlPool shutdown in 20 mins and a big PowerBI refresh in progress,. This is like a nail biting horse race. Will someone in MSFT bring on a smarter auto pause to SqlPools. please. I swear I will never look at PS5 or snowflake if this happens as an incentive.
1
0
4
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