Summary While the speculation machine for the mysterious Microsoft hardware event shot up (although it was still a simple wave compared to the jets of everything related to Apple), the Redmond gang continued to work hard . These are some of the stories you may have missed.
Azure Data Studio gets the SQLCMD mode
Azure Data (formerly SQL Operations) Studio took a substantial step in usability bets last week when engineers added the SQL Server command line (SQLCMD Mode).
The movement is significant for Microsoft as the team seeks to reward the fingers of the SQL Server Management Studio DBAs by bringing the key features one by one. Azure Data Studio is the company's launch in a cross-platform, cross-platform local and cloud database on Windows, macOS and Linux.
An exhaustive list of changes for version 1.11 can be found on GitHub, but it is the arrival of SQLCMD that caught our attention, bringing with it the ability to write and edit queries as SQLCMD scripts and then execute them in the editor.
Other useful improvements include performance bumps for Notebooks and Query Editor Boost, an extension that allows administrators to do things that really should be in the editor, such as saving query fragments, using query templates and changing databases using a hot key
Just don't switch to that production database when
TRUNCATE the script is loaded, okay?
Azure becomes big in Germany
Microsoft opened some new regions of cloud data centers for Germany last week. The lucky residents of Deutschland are now blessed with Central West Germany (located in Frankfurt) and North Germany (located in Berlin) to accelerate connectivity and deal with that important issue of data residence.
The regions enjoy compliance with Germany – specific regulations and, according to Microsoft, "will eliminate the barriers for companies in the country to benefit from the latest solutions such as containers, IoT and AI."
At the same time, channel all those euros in the direction of giant Windows.
In addition to Deutsche Bank and Deutsche Telecom, Microsoft also highlighted SAP, which intends to mix Azure and SAP HANA Enterprise Cloud to attract customers that complete German experience.
Microsoft Cloud Backup for Authenticator comes to Android
The Microsoft Authenticator application for Android gained the ability to backup and restore credentials to and from the Microsoft cloud. The feature, which is available for versions 6.6.0 and later of the application, saves credentials with the user's personal Microsoft account and can then retrieve them when they move to a new device.
We tried and we can confirm that it works as promised. Those worried about all that data that can potentially be taken need not be too worried. After all, you need a personal Microsoft account to use it, and those who feel a little nervous are unlikely to have something like that.
Those who expect the functionality to work with their Microsoft work accounts have to wait a little longer, as the company admitted that "there were no immediate plans" to take the murky technology beyond the personal world, thanks to the problems that could arise in the Application Protection Policy.
PHP drivers for SQL Server give and take away
Microsoft issued a Driver Preview for PHP for SQL Server, in version 5.7 last week. Notable changes were the arrival of support for PHP 7.4 RC 1, Ubuntu 19.04 and Debian 10 and the fall of support for Ubuntu 18.10.
Which is quite fair. The latest version of Ubuntu LTS, 18.04, has a few years of maintenance ahead. 18.10 was simply a provisional version.
The preview also deals with memory leaks detected by PHP 7.4 beta 1, as well as resolves memory problems with data classification structures and handles UTF-8 names in the connection string without throwing misleading error messages.  Hi Pluto! Let's write an operating system!
The news reached Vulture Central last week of an "innovation partnership" between Microsoft and Walt Disney Studios to create, produce and distribute content using the Azure cloud of the Windows giant.
Far from us describes some of the test practices that lurk in the bowels of Redmond as a "Mickey Mouse".
Windows 10 is not mentioned, since it is Azure's storage and network capabilities that have caught the attention of House of Mouse. and the studioLAB team while seeking to accelerate the movement of "scene to screen" content.
Disney's chief executive, Bob Iger, resigned from Apple's board on the day of the announcement (well, he actually resigned on September 10, but Apple did not announce it until 13).
Iger's departure is unlikely to be related to Microsoft's agreement for anything other than a coincidence. With Apple's announcement of the cost of its TV + broadcast service before the launch of Disney +, Iger's seat should be less and less comfortable.
SMB 1 – must work harder
Finally, Microsoft program manager Ned Pyle, terror of the Server Message Block, shared some telemetry last week to cheer up the progress made to end the Swiss-cheese protocol .
12% of all Windows 10 outgoing SMB client connections are SMB1, and if you only look at Enterprise Edition, it drops to 6%. That is a great improvement, give yourself a round of applause.
NOW BETTER STILL https://t.co/fIbxlEgkao
– Ned Pyle (@NerdPyle) September 10, 2019
As a reminder, it has been shown that the decades-old network protocol is terribly insecure, with tools released that can pass through it like a hot knife through the butter. Despite repeatedly patching it, Microsoft and others would prefer that customers simply switch to something designed for more modern times.
Of course, there are many network devices that use outdated technology, many of which have long since abandoned support.
However, the figures give hope that the message (or the default shutdown of the thing) is having the desired effect. We anticipate that the next obsolete technology is at the receiving end of Pyle's anger. ®