Microsoft Introduces SQL Server for Linux & Joined Linux Foundation 'Platinum Member'

The next version of SQL Server is now in public preview and available on Windows and Linux both. Linux has received SQL support for the first time ever.

According to Microsoft’s announcement on their official blog post,

SQL Server enables developers and organizations to build intelligent applications with industry-leading performance and security technologies using their preferred language and environment. With the next release of SQL Server, you can develop applications with SQL Server on Linux, Windows, Docker, or macOS (via Docker) and then deploy to Linux, Windows, or Docker, on-premises or in the cloud.

All of the native features of SQL Server available on Windows, in-memory online-transaction processing (OLTP), in-memory columnstores, Transparent Data Encryption, Always Encrypted, and Row-Level Security to name some.

Microsoft Joins Linux Foundation

Microsoft just joined the Linux Foundation as a high-paying Platinum member.Jim Zemlin, executive director of the Linux Foundation said,

"Microsoft is better able to collaborate with the open source community to deliver transformative mobile and cloud experiences to more people."

Google Joins .Net Foundation

The Redmond based company is becoming an advocate of open sourcing and will be committed to accepting community feedback and community contributions. Visual Studio for example went open source a year ago with .Net.

Google is also keen to have a portion of that pie and is officially becoming a member of the .Net foundation. There seems to be a pattern here with Microsoft going all in with Linux and sharing (almost) everything with it. Google had not been interested in .Net from the start and was in fact invested in Java, its competitor, with Android. With Oracle sueing Google over the use of Java in Android is is not strange to see the company is looking elsewhere. .Net is a major part of corporate development so Google joining hands with Microsoft on this front does not seem a crazy move.

The SQL server support for Linux is mostly to sway the audience from Oracle (Java again). SQL server is cheaper as well, and better support means that majority of corporate Linux users would go for SQL server instead.

Future iPhones Could Record, Fingerprints & Photos of Thieves

Apple is reportedly working on a new anti-theft measure which will record the fingerprints and snap photos of a phone-thief.

Patent filed by Apple

An application for a patent filed by Apple details this security mechanism. According to the patent, the mechanism will be incorporated in future iPhone and iPad devices. The patent details a trigger mechanism which will cause the phone to record the biometric information of whoever is using the phone at the triggered moment via the Touch ID button.

How it could work

These trigger conditions could be either when someone is trying to bypass the security of the phone or trying to gain unauthorized access to the phone via a third party device.

Information recorded by the phone can be either one or multiple fingerprints. It can also be one or more photographs of the thief, video recording of the thief, audio of the surrounding environment etc. The patent details:

The computing device may then provide the stored biometric information for identification of one or more unauthorized users

Of course, it’s not as easy as just setting up simple triggers in iOS and that’s that. There are some technical problems with implementing this system.

Problems with the system

Firstly, Touch ID requires you to press your finger several times on to the sensor for it to register it. The fingerprint sensor can only recognise a part of the fingerprint in one go. What’s more, you need to press your finger on it in multiple angles as well. The thief wouldn’t just press his finger on the home button repeatedly in an attempt to unlock the device.

This can be fixed in the future if Apple implements better fingerprint sensors and an improved Touch ID system. Next, a covert way of taking photos or recording video needs to be implemented. This won’t be much of a problem considering that there are already apps like Lookout which do that.

Legal and Privacy Issues

It also raises privacy and security concerns about the new system. If your iPhone can snap photos and record and save a thief’s fingerprints in the company’s database, it is recording yours as well. What’s there to say if the company stores your info on their servers as well?

Apple’s CEO Tim Cook has used the company’s record on privacy and its stance on not storing any unencrypted information to market Apple products and services. However, limitations in these new anti-theft measures means that these features wouldn’t make it into the iPhones and other igadgets any time soon