Synapse Analytics and .NET for Apache Spark Example 3 - CTE()
The next example is how to do a CTE (Common Table Expression). When creating the CTE I will also rename one of the columns from “dataType” to “x”.
T-SQL WITH...
2021-01-19
65 reads
Blog Posts
T-SQL query to find the list of objects referring Linked Servers
T-SQL query to find the list of objects referring Linked Servers
2021-01-19 (first published: 2021-01-13)
8,240 reads
Daily Coping 18 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-18
22 reads
Git in 10 commands to do 99% of gitting and keeping out of trouble
Git is hard, probably harder than it needs to be but I have been using it for about 5 years and have a workflow that works for me. I...
2021-01-18 (first published: 2021-01-12)
1,028 reads
How does Query Store capture cross database queries?
Query Store is a configuration that is enabled per database, and the plans and stats for queries executed in that database are stored in the database itself. So what...
2021-01-18 (first published: 2021-01-11)
474 reads
Power BI: Making Date & Time Keys
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 call out, if you...
2021-01-18
15 reads
Renaming Files by Padding Numbers with PowerShell
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 keeps getting away from me....
2021-01-18
201 reads
Synapse Analytics and .NET for Apache Spark Example 1 - Group By
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
Synapse Analytics and .NET for Apache Spark Example 1 - Group By
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
21 reads
Synapse Analytics and .NET for Apache Spark Example 2 - ROW_NUMBER()
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
9 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor Resmi BCA KCP Gorontalo Tlp:08218154393
WA:08218154393 Jl. Nani Wartabone No.293, Limba U I, Kota Sel., Kota Gorontalo, Gorontalo 96111
Alamat Kantor Resmi BCA KCP Ratulangi Tlp:08218154393
WA:08218154393 Jl. Dr. Sam Ratulangi No. 7, Kompleks Ratulangi Office Park Blok A3-A4, Kota...
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers