TF-IDF in .NET for Apache Spark Using Spark ML
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine learning (ML) is awesome, so what could be better than using .NET to write ML...
2020-07-07
11 reads
Blog Posts
Upload files to ADLS Gen2
I discover a small new feature the other day, but a very useful one. Previously, there was no way to upload files to an ADLS Gen2 storage account via...
2020-07-07 (first published: 2020-06-22)
245 reads
Azure Data Engineer Associate
You can read about all the new role based qualifications from Microsoft here – https://www.microsoft.com/en-us/learning/certification-overview.aspx Today I want to talk about the Azure Data Engineer one from my experience...
2020-07-06
35 reads
Daily Coping 6 Jul 2020
I’ve 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...
2020-07-06
16 reads
Database Fundamentals #26: The Primary Key War
There is a war about primary keys in the database world. There are two camps. The first camp believes that primary keys should only ever be created on meaningful...
2020-07-06 (first published: 2020-06-22)
683 reads
Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...
2020-07-06 (first published: 2020-06-23)
2,547 reads
Daily Coping 3 Jul 2020
I’ve 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...
2020-07-03
11 reads
Open Letter to PASS
As you know, I spoke to 12 Chapter Leaders and 4 Regional Mentors yesterday. All are very upset with PASS right now and feel slighted, which as a volunteer...
2020-07-03 (first published: 2020-06-19)
264 reads
PASS – Meanderings
As most people reading this would know…the PASS organization is in a state of crisis now following the decision to go virtual. We are in a place where we...
2020-07-03 (first published: 2020-06-20)
190 reads
Social: Going Along to Get Along
It’s the eve of the Fourth of July, when the Declaration of Independence is celebrated in the US. I’ve always like this holiday, but lately I find myself less...
2020-07-03
17 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers