I tried writing a linear regression function in Transact-SQL once. It was a lot of code - some of it necessarily dynamic. With R it is a single function -...

If you are doing anything statistical then R is the one to go for.

Python is a general purpose programming language. BASIC isn't dead, it's just called Python nowadays ;-).

Tabs aren't recognized, here are the hierarchies again:

Customer

----Order

--------Order Line

-----------Product

Product Group

-----Product

JSON is just JSON, any system that parses JSON can parse JSON, be that SQL Server, powershell or any other tool you might be using.

JSON has the fundamental problem of...

JSON or XML are supposed to be versatile(unlike older mainframe type hierarchies) and capable of being transmitted and consumed by a broad range of systems. Where as relational databases are...

The issue isn't so much that SQL server can't parse and format json it's that the data is represented in fundamentally different ways.

In which case why bother with JSON? Isn't...

I could have a container running PostGres, another running Python 3.7 with a bunch of libraries, Python 3.9 with a different set of libraries and versions of those libraries, a...

It would be very helpful to have a clear definition of what the term "container" means.

What is the difference between a container and a virtual machine?

I was persuaded to enter...

The proponents I've seen for low code/no code encourages allowing the "citizen developer" to write low code/no code applications. They are the domain experts. They understand the problem. Under normal...

Some thoughts on the subject.

Axiomatic reuse. Software methods that apply to all possible applications. The relational model replaced every application needing to devise its own approach to data management.

Application derivation....

Chris Date - An Introduction to Database Systems - 8th Edition  - Chapter 21 Distributed Databases.

Published in 2004, but everything Date has to say about distributed DBMSs is just as...

What would I like to see in SQL Server in the future?

1. Assertions (in the SQL standard since SQL-92. Until now no one has implement them - I hear Oracle...

In the relational model all data is represented as attributes, within tuples within relations (columns, rows and tables in SQL speak). This means that all data manipulation can be achieved...

Or using powershell and regex

([regex]"(?im)--.*?$").replace(([regex]"(?s)\/\*.*?\*\/").replace($sql, ""), "")

The brand new go to technology in the NoSQL arena is TrumpDB.

The  same query in TrumpDB will always deliver a different answer.

TrumpDB is super...