<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
A True SQL OS
46 posts, Page 1 of 5
1
2
3
4
5
»
»»
A True SQL OS
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, August 25, 2009 9:47 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526,
Visits: 13,863
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
Post #777233
Robert Hermsen
Robert Hermsen
Posted Wednesday, August 26, 2009 6:45 AM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 7:52 AM
Points: 455,
Visits: 756
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.
Post #777430
nigel.
nigel.
Posted Wednesday, August 26, 2009 7:40 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, June 03, 2013 9:46 AM
Points: 1,164,
Visits: 2,603
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
Post #777483
GSquared
GSquared
Posted Wednesday, August 26, 2009 7:53 AM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 1:45 PM
Points: 15,442,
Visits: 9,572
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
Post #777506
Todd Payne
Todd Payne
Posted Wednesday, August 26, 2009 8:04 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, May 17, 2013 7:03 AM
Points: 27,
Visits: 179
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.
Post #777515
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Wednesday, August 26, 2009 8:50 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526,
Visits: 13,863
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
Post #777564
Someguy
Someguy
Posted Wednesday, August 26, 2009 9:01 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, May 07, 2012 10:39 AM
Points: 153,
Visits: 565
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.”
Post #777580
edwardelliott
edwardelliott
Posted Wednesday, August 26, 2009 10:45 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, August 29, 2012 8:19 AM
Points: 91,
Visits: 350
a database / os hybrid? You've just invented an AS/400!
Post #777663
notquitexena
notquitexena
Posted Wednesday, August 26, 2009 10:51 AM
SSC Eights!
Group: General Forum Members
Last Login: Monday, November 02, 2009 8:46 AM
Points: 875,
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.
Post #777669
Scott D. Jacobson
Scott D. Jacobson
Posted Wednesday, August 26, 2009 11:54 AM
Old Hand
Group: General Forum Members
Last Login: Today @ 4:28 PM
Points: 335,
Visits: 844
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
Post #777716
« Prev Topic
|
Next Topic »
46 posts, Page 1 of 5
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
