Tag: SQL

If you are building database solutions in Azure , using Azure SQL Database then you will know that you have a purchasing option decision...

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...

I have been playing around with the new Azure Synapse Analytics, and I realised that this is an excellent opportunity for people to move...

Some time ago I had downloaded all the SQL Saturday XML files. I’ve been meaning to flatten those into a database, but that project...

Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful...

Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be done with built in functions in the Power Query editor. Quick...

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...

When I first started working with Apache Spark, one of the things I struggled with was that I would have some variable or data...

I think our profession was the better for having a professional association, even if it never quite did as much as I wanted it...

in my last post I wrote about thinking of the tools as being a separate thing from the event. Not a complicated concept,...