Rob Stebbens


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

The media family on device incorrectly formed for read only file group restore

By thostenor

Yes the databases (source and destination) are the same version.  I have checked 3...

The Time Zone Range

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Time Zone Range

Mathematicians and SQL

By Joe Celko

Comments posted to this topic are about the item Mathematicians and SQL

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers