{"id":146,"date":"2012-08-09T13:45:41","date_gmt":"2012-08-09T04:45:41","guid":{"rendered":"http:\/\/auctionpro.co.kr\/WPress\/?p=146"},"modified":"2012-08-16T16:27:38","modified_gmt":"2012-08-16T07:27:38","slug":"the-seven-different-editions-of-sql-server-2008","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=146","title":{"rendered":"The seven different editions of SQL Server 2008"},"content":{"rendered":"<p>SQL Server 2008 is the latest release in Microsoft&#8217;s enterprise relational database platform series. In this substantial upgrade, they&#8217;ve packed the new database engine full of new features, but fortunately it doesn&#8217;t pack any additional punch in your wallet: SQL Server 2008 is available at the same price points used by SQL Server 2005.<\/p>\n<p>Let&#8217;s take a look at the seven different editions of SQL Server 2008 that you can use:<\/p>\n<ul>\n<li><strong>SQL Server 2008 Express Edition<\/strong>\u00a0replaces the Microsoft Data Engine (MSDE) as the free version of SQL Server for application development and lightweight use. It remains free and retains the limitations of MSDE with respect to client connections and performance. It&#8217;s a great tool for developing and testing applications and extremely small implementations, but that&#8217;s about as far as you can run with it.<br \/>\nDB\ub2f9 4G \u00a0\ub9cc \uc800\uc7a5\uac00\ub2a5( DB \uc5ec\ub7ec\uac1c \ub9cc\ub4e4\uace0 \ub370\uc774\ud0c0 \ud0c0\uc785 \ucd5c\uc18c\ub85c \ud574\uc57c \ud568)<br \/>\nCPU\ub2f9 1G\ub9cc \uc81c\uacf5.<\/li>\n<li><strong>SQL Server 2008 Workgroup<\/strong>\u00a0is billed as a &#8220;small business SQL Server&#8221; and it offers an impressive array of functionality for a $3,899 price tag per processor. (It&#8217;s also available under a 5-user license for $739). Workgroup edition maxes out at 2 CPUs with 3GB of RAM and allows for most of the functionality you&#8217;d expect from a server-based relational database. It offers limited\u00a0replication capabilities\u00a0as well.<\/li>\n<li>The workhorse\u00a0<strong>SQL Server 2008 Standard Edition<\/strong>\u00a0remains the staple of the product line for serious database applications. It can handle up to 4 CPUs with an unlimited amount of RAM. Standard Edition 2005 introduces database mirroring and integration services. It&#8217;s priced at $5,999 for a processor or $1,849 for 5 users.<\/li>\n<li>The big kid on the block is\u00a0<strong>SQL Server 2008 Enterprise Edition<\/strong>. With the release of 2005, Enterprise Edition allows unlimited scalability and partitioning. It&#8217;s truly an enterprise-class database and it&#8217;s hefty price tag ($24,999 per processor or $13,969 for 25 users) reflects its value.<\/li>\n<li>Developers needing the full features of SQL Server 2008 Enterprise Edition for use in a non-production environment may find\u00a0<strong>SQL Server 2008 Developer Edition<\/strong>\u00a0the right tool for the job. This product has the exact same functionality as Enterprise Edition and only differs in the license. (Oh, and by the way, it&#8217;s $24,949 cheaper at only $50 per license!) Microsoft also offers a direct upgrade path to convert Developer servers to production licensing<\/li>\n<li><strong>SQL Server 2008 Web<\/strong>\u00a0is a specialized version of SQL Server for use in web hosting environments. Like Standard edition, it has no limitations on the amount of memory used and supports the use of up to 4 CPUs. Pricing for web edition runs $15 per processor per month.<\/li>\n<li><strong>SQL Server 2008 Compact<\/strong>\u00a0is a free version of SQL Server for use in embedded environments, such as mobile devices and other Windows systems.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>SQL Server 2008 is the latest release in Microsoft&#8217;s enterprise relational database platform series. In this substantial upgrade, they&#8217;ve packed the new database engine full <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=146\" title=\"The seven different editions of SQL Server 2008\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-146","post","type-post","status-publish","format-standard","hentry","category-mssql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The seven different editions of SQL Server 2008 - AuctionPro<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.auctionpro.co.kr\/?p=146\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The seven different editions of SQL Server 2008 - AuctionPro\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2008 is the latest release in Microsoft&#8217;s enterprise relational database platform series. In this substantial upgrade, they&#8217;ve packed the new database engine full [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.auctionpro.co.kr\/?p=146\" \/>\n<meta property=\"og:site_name\" content=\"AuctionPro\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-09T04:45:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-08-16T07:27:38+00:00\" \/>\n<meta name=\"author\" content=\"golgol\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"golgol\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=146#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=146\"},\"author\":{\"name\":\"golgol\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\"},\"headline\":\"The seven different editions of SQL Server 2008\",\"datePublished\":\"2012-08-09T04:45:41+00:00\",\"dateModified\":\"2012-08-16T07:27:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=146\"},\"wordCount\":442,\"commentCount\":0,\"articleSection\":[\"[DB]MSSQL Server\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=146#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=146\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=146\",\"name\":\"The seven different editions of SQL Server 2008 - AuctionPro\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#website\"},\"datePublished\":\"2012-08-09T04:45:41+00:00\",\"dateModified\":\"2012-08-16T07:27:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=146#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=146\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=146#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The seven different editions of SQL Server 2008\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#website\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/\",\"name\":\"AuctionPro\",\"description\":\"\uc625\uc158\ud504\ub85c\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\",\"name\":\"golgol\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?author=6\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The seven different editions of SQL Server 2008 - AuctionPro","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.auctionpro.co.kr\/?p=146","og_locale":"ko_KR","og_type":"article","og_title":"The seven different editions of SQL Server 2008 - AuctionPro","og_description":"SQL Server 2008 is the latest release in Microsoft&#8217;s enterprise relational database platform series. In this substantial upgrade, they&#8217;ve packed the new database engine full [...]","og_url":"https:\/\/www.auctionpro.co.kr\/?p=146","og_site_name":"AuctionPro","article_published_time":"2012-08-09T04:45:41+00:00","article_modified_time":"2012-08-16T07:27:38+00:00","author":"golgol","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"golgol","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.auctionpro.co.kr\/?p=146#article","isPartOf":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=146"},"author":{"name":"golgol","@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2"},"headline":"The seven different editions of SQL Server 2008","datePublished":"2012-08-09T04:45:41+00:00","dateModified":"2012-08-16T07:27:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=146"},"wordCount":442,"commentCount":0,"articleSection":["[DB]MSSQL Server"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.auctionpro.co.kr\/?p=146#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.auctionpro.co.kr\/?p=146","url":"https:\/\/www.auctionpro.co.kr\/?p=146","name":"The seven different editions of SQL Server 2008 - AuctionPro","isPartOf":{"@id":"https:\/\/www.auctionpro.co.kr\/#website"},"datePublished":"2012-08-09T04:45:41+00:00","dateModified":"2012-08-16T07:27:38+00:00","author":{"@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2"},"breadcrumb":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=146#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.auctionpro.co.kr\/?p=146"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.auctionpro.co.kr\/?p=146#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/www.auctionpro.co.kr\/"},{"@type":"ListItem","position":2,"name":"The seven different editions of SQL Server 2008"}]},{"@type":"WebSite","@id":"https:\/\/www.auctionpro.co.kr\/#website","url":"https:\/\/www.auctionpro.co.kr\/","name":"AuctionPro","description":"\uc625\uc158\ud504\ub85c","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.auctionpro.co.kr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2","name":"golgol","url":"https:\/\/www.auctionpro.co.kr\/?author=6"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=146"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/146\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}