With SQL Server on Ubuntu Pro, SQL Server makes use of the XFS filesystem, a journaling filesystem popular on Linux, that offers Direct I/O capabilities, meaning: blazing fast. Right now you can get SQL Server 2019 – Standard and Enterprise editions – on both Ubuntu Pro 18.04 LTS and Ubuntu Pro 20.04 LTS, and they come with some solid security and management features as you’d expect – like Transparent Data Encryption (TDE) and Row-Level Security. And Microsoft has continued to work together with us at Canonical to bring a highly performant and fully supported solution for SQL Server to the Azure cloud, based around the Ubuntu Pro 20.04 LTS operating system. With the release of SQL Server 2017, Microsoft introduced the features needed to enable SQL Server to run on Linux, closing this long-standing shortcoming and enabling the SQL Server team to fully address the needs of enterprise IT departments with more flexible deployment options. This strategy of coupling SQL Server to Windows meant SQL Server could gain agility by rapidly building on and relying on Windows NT system services, behaviours and features, without having to worry about portability – but it came at the cost of being unable to fully address the market. But with SQL Server 7, Microsoft also got a storage engine deeply tied to, and reliant on, the Windows subsystem. With SQL Server 7, Microsoft got the seminal milestone release that defined Microsoft SQL Server as a serious contender in the enterprise RDBMS space. Hamilton led SQL Server through releases 7 to SQL Server 2005. In 1998, widely acclaimed engineer James Hamilton (yep, that’s right, the Amazon AWS Vice President) took over management and leadership of the Microsoft SQL Server product development team, and was able to bring his expertise to bear. If you increment each letter in VMS, you get WNT, but jokes aside it is genuinely no coincidence that the W32 kernel architecture and the VMS kernel architecture are closely aligned Microsoft Windows is in fact the descendant of an honorable and pedigree lineage of mainframe and midrange computer operating systems going back to the early 1960s.Įarly versions of SQL Server were able to hold their own, belting out solid performance on x86 PC systems costing a fraction of the price of a comparable minicomputer of that era, and as such SQL Server managed to make quite some traction with devotees of the (then de-facto) client-server compute architecture. The design team behind Windows NT were heavily influenced by Digital Equipment Corporation’s (DEC) VMS operating system, and Win32 is now widely accepted to be built around VMS architecture and design principles. So in IT terms, SQL Server has a very long heritage. But once Windows NT shipped in 1993, SQL Server was further developed exclusively by Microsoft. She belongs to meĪshton-Tate/Microsoft SQL Server was originally conceived and delivered for OS/2, not Windows, as a joint collaboration between Microsoft, Ashton-Tate (developer of dBASE) and Sybase (Sybase DataServer) in the late 1980s. I’m going to take you on a short tour of the history of SQL Server, and I’ll try to explain what makes SQL Server on Ubuntu Pro something quite awesome. So now Microsoft, in collaboration with Canonical, are distributing and supporting several flavours of SQL Server on Ubuntu Pro for Azure. For a long time, SQL Server was only available for Windows, but not much is really sacred. Not going to lie, the Microsoft SQL Server is my all-time favourite Microsoft product.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |