Explore tweets tagged as #SQLPool
@LADataPlatform
LA Data Platform
2 years
Tweet media one
0
1
2
@PurpleFrogSys
Purple Frog Systems🐸
2 years
@@ROWCOUNT in Synapse Dedicated #SQLPool🚣. Alternative to the @@RowCount variable in #SQLServer💯 .
Tweet media one
0
0
0
@PurpleFrogSys
Purple Frog Systems🐸
2 years
Happy #FrogBlogFriday!🐸 📑 📆 . Today we have a new blog from Jeet - @@ROWCOUNT in Synapse Dedicated #SQLPool!🏊 . @@RowCount workaround below!.
Tweet media one
0
0
0
@bob_duffy
Bob Duffy
2 years
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
@PurpleFrogSys
Purple Frog Systems🐸
2 years
@@ROWCOUNT in #Synapse Dedicated #SQLPool. If you’ve been working with dedicated SQL pools in Synapse, you'll know @@RowCount is not supported. 😰 . WORKAROUND BELOW!⬇️ .
Tweet media one
0
0
0
@bob_duffy
Bob Duffy
2 years
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
@bob_duffy
Bob Duffy
2 years
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
@bob_duffy
Bob Duffy
2 years
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
@bob_duffy
Bob Duffy
2 years
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
@bob_duffy
Bob Duffy
1 year
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
@bob_duffy
Bob Duffy
1 year
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
@bob_duffy
Bob Duffy
2 years
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
@LADataPlatform
LA Data Platform
2 years
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
@manthan_ladva
Manthan Mitaben Ladva 🇮🇳
1 year
@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
@LADataPlatform
LA Data Platform
2 years
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
@LADataPlatform
LA Data Platform
2 years
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
@bob_duffy
Bob Duffy
2 years
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
@LADataPlatform
LA Data Platform
2 years
@SteveRezhener
Steve Rezhener
2 years
@LADataPlatform user group meeting just started!.#synapse #azure
1
1
5
@bob_duffy
Bob Duffy
2 years
@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