Neil Palmer @ShuffleMove

Doing big data for the UK's favourite radio station(s). Working with Microsoft Azure Data Warehouse, Azure Data Factory, Azure Data Lake and Power BI unremarkable.tech Reading, England Joined June 2017

Tweets

354
Followers

95
Following

506
Likes

429

Neil Palmer @ShuffleMove

4 years ago

@Nick_Craver It may be coincidence, as I don't believe anything has materially changed yet. However I've seen a big increase in the number of porn bots trying to follow me.

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

4 years ago

@Bust_McNutty @DreamlikeMelody It looks like a Kouign Amann.

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

4 years ago

@hmv666 @ush1c Rocks!? You were lucky. We only had smoke signals and we were glad of it.

0 0 3 0 0

View Details

Neil Palmer @ShuffleMove

4 years ago

@maartenballiauw It's simple. Work for a Swdish company. It's Yee-rah.

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

4 years ago

@greglow There are plenty of people using SSRS/Cognos/Whatever to generate documents, and they are the perfect tool for that job. Too much assumption that Power BI is a complete replacement for these tools, it isn't.

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

5 years ago

@Ko_Ver wrong with There is nothing Middle endian

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

5 years ago

Does anybody have a preferred method for generating json from an azure synapse/sql pool/dw instance? Polybase doesnt natively. Adf looks painful. Maybe spark? #sqlhelp

1 0 1 0 0

View Details

Neil Palmer @ShuffleMove

5 years ago

Best platform/tool to generate json files from synapse? Sadly polybase doesnt support it #sqlhelp

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

5 years ago

@Ko_Ver @BrentO @AndreKamman But it's the future 😂

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

5 years ago

@Ryazame @Ko_Ver @AzDataFactory That explains why synapse can't write a json file 😂

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

6 years ago

Can you guess what it is yet? #SQL #Azure

0 1 2 0 0

View Details

Neil Palmer @ShuffleMove

6 years ago

@NTouailat @azure_as Also disable hierarchies where you can if you dont need MDX compatibility

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

8 years ago

Azure analysis services non shrinkable memory is up in the 40Gb kind of area. Does anyone know how to shrink this back down, that feels excessive #sqlhelp #ssas @Azure_AS

3 0 0 0 0

View Details

Neil Palmer @ShuffleMove

6 years ago

@NTouailat @azure_as My suspicion is that it was caused by badly structured segments. However I couldn'tprove it and MS support didn't really know. Do you have a lot of highly unique large strings? Try to get your fact table to be as long and narrow as possible, see if that helps.

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

6 years ago

Feeling stupid because I cant find it - what's the set disjoint operator in SQL server? There must be an easier way than full outer join? #sqlhelp #SQLServer

1 0 0 0 0

View Details

Neil Palmer @ShuffleMove

7 years ago

@JeffWBrown @Seanwatson3 I hadn't spotted that, thank you!!!

0 0 1 0 0

View Details

Neil Palmer @ShuffleMove

7 years ago

@JeffWBrown @Seanwatson3 ha, I'm finding it really inconvenient. I frequently switch between pinned resource types and now I have to click to open the menu every time! It would have been great to at least have the option to pin it if you want to

0 0 0 0 0

View Details

Neil Palmer @ShuffleMove

7 years ago

Does anybody know how to update a PowerBI data source via the API? The DatasetID returned from Get-PowerBIDataset results in a 404 stackoverflow.com/questions/5851… #powerbi #sqlhelp