Tag: SQL
Azure SQL vCore vs DTU from Blog Posts – SQLServerCentral
If you are building database solutions in Azure , using Azure SQL Database then you will know that you have a purchasing option decision...
Synapse Analytics Spark Example 2 – ROW_NUMBER() from Blog Posts –...
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...
Synapse Analytics Spark Example 1 – Group By from Blog Posts...
I have been playing around with the new Azure Synapse Analytics, and I realised that this is an excellent opportunity for people to move...
Renaming Files by Padding Numbers with PowerShell from Blog Posts –...
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...
When do Statistics get updated? from Blog Posts – SQLServerCentral
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...
Power BI: Making Date & Time Keys from Blog Posts –...
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...
Daily Coping 18 Jan 2021 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
How to get data in a DataFrame via .NET for Apache...
When I first started working with Apache Spark, one of the things I struggled with was that I would have some variable or data...
The End of PASS from Blog Posts – SQLServerCentral
I think our profession was the better for having a professional association, even if it never quite did as much as I wanted it...
Platforms for Events from Blog Posts – SQLServerCentral
in my last post I wrote about thinking of the tools as being a separate thing from the event. Not a complicated concept,...