Should You Learn R or Python?
Both Python and R have become very popular languages in the last few years, especially among data professionals. Which should you learn or use? Steve has a few thoughts.
2021-05-21
408 reads
Python
2021-05-12
480 reads
2021-04-28
476 reads
2021-04-21
414 reads
2021-04-07
446 reads
2021-03-24
153 reads
Comparing Two Geospatial Series with Python
Learn how to use Python and pandas to compare two series of geospatial data and find the matches.
2021-03-23
5,341 reads
2021-03-10
375 reads
Reading a Specific File from an S3 bucket Using Python
This article shows how you can read data from a file in S3 using Python to process the list of files and get the data.
2021-03-09
99,125 reads
2021-02-24
448 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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...
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