Containers

Blogs

Synapse Analytics Spark Example 2 - ROW_NUMBER()

By

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

I have been playing around with the new Azure Synapse Analytics, and I realised...

Renaming Files by Padding Numbers with PowerShell

By

Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...

Read the latest Blogs

Forums

XML Load Error

By stricknyn

Hello everyone,  I'm attempting to connect to an xml file so I can later...

Date format - being overridden?

By NicHopper

Hi all, Got a strange one here that I hope someone can help with....

Best way to understand Querying much better

By pietlinden

What's the best way to get better at T-SQL Querying? Something like Read/do the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers