How to get data in a DataFrame via .NET for Apache Spark
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
53 reads
The End of PASS
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
15 reads
The End of PASS
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
186 reads
Platforms for Events
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
9 reads
Platforms for Events
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-28 (first published: 2021-01-16)
198 reads
Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop
There are a lot of hot phrases you’ve likely heard thrown around during various keynote sessions at conferences over the last 5 years. “Digital Transformation”,
2021-01-25 (first published: 2021-01-16)
640 reads
Two methods of deployment Azure Data Factory
Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes at scale. This post is NOT about what Azure Data Factory is, neither how to...
2021-01-15
15 reads
Two methods of deployment Azure Data Factory
Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes at scale. This post is NOT about what Azure Data Factory is, neither how to...
2021-03-25 (first published: 2021-01-15)
406 reads
Moving the Community Forward
Today is the last day that the PASS and SQL Saturday websites will be active. It’s possible that they will be shut down as this post gets published, and...
2021-01-15
40 reads
Daily Coping 15 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-15
17 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers