2021-01-02
65 reads
Community
The Wide Impact of PASS
An organization, or an event, is more than just the name and structure. It's mostly the people.
2020-11-21
131 reads
Blogs
Synapse Analytics Spark Example 2 - ROW_NUMBER()
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
Synapse Analytics Spark Example 1 - Group By
By Ed Elliott
I have been playing around with the new Azure Synapse Analytics, and I realised...
Renaming Files by Padding Numbers with PowerShell
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
Forums
Azure Data Factory Copy Data UpSert with Delete
Hi, I'm having some problems with several Data Factory Copy Data jobs using stored...
XML Load Error
Hello everyone, I'm attempting to connect to an xml file so I can later...
Date format - being overridden?
Hi all, Got a strange one here that I hope someone can help with....
Ask SSC