Home Tags SQL

Tag: SQL

Azure SQL vCore vs DTU from Blog Posts – SQLServerCentral

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

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

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

0
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

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

0
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

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

0
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

0
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

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