The API Battle

I think Oracle is a fine database platform, maybe too expensive, but it works. However, I'm not a fan of the company, and I find myself less enamored with them when I read about this case. This the Oracle v Google case, where Google is accused of violating copyright of Java APIs when it build Android.

Essentially Oracle claims that the Java API, the packages, classes, methods, etc. are copyrighted and cannot be used in any other product. I assume this means that if I implemented the Java.SQL class, writing the code in C#, I'd be infringing on Oracle's work.

Even if I offered my software for free, this could be legal violation and I'd owe Oracle money. Or I'd need to license the API from Oracle. Any guesses on whether that would be inexpensive or prohibitive?

In one sense, I do think that copyright and patent protection should exist. On the other hand, I think some of the applications of the original laws and ideas to the digital world don't translate well. I certainly think that APIs shouldn't be protected. These are essentially function names, and while I appreciate the need to copyright words, I don't think it should go this far.

I am hopeful that the Supreme Court will hear this case, and rule that this isn't a violation. As someone that works for a software company, and has written software designed to inter-operate with other products, I think this would cause lots of chaos in our industry. I also think we have enough silly licensing and limiting practices in software, and I'd prefer to see less, not more.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

Until now, organizations wanting to introduce database DevOps have had to rely on – and purchase – different tools and solutions for different databases. A new cross-platform database DevOps solution, Redgate Deploy, changes the rules. Find out why in this latest blog post.

Fully driverless technology is real, and now you c...

Busted: A bot powered by OpenAI’s powerful GPT-3 language model has been unmasked after a week of posting comments on Reddit. Under the username /u/thegentlemetre, the bot was interacting...

The release of GPT-3 has reinvigorated a discussion of creativity and artificial intelligence. That’s a good discussion to have, primarily because it forces us to think carefully about what...

When I talk about Plan Forcing I always discuss how users should ALTER procedures when using Query Store, and not use DROP and CREATE. This is valid beyond Plan...

No, No, not those dumps:  SQL Server Memory dumps...

This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a company which I had... The...

The CEIP Service is the Customer Experience Improvement Program that sends telemetry data back to Microsoft. When you install Microsoft SQL Server, the CEIP Service is installed too. You...

Words: 329 Time to read: ~ 2 minutes At this stage of my career with Transact-SQL, I would like to think that I have the language mostly mapped. If...

Well tuned storage is essential for SQL Server performance. In this article, Robert Sheldon explains the metrics that are important to watch. … The post Storage 101: Monitoring storage metrics...

Let’s say you had report queries that were going wildly parallel, and you wanted to put a stop to it, but you couldn’t afford SQL Server Enterprise Edition. You...

If you’re familiar with the topic of query foldi...

     There used to be two ways for Azure Cosmos DB to bill you for the services it provides. Those were Manual Provisioned throughput and Auto scale provisioned...

Delta Lake supports DML (data manipulation language) commands including `DELETE`, `UPDATE`, and `MERGE`. These commands simplify change data capture (CDC), audit and governance, and GDPR/CCPA workflows, among others. In this post, we will demonstrate how to use each of these DML commands, describe what Delta Lake is doing behind the scenes when you run one, and offer some performance tuning tips for each one.

I have spent many long weekends getting stuck into Azure Databricks, plenty of time to understand the core functionality from mounting storage, streaming data, knowing the delta lake and... The...

One of the benefits of cloud computing is flexibility and scale—I don’t need to procure hardware or licenses as you get new customers. This flexibility and platform as a...

It’s not too difficult to set up database mail for Azure SQL DB Managed Instance in comparison to SQL Server (on-prem or IaaS) however there are a few extra things to consider. This post will describe how to set up database mail for Azure SQL DB Managed Instance. I will use Sendgrid as the mail provider but you can follow the same steps for any other mail provider or your company’s smtp server.

The dedicated SQL pools in Azure Synapse Analytics (formerly, Azure SQL Data Warehouse) outperforms compared with other analytics database, such as, BigQuery, Redshift, and Snowflake in 3rd party’s benchmarking for Test-H and Test-DS* (see here).

With all the stuff going on around the world over the last year, maintaining some degree of mental stability can be quite a challenge. Speaking only for myself, while... The...

It’s just over 30 days to the 2020 PASS Summit a...

Our topic will be “Finding certainty in IT when the world is uncertain.”

Welcome to the SQLServerFast Execution Plan Video ...

Like so many events SQLBits 2020 was delivered from our homes… Training sessions and content delivered via webcam and recordings. Catching up with friends done via chat rooms and...

Flyway version 7.0 has just been released, and with it comes brand new features that enhance deployment flexibility. Version 7.0 also introduces Flyway Teams, which combines the Pro and Enterprise editions into one comprehensive offering. Join us on October 14th to find out more.

As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.

Click to learn more about author Ben Hartwig. The most revolutionary contributions to the modern world have been made by technology. Today, we cannot imagine a world without digitization...

  ...

So far in my "Multi-Tenancy with SQL Server" series, I've covered an introduction to multi-tenancy and approaches for implementing it with SQL Server. In an ideal world, we have a blank canvas to start from and a crystal ball to see into the future. We know everything about the system we're building, how many tenants we're going to have, what their data/access usage patterns look like, and there are no unforeseen changes to that information

Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of better...

"Rollbacks" are easily the most controversial topic in database DevOps. In this post, I share why there's no simple solution to the problem of rollbacks -- but how you...

In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.… The post Git anatomy appeared first on Simple Talk.

I’ve written about Data Integration Lifecycle Management (DILM) tiers. To summarize, every enterprise needs at least four lifecycle management tiers: 1. Development – an environment in which developers have...

You’ve set up the Azure Data Factory self-hosted integration runtime to access on-prem data sources. You create a linked server, click Test Connection, and then get greeted with an error saying the security context can’t be passed

(2020-Oct-05) Adding a row number to your dataset...

Sometimes when you’ve created a SSIS catalog, along with folders, environments and environment variables, you want this content on another server. Unfortunately, you can only script out these objects... The...

Florida voters have until 7pm on Tuesday to regist...

Preventing a catastrophic system failure before it happens -- what may sound like the plot line of a blockbuster action movie; is actually one of the most common and...

As a DBA, we have the opportunity & responsibi...

Today Western Digital is announcing a major expansion of their WD Black family of gaming-oriented storage products. In a digital event later today on Twitch, Western Digital will introduce...

AMD isn't letting up the pressure on Intel—Ryzen 9 5900X looks like a barn burner.

In 2018 Marvell announced the 88NR2241 Intelligent NVMe Switch: the first—and so far, only—NVMe hardware RAID controller of its kind. Now that chip has scored its first major (public)...

Most of them are office productivity models, but the UP3221Q is a beast.

Today we posted a news article about SK hynix’s new DDR5 memory modules for customers – 64 GB registered modules running at DDR5-4800, aimed at the preview systems that...

I had a requirement to take the overall target amount and split it for each month. But also, for it to be cumulative for each month going forward

Used To Love Her I used to think the plan cache w...

Paul White explains when a SQL Server sort operator inside a loop rewinds (replays) cached results to avoid re-executing plan operators. The post When Do SQL Server Sorts Rewind? appeared...

This blog post is part of my “Automating Power BI deployments” series, and you can find a list of the other posts here.

There are different interactions Power BI visuals ...

I had a requirement where the client wanted the ca...

Roses are red,Violets are blue,Community loves dba...

Have you wondered how to visualize graph data? No,...

This article and its companion video describe how to create a service principal account to be used with the Power BI API. The reader must already be familiar with...

Today I have learned how I can use and change the ...

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions. In this article, he exposes five functions that are popular in the calculation of loans and other annuities. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.

Azure Data Factory is a cloud based data orchestration tool that many ETL developers began using instead of SSIS. In this article, Rodney Landrum recalls a Data Factory project where he had to depend on another service, Azure Logic Apps, to fill in for some lacking functionality.

I am delivering more and more live streaming sessi...

Phil Factor's "getting started" guide for turning all your trusted and most frequently used queries into SQL code snippets. The post Creating a SQL Code Snippet in SQL Prompt and...

Phil Factor answers some questions you've been itching to ask about SQL Prompt, covering ranked code completion suggestions and auto-fixing SQL code smells, and suggesting where in the tool...

The Microsoft Azure-SSIS team released version 3.1...

Securing data is not always easy to do, but it should be the top responsibility for database administrators. From protecting the physical servers to preventing copies of backups files...

Hacker team led by 20-year-old finds 55 vulnerabilities, 11 of them critical.

Fortran has ruled scientific computing, but Julia ...

Options! When you’re writing code, you have some options when it comes to leaving comments: Double dashes at the start of a line: -- Comment! Block quotes around a section of text:...

The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.

“Life is too short to work at a company that you...

The Supreme Court could decide whether APIs can be...

As-yet unnamed “NewCo” will handle IBM’s “managed infrastructure services.”

My 14 year old got tired of paying $7.99 for Minec...

“It's like our Falcon 1 rocket.”

SpaceX has now launched 775 total Starlink satellites.

My love and appreciate for the new open-source Win...

A small blog post for anyone who stumbles across this issue (and for my future self, should I forget the solution). I was working on some tables in SSDT... The...

I remember when I first started deploying Big Data Clusters, they were on Azure Kubernetes Service utilizing the $200 credit for first time sign ups. By the time I got around to figuring out how to deploy the BDC, not only was my $200 credit gone, but I started to incur cost out of pocket.

I’ve had to do some work on PostgreSQL, and I wrote an article at SQLServerCentral about getting started. Once I had things working, and could connect from Azure Data... The...

In this article, Michael Sorens describes the many ways that you can monitor Kubernetes.… The post Checking the pulse of Kubernetes appeared first on Simple Talk.