{"id":6633,"date":"2008-01-28T03:00:00","date_gmt":"2008-01-28T11:00:00","guid":{"rendered":""},"modified":"2024-01-22T22:51:35","modified_gmt":"2024-01-23T06:51:35","slug":"sql-server-2008-case-studies","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/","title":{"rendered":"SQL Server 2008 case studies"},"content":{"rendered":"<p>As we get closer to launch, I wanted to spend a moment to highlight some recently published case studies for SQL Server 2008. Its great to see the excellent work that our customers and partners are doing on our upcoming release.<\/p>\n<ul>\n<li><a href=\"http:\/\/www.microsoft.com\/casestudies\/casestudy.aspx?casestudyid=4000001003\">Healthcare Group Upgrading to SQL Server 2008 to Better Protect 2 Terabytes of Data<\/a><br \/>\nCareGroup Healthcare System is responsible for protecting the privacy and integrity of 2 terabytes of patient information and related data. CareGroup hosts its data on 390 databases on 30 instances of Microsoft SQL Server 2005. The organization is updating databases to SQL Server 2008 to take advantage of new features includ ing advanced auditing and transparent encryption to help it meet HIPAA and other regulatory requirements. CareGroup is using the Declarative Management Framework, new for SQL Server 2008, to enforce policy and schema across its operations, and is centralizing reporting using SQL Server 2008 Reporting Services accessed through a portal created using Microsoft Office SharePoint Server 2007.<\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/www.microsoft.com\/casestudies\/casestudy.aspx?casestudyid=4000001007\">Software Company Creates Automated &#8216;Database Factory&#8217; Using SQL Server 2008<\/a><br \/>\nCyberSavvy believes in using software automation to make life easier for its customers. Its Software as a Service solution, DataPlace, which it terms a &#8220;database factory,&#8221; enables technical and business oriented customers to create and modify their own databases, hosted by CyberSavvy. The company needed a rock-solid database with a faultless data transfer mechanism to support communication between its client-side SmartClient and backend databases. CyberSavvy deploys its solutions on the Microsoft Application Platform, using Microsoft SQL Server 2008 Enterprise Edition on the hosted server side, and SQL Server 2008 Express Edition on the client side.<\/li>\n<li><a href=\"http:\/\/www.microsoft.com\/casestudies\/casestudy.aspx?casestudyid=4000001024\">Austrian Broadcasting Corporation Prepares for Euro Cup Soccer with SQL Server 2008<\/a><br \/>\nAustrian Broadcasting Corporation Radio &amp; Television (ORF) has an IT group that helps its sportscasters and other reporters provide exceptional live sports coverage by providing nearly instantaneous analytics and other sports information from its sports database and related data warehouses. Looking ahead to the live coverage it will provide for the 2008 Euro Cup soccer championship games, which will be held in Austria and Switzerland, ORF wanted to ensure it had the best database infrastructure possible. After testing Microsoft SQL Server 2008, ORF decided to upgrade from SQL Server 2005 even before the official release of SQL Server 2008. The organization has seen even faster data processing since upgrading, and is enjoying enhanced data management through using new SQL Server 2008 features such as the Declarative Management Framework and Change Data Capture.<\/li>\n<li><a href=\"http:\/\/www.microsoft.com\/casestudies\/casestudy.aspx?casestudyid=4000001216\"><span style=\"font-size: small\">Hitachi Consulting &#8211; IT Consulting Firm Eases Move from Crystal Reports to SQL Server Reporting Services<\/span><\/a><br \/>\n<span style=\"font-size: small\">Hitachi Consulting, a global organization recognized for delivering proven business and IT solutions to a wide range of industry leaders, needed an easier way to help organizations migrate from Crystal Reports to Microsoft\u00ae SQL Server\u00ae Reporting Services. The company had customers that had originally deployed business intelligence solutions using SQL Server for the relational data store but Crystal Reports for reporting, and wanted to gain the efficiency and savings of a single-vendor integrated solution. Hitachi Consulting, which is deploying SQL Server 2008, created its Reporting Center of Excellence, which provides cost-effective migrations, and a tool that automates conversion of reports to the Report Definition Language that Reporting Services uses. The company has found that moving to Reporting Services helps reduce complexity, enhance visibility, and lower reporting costs.<\/span><\/li>\n<\/ul>\n<p>Also, even though this one is a SQL Server 2005 case study, I think that its particularly interesting<\/p>\n<ul>\n<li><a href=\"http:\/\/www.microsoft.com\/casestudies\/casestudy.aspx?casestudyid=4000001199\"><b>Citi &#8211; Market Montage Solution Supports 200,000 Updates per Second with SQL Server 2005<\/b><\/a><br \/>\nWhen Citi\u2019s Lava Technology team needed to create a compliance solution for the U.S. Securities and Exchange Commission\u2019s Regulation NMS (requiring dealers to use best-available pricing when executing securities orders), it thought it would need a Cray supercomputer or other specialized solution. This is because terabytes of data are required to recreate market conditions at the point of an order execution at any point in time. After doing a \u201cbake-off\u201d competitive testing with other solutions, the company, which provides a suite of products to support real-time feeds across multiple equity markets, determined that the Microsoft\u00ae Application Platform, including Microsoft SQL Server\u00ae 2005, provided the best performance and lowest total cost of ownership. The solution supports peak loads that exceed 200,000 messages per second.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>As we get closer to launch, I wanted to spend a moment to highlight some recently published case studies for SQL Server 2008. Its great to see the excellent work that our customers and partners are doing on our upcoming release.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2445],"topic":[],"coauthors":[],"class_list":["post-6633","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership","review-flag-1593580414-58","review-flag-2-1593580436-981","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2008 case studies - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2008 case studies - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"As we get closer to launch, I wanted to spend a moment to highlight some recently published case studies for SQL Server 2008. Its great to see the excellent work that our customers and partners are doing on our upcoming release.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2008-01-28T11:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2008 case studies\",\"datePublished\":\"2008-01-28T11:00:00+00:00\",\"dateModified\":\"2024-01-23T06:51:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/\"},\"wordCount\":690,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/\",\"name\":\"SQL Server 2008 case studies - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2008-01-28T11:00:00+00:00\",\"dateModified\":\"2024-01-23T06:51:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2008 case studies\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2008 case studies - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2008 case studies - Microsoft SQL Server Blog","og_description":"As we get closer to launch, I wanted to spend a moment to highlight some recently published case studies for SQL Server 2008. Its great to see the excellent work that our customers and partners are doing on our upcoming release.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2008-01-28T11:00:00+00:00","article_modified_time":"2024-01-23T06:51:35+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2008 case studies","datePublished":"2008-01-28T11:00:00+00:00","dateModified":"2024-01-23T06:51:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/"},"wordCount":690,"commentCount":2,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/","name":"SQL Server 2008 case studies - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2008-01-28T11:00:00+00:00","dateModified":"2024-01-23T06:51:35+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/01\/28\/sql-server-2008-case-studies\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2008 case studies"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/6633","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=6633"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/6633\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=6633"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=6633"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=6633"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=6633"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=6633"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=6633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}