I have been playing around with the new Azure Synapse Analytics, and I realised that this is an excellent opportunity for people to move to Apache Spark. Synapse Analytics...
2021-01-18
7 reads
The next example is how to do a ROW_NUMBER(), my favourite window function.
T-SQL SELECT *, ROW_NUMBER() OVER(ORDER BY dateTime) as RowNumber FROM chicago.safety_data Spark SQL SELECT *, ROW_NUMBER() OVER(ORDER...
2021-01-18
8 reads
The next example is how to do a ROW_NUMBER(), my favourite window function.
T-SQL SELECT *, ROW_NUMBER() OVER(ORDER BY dateTime) as RowNumber FROM chicago.safety_data Spark SQL SELECT *, ROW_NUMBER() OVER(ORDER...
2021-01-18
50 reads
I have been playing around with the new Azure Synapse Analytics, and I realised that this is an excellent opportunity for people to move to Apache Spark. Synapse Analytics...
2021-01-18
48 reads
The next example is how to do a ROW_NUMBER(), my favourite window function.
T-SQL SELECT *, ROW_NUMBER() OVER(ORDER BY dateTime) as RowNumber FROM chicago.safety_data Spark SQL SELECT *, ROW_NUMBER() OVER(ORDER...
2021-01-18
425 reads
When I first started working with Apache Spark, one of the things I struggled with was that I would have some variable or data in my code that I...
2021-01-17
47 reads
When I first started working with Apache Spark, one of the things I struggled with was that I would have some variable or data in my code that I...
2021-01-17
9 reads
in my last post I wrote about thinking of the tools as being a separate thing from the event. Not a complicated concept, but does it matter? Maybe. Let...
2021-01-16
7 reads
I think our profession was the better for having a professional association, even if it never quite did as much as I wanted it to. I put a lot...
2021-01-16
179 reads
I think our profession was the better for having a professional association, even if it never quite did as much as I wanted it to. I put a lot...
2021-01-16
5 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Comments posted to this topic are about the item The New Wave of Security...
Comments posted to this topic are about the item There's Too Much to Learn
Comments posted to this topic are about the item How to Calculate Distance Between...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers