3 ms·
A little background info: For the last couple of decades, Microsoft SQL Server only ran on Windows. Microsoft aspires to take licensing money from shops that
by BrentOzar 6y ago
A little background info:
For the last couple of decades, Microsoft SQL Server only ran on Windows.
Microsoft aspires to take licensing money from shops that run Oracle (which is much more expensive), and those shops often prefer to run Linux on their servers. To help win over those customers, they needed to run SQL Server on Linux.
Drawbridge is the layer that enables that to happen.
There hasn't been a lot of public material about it, and SQL Server on Linux didn't get much of an adoption rate, so there hasn't been much incentive for the community to dig into it, either.
Adoption's probably going up on developer workstations now that SQL Server runs in containers and now that Microsoft's put a lot of work into Azure Data Studio, a database development tool that runs on Linux & Mac & Windows.
- hu3 6y agoI for one hope that Azure Data Studio becomes the VSCode of SQL Editors and supports more database servers. The plugability is there. And contributors have been working on that as well.
- BrentOzar 6y ago> I for one hope that Azure Data Studio becomes the VSCode of SQL Editors and supports more database servers. It already supports MySQL, PostgreSQL, and Microsoft SQL Server.
- hu3 6y agoCool! How do I enable MySQL support? This issue led me to believe it's not implemented yet: https://github.com/Microsoft/azuredatastudio/issues/4904 https://github.com/Microsoft/azuredatastudio/issues/4904 And search for MySQL or MariaDB on extensions marketplace gives me zero results.
- plasma 6y agoRegarding licensing, I’ve wondered why AWS RDS for SQL server is more expensive than Oracle RDS (this surprised me). Any ideas why that is?
- DaiPlusPlus 6y agoI assume because AWS has to run SQL Server on real Windows machines and Amazon couldn't negotiate a good licensing rate from MS.
- WorldMaker 6y agoThat's what AWS claims. Supposedly you can reduce SQL Server costs on AWS with bring your own license (BYOL) deals with Microsoft. On the other side too: Oracle has been extremely vocally defensive against Azure (it's a giant competitor with nearly as good a salesforce, and it's a possible slippery slope to companies finding out Microsoft Dynamics offers a lot of direct competitors to the corporate management dog and pony shows that gets Oracle's foot in the door [accounting, CRM, etc]). There's been rumors that Oracle has made sweetheart licensing deals with AWS as an attempt at bulwarking against Azure dominance.
- karmakaze 6y agoFrom the Drawbridge link of the article: > Drawbridge is a research prototype of a new form of virtualization for application sandboxing. Drawbridge combines two core technologies: First, a picoprocess, which is a process-based isolation container with a minimal kernel API surface. Second, a library OS, which is a version of Windows enlightened to run efficiently within a picoprocess. So does this mean that the 'library OS' translates WinAPI to Linux?