SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A True SQL OS


A True SQL OS

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)

Group: Administrators
Points: 277789 Visits: 19896
Comments posted to this topic are about the item A True SQL OS

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
BJ Hermsen
BJ Hermsen
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1429 Visits: 880
I would love to see a core OS install running SQL Server. There are still many times when apps on the SQL Server would be necessary likewise there other reasons to not implement a core only model. It really depends how granular of an implementation a person wantseeds.

http://msdn.microsoft.com/en-us/library/ms143506.aspx -- "SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations."

Unfortunately SQL Server 2008 is not compatible with the Windows Server 2008 Core only installation. Maybe it is part of MS long term upgrade strategy.
nigel.
nigel.
SSCertifiable
SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)

Group: General Forum Members
Points: 5553 Visits: 2959
Steve,

You say they won't do this due to a loss of revenue from selling fewer Windows licences.
Surely Micro$oft will just charge more for this 'SQL OS' to make up the difference.

Nigel

--
Nigel
Useful Links:
How to post data/code on a forum to get the best help
The "Numbers" or "Tally" Table - Jeff Moden

GSquared
GSquared
SSC Guru
SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)

Group: General Forum Members
Points: 117495 Visits: 9730
I like the idea of a stripped down version of Windows for this purpose more than the idea of SQL Server having to support hardware drivers, Active Directory, booting, internet connectivity (even if just for SQL Server updates to be downloaded), network connectivity (SQL Server doesn't contain the TCP/IP protocols, NIC drivers, etc., because Windows does that for it), and so on.

A version of Windows Server specialized for SQL Server and nothing else might be a good idea. But then Microsoft has to include support, upgrade and new version paths, etc., for it, and that might just add to expenses. If it would be a viable product, then it would be nice.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Todd Payne
Todd Payne
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 195
It is a great Idea! When a automobile company designs a car, or developers design an application. They focus on the capabilities they want to include. Then they can optimize the product to get the best performance. I Liken Installing SQL Server on a server to hitching a trailer on the family car. The trailer works fine and the job gets done, but If you were using the family car and the attached trailer every day, how long would it be before you were wishing you had a truck. The truck could be the perfect size, with a suspension and engine matched to your particular need. Sure it wouldn't do everything the family car did, but it would haul stuff better than the family car. You would probably have both parked in your driveway.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)SSC Guru (277K reputation)

Group: Administrators
Points: 277789 Visits: 19896
I like the car analogy!

And I hope they don't start charging more for SQL without Windows, but I wouldn't be surprised.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Someguy
Someguy
SSC Eights!
SSC Eights! (857 reputation)SSC Eights! (857 reputation)SSC Eights! (857 reputation)SSC Eights! (857 reputation)SSC Eights! (857 reputation)SSC Eights! (857 reputation)SSC Eights! (857 reputation)SSC Eights! (857 reputation)

Group: General Forum Members
Points: 857 Visits: 579
Question: How would this effect features of SQL Server which interact with other windows-dependent features such as CLR? I know we've had discussions on this forum as to whether SQL Server really benefits from the addition of CLR, but since it's there, it seems like a lot of Windows functionality is going to be potentially called.

___________________________________________________
“Politicians are like diapers. They both need changing regularly and for the same reason.”
edwardelliott
edwardelliott
SSC Eights!
SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)

Group: General Forum Members
Points: 925 Visits: 351
a database / os hybrid? You've just invented an AS/400! :-)
notquitexena
notquitexena
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1377 Visits: 313
"Windows I/O and scheduling could be tuned specifically for SQL Server, or just incorporated into the SQL Server platform."

I'm afraid if you incorporated these into SQL Server you would quickly have the functionality diverge from the base OS source, which could in the long run lead to strange consequences. I've seen code which was copied from a legacy system mutate so fast in the space of the year that the original designer could not figure out why it would no longer work in the new system.
Scott D. Jacobson
Scott D. Jacobson
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2776 Visits: 1020
Robert Hermsen (8/26/2009)
http://msdn.microsoft.com/en-us/library/ms143506.aspx -- "SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations."

Unfortunately SQL Server 2008 is not compatible with the Windows Server 2008 Core only installation. Maybe it is part of MS long term upgrade strategy.


That specifically says "not supported". In MS-ese that is not the same as "not compatible". I'd guess this stems from the fact that .NET is required for SQL to install. Initially, .NET was not supported under Core installations either. But I think this might have changed: http://blogs.technet.com/server_core/archive/2008/12/19/net-3-0-and-3-5-in-windows-server-2008-r2-server-core.aspx
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search