Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The New SQL OS

By Steve Jones,

SQL Server is being entirely rewritten for 2010, with a current code name of "Kalamazoo". In keeping with the trend of substantial changes to the core functionality of the platform every other version, this next release will form the basis for future changes that might well extend beyond SQL Server 12.

Early rumors show the disatifaction that the marketing groups have with dependencies on Windows and other products at Microsoft as well as the three year time frame. The goal is to release an entirely new version of SQL Server on-demand, thereby doing away with the cumbersome problems and cost of Service Packs and other major patches. The development team is hard at work on a new way avoid this: The SQL OS.

An unnamed source has revealed that the SQL team has a project underway (code named "Wildstar"), which will meet these goals. An entire operator system layer, based on the new Windows 2008 Server Core, will integrate the base OS features into SQL Server and allow you to install a single large server instance without requiring Windows or any other software. You will still get an NTFS filesystem and can set mount points, but drive letters are gone as well as many of the default administrative holes that Windows creates. Copies of only those Windows services needed for SQL Server are installed and set to a new "SQL Instance Service" account that has limited rights.

"We are trying to create a very secure, minimal install for SQL Server and prevent many of the security and configuration issues that Windows allows DBAs to set up." quoted from an unnamed source.

This new approach will completely isolate SQL Server from any other software and allow you to create a true, SQL Server-only instance. And with some new memory management techniques being tested, including a data cache per database setting, , it is expected that multiple instances from traditional SQL Server installations can be easily consolidated onto this new platform. There is also work being done on multiple tempdb databases and configuration options to link them to particular databases as well as a built-in RAM drive for storing certain data sets that might benefit from improvements in this area.

This new platform is expected to be released in x64-bit versions only and if you are still reading this farce, Happy April Fool's day! None of this is true and noone at Microsoft has hinted of any such project in any way to the edtiors of this site.

It's an interesting idea and one that I think might solve some security issues, albeit with limitations in flexibility and what you can do with an instance. Maybe we'll actually be able to report on such a project at some point in the future.

Total article views: 9210 | Views in the last 30 days: 9
 
Related Articles
FORUM

Installing Reporting Services - IIS on other server

Is it possible to install the Reporting Services in an instance with the IIS on other server?

FORUM

Install SQLServer 2000 in Windows Server 2008

Install SQLServer 2000 in Windows Server 2008

FORUM

Error: Installing SQL Server Cluster Instance

Error: Installing SQL Server Cluster Instance

FORUM

Sql instance installation on Application Server

HELP=Sql instance installation on Application Server

ARTICLE

Installing SQL Server 2008R2 on a Windows 2008R2 Core Server

This article will show you how to install SQL Server on to a Windows Core Server host.

Tags
humor    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones