{"id":6185,"date":"2015-11-05T13:36:46","date_gmt":"2015-11-05T12:36:46","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/"},"modified":"2015-11-05T13:36:46","modified_gmt":"2015-11-05T12:36:46","slug":"sql-server-collation-for-system-center-products","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/","title":{"rendered":"SQL Server Collation for System Center Products"},"content":{"rendered":"<p>A customer asks me, what is the collation for System Center products?<br \/>\nDo we have a general collation for all products?<br \/>\nAnd what is the BP for Tempdb?<br \/>\nAnd how work the licencing for SQL Server in System Center (is SQL Server included)???<\/p>\n<p>I answer just \u201cOK, OK, I understand, I wil check those points\u2026\u201d<br \/>\nI\u00a0 search those information on Microsoft TechNet website, blogs, presentation, etc.. and I\u00a0 think that it is interesting to share this\/those info with all of you \ud83d\ude09<\/p>\n<h3>Why Collation is so important?<\/h3>\n<p>Collation defines how SQL Server will work on data level with indexing, sorting,&#8230;<br \/>\nIf a bad collation is chosen, it could cause various problems around the manipulation and\u00a0 research of data.<br \/>\nThere are two types of collation:<\/p>\n<ul>\n<li>SQL Server collations (SQL_*)<\/li>\n<li>Windows collations<\/li>\n<\/ul>\n<p>If you want more info about collation, I suggest to read my article in SQL Magazine: \u201c<a title=\"A Seven-Step Process for Changing a Database's Collation\" href=\"http:\/\/sqlmag.com\/database-performance-tuning\/seven-step-process-changing-database-collation\" target=\"_blank\">A Seven-Step Process for Changing a Database&#8217;s Collation<\/a>\u201d<\/p>\n<p>A good practice is to keep the <span style=\"color: red\">same collation between the instance and these databases<\/span>.<br \/>\nAt the beginning, System Center products have been <span style=\"color: red\">only supported with the SQL_Latin1_General_CP1_CI_AS collation<\/span>.<br \/>\nIt is the default collation when you install SQL Server but the Best Practice is to use Windows Collation(SQL_* collations will be deprecated).<br \/>\nSystem Center will change it but for the moment you need to <span style=\"color: red\">follow the recommendation for each product<\/span>.<\/p>\n<h3>Collation recommendation per System Center Product<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5147 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC01.png\" alt=\"SC01\" width=\"281\" height=\"180\" \/><\/a><\/p>\n<p><a title=\"System Center principal link\" href=\"https:\/\/technet.microsoft.com\/en-us\/library\/hh546785.aspx\" target=\"_blank\">System Center<\/a> has many products and each product has his self-databases.<\/p>\n<h3>System Center App Controller Server<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC02.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5144\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC02.jpg\" alt=\"SC02\" width=\"300\" height=\"68\" \/><\/a><\/p>\n<p>App Controller helps to configure, deploy, and manage virtual machines and services across private and public clouds.<br \/>\n<strong>Supported Collations:<\/strong> Must be set to one of the <span style=\"color: red\">_100_ collations<\/span> like Latin1_General_100_CI_AS<br \/>\n<strong>Link:<\/strong> <a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/gg696046.aspx\" target=\"_blank\">https:\/\/technet.microsoft.com\/en-us\/library\/gg696046.aspx<\/a><\/p>\n<h3>System Center Configuration Manager (SCCM)<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5150\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC03.png\" alt=\"SC03\" width=\"300\" height=\"149\" \/><\/a><\/p>\n<p>Configuration Manager is used\u00a0 to change and configure management like Deploy operating systems, software applications, and software updates.<br \/>\n<strong>Supported Collations:<\/strong> <span style=\"color: red\">only SQL_Latin1_General_CP1_CI_AS<\/span><br \/>\n<strong>Link:<\/strong> <a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/gg682077.aspx#BKMK_SupConfigSQLSrvReq\" target=\"_blank\">https:\/\/technet.microsoft.com\/en-us\/library\/gg682077.aspx#BKMK_SupConfigSQLSrvReq<\/a><\/p>\n<h3>System Center Service Manager (SCSM)<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5143\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC04.png\" alt=\"SC04\" width=\"300\" height=\"87\" \/><\/a><\/p>\n<p>Service Manager provides built-in processes for incident and problem resolution, change control, and asset lifecycle management.<br \/>\n<strong>Supported Collations:<\/strong><\/p>\n<ul>\n<li>Latin1_General_100_CI_AS<\/li>\n<li>SQL_Latin1_General_CP1_CI_AS<\/li>\n<li>Latin1_General_CI_AS<\/li>\n<li>Chinese_Simplified_Pinyin_100_CI_AS<\/li>\n<li>Czech_100_CI_AS<\/li>\n<li>Danish_Norwegian_CI_AS<\/li>\n<li>Finnish_Swedish_100_CI_AS<\/li>\n<li>Greek_100_CI_AS<\/li>\n<li>Hungarian_100_CI_AS<\/li>\n<li>Japanese_XJIS_100_CI_AS<\/li>\n<li>Korean_100_CI_AS<\/li>\n<li>Norwegian_100_CI_AS<\/li>\n<li>Polish_100_CI_AS<\/li>\n<li>Cyrillic_General_100_CI_AS<\/li>\n<li>Modern_Spanish_100_CI_AS<\/li>\n<li>Finnish_Swedish_100_CI_AS<\/li>\n<li>Turkish_100_CI_AS<\/li>\n<\/ul>\n<p><strong>Link:<\/strong> <a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/hh495583.aspx\" target=\"_blank\">https:\/\/technet.microsoft.com\/en-us\/library\/hh495583.aspx<\/a><br \/>\n<strong>Note:<\/strong> You must use the same supported language collations if you intend to import data from Operations Manager into Service Manager<\/p>\n<h3>System Center Operation Manager (SCOM)<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5148\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC05.png\" alt=\"SC05\" width=\"267\" height=\"188\" \/><\/a><\/p>\n<p>Operations Manager helps for the availability of applications and monitors private and public clouds.<br \/>\n<strong>Supported Collations:<\/strong><\/p>\n<ul>\n<li>SQL_Latin1_General_CP1_CI_AS<\/li>\n<li>French_CI_AS<\/li>\n<li>Cyrillic_General_CI_AS<\/li>\n<li>Chinese_PRC_CI_AS<\/li>\n<li>Japanese_CI_AS<\/li>\n<li>Traditional_Spanish_CI_AS<\/li>\n<li>Latin1_General_CI_AS<\/li>\n<\/ul>\n<p><strong>link:<\/strong> <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/jj656649.aspx\" target=\"_blank\"> http:\/\/technet.microsoft.com\/en-us\/library\/jj656649.aspx<\/a><\/p>\n<h3>System Center Orchestrator<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC06.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5146\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC06.png\" alt=\"SC06\" width=\"300\" height=\"86\" \/><\/a><\/p>\n<p>Orchestrator is a workflow management solution to automate the creation, monitoring, and deployment of resources.<br \/>\n<strong>Supported Collations:<\/strong> <span style=\"color: red\">only SQL_Latin1_General_CP1_CI_AS<\/span><br \/>\n<strong>link:<\/strong><a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/hh420361.aspx\" target=\"_blank\"> https:\/\/technet.microsoft.com\/en-us\/library\/hh420361.aspx<\/a><\/p>\n<h3>System Center Data Protection Manager (DPM)<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC07.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5145\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC07.png\" alt=\"SC07\" width=\"295\" height=\"171\" \/><\/a><\/p>\n<p>DPM is used to back up servers, computers, Microsoft workloads, system state, and bare metal recovery (BMR).<br \/>\n<strong>Supported Collations:<\/strong><span style=\"color: red\">only SQL_Latin1_General_CP1_CI_AS<\/span><br \/>\n<strong>link:<\/strong><a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/hh758176.aspx\" target=\"_blank\">https:\/\/technet.microsoft.com\/en-us\/library\/hh758176.aspx<\/a><\/p>\n<h3>System Center Virtual Machine Manager (VMM)<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5149\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC08.png\" alt=\"SC08\" width=\"277\" height=\"74\" \/><\/a><\/p>\n<p>VMM is a management solution for virtualized datacenter.<br \/>\n<strong>Instance collations:<\/strong> <span style=\"color: red\">Any case insensitive (CI) collation<\/span> can be used.<br \/>\n<strong>link:<\/strong><a href=\"https:\/\/technet.microsoft.com\/library\/dn771747.aspx\" target=\"_blank\">https:\/\/technet.microsoft.com\/library\/dn771747.aspx<\/a><br \/>\n<strong>Database collations:<\/strong> <span style=\"color: red\">only Latin1_General_100_CI_AS<\/span><\/p>\n<h3>Collation table summary<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC09.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5151 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC09.png\" alt=\"SC09\" width=\"300\" height=\"113\" \/><\/a><\/p>\n<p>72%(5\/7) of System Center products use the collation SQL_Latin1_General_CP1_CI_AS but few products (3\/7) can be set with the Windows collation Latin1_General_100_CI_AS.<br \/>\nI recommend to have at least 2 instances, one with SQL_Latin1_General_CP1_CI_AS and one with like Latin1_General_100_CI_AS.<br \/>\nIf you have money and will build a good architecture for System Center, I recommend to have dedicated instances for each product but be careful with the interaction between them.<\/p>\n<h3>TempDB configuration recommendation<\/h3>\n<p>Tempdb can be the cause of performance problem for System Center products if it is not well configured.<br \/>\nThen, I give you some generic rules to configure it correctly.<br \/>\n<strong>Collation:<\/strong> Same Collation as databases from System Center Products<br \/>\n<strong>Files:<\/strong> multiple files &#8211; one data file per core with the same size (max to 8)<br \/>\n<strong>Size:<\/strong> 20-30% of the DB file size and if you don&#8217;t know the size 8GB is a good starting point and minimum 2GB<br \/>\n<strong>Auto-Growth:<\/strong> 512MB for data files and 128 for the 128MB<\/p>\n<h3>SQL Server License<\/h3>\n<p>System Center includes a SQL Server Standard Edition License. You don\u2019t need to pay an extra for the Database<br \/>\nThe global limitation is that instances must be dedicated to System Center Products and you cannot installed other databases on it.<br \/>\nThe second limitation is for Configuration Manager: must be under 50000 clients.<br \/>\nThese 2 limitations are the only one on a Licence Level.<br \/>\nThe thing is that you are limited by the Standard Edition like no AlwaysOn, no multi-node clustering, no online or parallel commands, memory, cores, etc.<\/p>\n<p><strong>My Advice:<\/strong><br \/>\nIf System Center becomes the heart of you IT infrastructure, don\u2019t think a lot and go directly to SQL Server Enterprise Editions with System Center Products and have a dedicated instance for each product.<\/p>\n<h3>links<\/h3>\n<p>SQL Server version support for all System Center Products:<br \/>\n<a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/dn281933.aspx\" target=\"_blank\">https:\/\/technet.microsoft.com\/en-us\/library\/dn281933.aspx<\/a><br \/>\nAnother source of information for System Center Services Manager is the blog from Travis Wright:<br \/>\n<a href=\"http:\/\/blogs.technet.com\/b\/servicemanager\/archive\/2012\/05\/24\/clarification-on-sql-server-collation-requirements-for-system-center-2012.aspx?pi168154=2\" target=\"_blank\">http:\/\/blogs.technet.com\/b\/servicemanager\/archive\/2012\/05\/24\/clarification-on-sql-server-collation-requirements-for-system-center-2012.aspx?pi168154=2<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A customer asks me, what is the collation for System Center products? Do we have a general collation for all products? And what is the BP for Tempdb? And how work the licencing for SQL Server in System Center (is SQL Server included)??? I answer just \u201cOK, OK, I understand, I wil check those points\u2026\u201d [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":6195,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197,368],"tags":[599,49,67,51,537],"type_dbi":[],"class_list":["post-6185","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-integration-middleware","category-development-performance","tag-collation","tag-microsoft","tag-performance","tag-sql-server","tag-system-center"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server Collation for System Center products<\/title>\n<meta name=\"description\" content=\"System Center has many products and it is difficult to find the good collation for these products.\" \/>\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.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Collation for System Center Products\" \/>\n<meta property=\"og:description\" content=\"System Center has many products and it is difficult to find the good collation for these products.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-05T12:36:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC04-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"417\" \/>\n\t<meta property=\"og:image:height\" content=\"121\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server Collation for System Center Products\",\"datePublished\":\"2015-11-05T12:36:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/\"},\"wordCount\":978,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SC04-1.png\",\"keywords\":[\"Collation\",\"Microsoft\",\"Performance\",\"SQL Server\",\"System Center\"],\"articleSection\":[\"Application integration &amp; Middleware\",\"Development &amp; Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/\",\"name\":\"SQL Server Collation for System Center products\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SC04-1.png\",\"datePublished\":\"2015-11-05T12:36:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"System Center has many products and it is difficult to find the good collation for these products.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SC04-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SC04-1.png\",\"width\":417,\"height\":121},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-collation-for-system-center-products\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Collation for System Center Products\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server Collation for System Center products","description":"System Center has many products and it is difficult to find the good collation for these products.","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.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Collation for System Center Products","og_description":"System Center has many products and it is difficult to find the good collation for these products.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/","og_site_name":"dbi Blog","article_published_time":"2015-11-05T12:36:46+00:00","og_image":[{"width":417,"height":121,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC04-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server Collation for System Center Products","datePublished":"2015-11-05T12:36:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/"},"wordCount":978,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC04-1.png","keywords":["Collation","Microsoft","Performance","SQL Server","System Center"],"articleSection":["Application integration &amp; Middleware","Development &amp; Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/","name":"SQL Server Collation for System Center products","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC04-1.png","datePublished":"2015-11-05T12:36:46+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"System Center has many products and it is difficult to find the good collation for these products.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC04-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SC04-1.png","width":417,"height":121},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collation-for-system-center-products\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Collation for System Center Products"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=6185"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6185\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6195"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6185"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}