{"id":3246,"date":"2017-02-05T18:42:51","date_gmt":"2017-02-05T17:42:51","guid":{"rendered":"http:\/\/www.teamvidia.com\/?p=3246"},"modified":"2017-02-05T18:42:51","modified_gmt":"2017-02-05T17:42:51","slug":"betclic","status":"publish","type":"post","link":"https:\/\/www.teamvidia.com\/?p=3246","title":{"rendered":"Betclic"},"content":{"rendered":"<p><a href=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2535\" src=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png\" alt=\"\" width=\"150\" height=\"51\" \/><\/a><\/p>\n<p>Projets de production majeur:<\/p>\n<p>- Etude (SAN, R\u00e9seau, Driver des Windows) et Migration de cluster d\u2019origine 4 clusters de 3 n\u0153uds avec chacun 2 instances en Windows 2008 R2 + SQL Server 2008 6To, tout en changeant de Datacenter. Toutes les technologies utlis\u00e9es ont \u00e9t\u00e9 script\u00e9es baches et powershell pour \u00eatre reproduite sur la destination et avoir une coupure courte (1h30) : Mirroring, replication, LogShipping, Synonymes, et les droits sur ces objects.<br \/>\n- Etude et d\u00e9ploiement d\u2019une PRA sur le m\u00eame site, et par la suite sur un site distant avec les memes technologies. Les deux plateformes sont synchronis\u00e9es par LogShipping. En cas de bascule toutes l\u2019infra est remont\u00e9e par script.<\/p>\n<p>-Etude et Migration de la production et des PRA vers Windows 2008 R2 + SQL 2012 \/ SSIS. Mise en place de traces pour analyser le code deprecated.<\/p>\n<p>-Etude, Maquette et Migration de la plateforme vers Windows 2012R2\/SQL2012 en jouant avec les PRA (en basculant de DataCenter). Adaptation des scripts pour travailler sur n\u2019importe quel environnement pour basculer (PRA, Preproduction, \u2026). Les bascules sont bidirectionnelles avec redemontage de l\u2019environnement au repos pour le remettre en synchronisation. Synchro des environnements (Logins, Jobs, Serveurs li\u00e9s avec leur mot de passe hashed).<\/p>\n<p>- Etude et Migration des clusters de production et de PRA pour faire un geocluster Windows 2012R2 + SQL Server 2012 + AlwaysOn. Suppression des replications et miroirs. Adaptation des scripts de bascule. Comparaison des technologies miroirs et AlwaysOn en mati\u00e8re de flux r\u00e9seau.<\/p>\n<p>- Partitionnement et compression de tables volumineuse (&gt; 100Go), Script T-SQL de partitionnement automatique avec d\u00e9placement des donn\u00e9es,<\/p>\n<p>* Projets de production mineurs :<\/p>\n<p>- Portage sous centreon (Nagios) de script et d'alertes T-SQL \/ SQLCMD.<br \/>\n- Maquette dans une machine virtuelle d'un d\u00e9ploiement en mode Core Windows 2008 R2 de SQL Server 2012 + SSAS 2012, pour un acces distant uniquement (RSAT, Remote Powershell, SSMS 2012)<br \/>\n- CDC (Change Data Capture) sur des tables (et sa migration en SQL 2012)<br \/>\n- Audit SQL Server 2008, d\u00e9ploiement en T-SQL<br \/>\n- Ressource gouvernor filtrant des serveurs applicatifs<br \/>\n- Data Collection pour auditer les performances<br \/>\n- Performance Analysis de Quest<\/p>\n<p>* Projets des environnements de d\u00e9veloppements (100 d\u00e9veloppeurs):<\/p>\n<p>- Etude et d\u00e9ploiement de la plateforme virtualis\u00e9e pour les environnements de recette et d\u00e9veloppement en HyperV3 \/ Cluster Windows 2012, puis VMWare, et retour au physique avec clonage de LUN.<br \/>\n-Etude et automatisation des d\u00e9ploiements des environnements de d\u00e9veloppement et recette : LogShipping Production vers Industrialisation, r\u00e9duction des bases en powershell, d\u00e9ploiement automatique des Windows, param\u00e9trage d\u2019optimisation par GPO (SSIS, SQL Server), Script de d\u00e9ploiement automatique (replication, mirroring, droits, package SSIS, broker, jobs, serveurs li\u00e9s ....)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Projets de production majeur: - Etude (SAN, R\u00e9seau, Driver des Windows) et Migration de cluster d\u2019origine 4 clusters de 3 n\u0153uds avec chacun 2 instances en Windows 2008 R2 + SQL Server 2008 6To, tout en changeant de Datacenter. Toutes les technologies utlis\u00e9es ont \u00e9t\u00e9 script\u00e9es baches et powershell pour \u00eatre reproduite sur la destination &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[],"class_list":["post-3246","post","type-post","status-publish","format-standard","hentry","category-clients","no-thumb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Betclic - TEAMVIDIA<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.teamvidia.com\/?p=3246\" \/>\r\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Betclic - TEAMVIDIA\" \/>\r\n<meta property=\"og:description\" content=\"Projets de production majeur: - Etude (SAN, R\u00e9seau, Driver des Windows) et Migration de cluster d\u2019origine 4 clusters de 3 n\u0153uds avec chacun 2 instances en Windows 2008 R2 + SQL Server 2008 6To, tout en changeant de Datacenter. Toutes les technologies utlis\u00e9es ont \u00e9t\u00e9 script\u00e9es baches et powershell pour \u00eatre reproduite sur la destination &hellip;\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.teamvidia.com\/?p=3246\" \/>\r\n<meta property=\"og:site_name\" content=\"TEAMVIDIA\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-02-05T17:42:51+00:00\" \/>\r\n<meta property=\"og:image\" content=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png\" \/>\r\n<meta name=\"author\" content=\"teamvidia\" \/>\r\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"teamvidia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246\"},\"author\":{\"name\":\"teamvidia\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"headline\":\"Betclic\",\"datePublished\":\"2017-02-05T17:42:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246\"},\"wordCount\":441,\"image\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png\",\"articleSection\":[\"clients\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246\",\"url\":\"https:\/\/www.teamvidia.com\/?p=3246\",\"name\":\"Betclic - TEAMVIDIA\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png\",\"datePublished\":\"2017-02-05T17:42:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.teamvidia.com\/?p=3246\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246#primaryimage\",\"url\":\"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png\",\"contentUrl\":\"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png\",\"width\":150,\"height\":51},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3246#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.teamvidia.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Betclic\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.teamvidia.com\/#website\",\"url\":\"https:\/\/www.teamvidia.com\/\",\"name\":\"TEAMVIDIA\",\"description\":\"Experts Base de Donn\u00e9es\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.teamvidia.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\",\"name\":\"teamvidia\",\"url\":\"https:\/\/www.teamvidia.com\/?author=1\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Betclic - TEAMVIDIA","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.teamvidia.com\/?p=3246","og_locale":"fr_FR","og_type":"article","og_title":"Betclic - TEAMVIDIA","og_description":"Projets de production majeur: - Etude (SAN, R\u00e9seau, Driver des Windows) et Migration de cluster d\u2019origine 4 clusters de 3 n\u0153uds avec chacun 2 instances en Windows 2008 R2 + SQL Server 2008 6To, tout en changeant de Datacenter. Toutes les technologies utlis\u00e9es ont \u00e9t\u00e9 script\u00e9es baches et powershell pour \u00eatre reproduite sur la destination &hellip;","og_url":"https:\/\/www.teamvidia.com\/?p=3246","og_site_name":"TEAMVIDIA","article_published_time":"2017-02-05T17:42:51+00:00","og_image":[{"url":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png","type":"","width":"","height":""}],"author":"teamvidia","twitter_misc":{"\u00c9crit par":"teamvidia","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamvidia.com\/?p=3246#article","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/?p=3246"},"author":{"name":"teamvidia","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"headline":"Betclic","datePublished":"2017-02-05T17:42:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=3246"},"wordCount":441,"image":{"@id":"https:\/\/www.teamvidia.com\/?p=3246#primaryimage"},"thumbnailUrl":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png","articleSection":["clients"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/www.teamvidia.com\/?p=3246","url":"https:\/\/www.teamvidia.com\/?p=3246","name":"Betclic - TEAMVIDIA","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=3246#primaryimage"},"image":{"@id":"https:\/\/www.teamvidia.com\/?p=3246#primaryimage"},"thumbnailUrl":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png","datePublished":"2017-02-05T17:42:51+00:00","author":{"@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"breadcrumb":{"@id":"https:\/\/www.teamvidia.com\/?p=3246#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamvidia.com\/?p=3246"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.teamvidia.com\/?p=3246#primaryimage","url":"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png","contentUrl":"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/betclic-logo-2.png","width":150,"height":51},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamvidia.com\/?p=3246#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.teamvidia.com\/"},{"@type":"ListItem","position":2,"name":"Betclic"}]},{"@type":"WebSite","@id":"https:\/\/www.teamvidia.com\/#website","url":"https:\/\/www.teamvidia.com\/","name":"TEAMVIDIA","description":"Experts Base de Donn\u00e9es","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamvidia.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96","name":"teamvidia","url":"https:\/\/www.teamvidia.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3246"}],"version-history":[{"count":1,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3246\/revisions"}],"predecessor-version":[{"id":3248,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3246\/revisions\/3248"}],"wp:attachment":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}