{"id":3179,"date":"2012-03-07T17:19:18","date_gmt":"2012-03-07T16:19:18","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=3179"},"modified":"2019-09-13T14:29:08","modified_gmt":"2019-09-13T13:29:08","slug":"production-sql-server-ordonnancement","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/","title":{"rendered":"Production SQL Server : Ordonnancement"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3179&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3179&#038;title=Production%20SQL%20Server%20%3A%20Ordonnancement\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Production%20SQL%20Server%20%3A%20Ordonnancement&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3179\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><p>Second article de la s\u00e9rie <a href=\"http:\/\/blog.capdata.fr\/index.php\/une-approche-pragmatique-de-la-production-sql-server\">Une approche pragmatique de la production SQL Server<\/a>, il s\u2019agit ici de voir comment g\u00e9rer efficacement l\u2019automatisation des t\u00e2ches de maintenance.<br \/>\nInutile de r\u00e9inventer la roue:<\/p>\n<ul>\n<li>Si un      ordonnanceur est d\u00e9j\u00e0 en place dans le Syst\u00e8me d\u2019Informations ($Universe,      Control-M, OPC&#8230;), le suivi des t\u00e2ches ordonnanc\u00e9es est \u00a0a priori      d\u00e9j\u00e0 assur\u00e9. Les t\u00e2ches de maintenance SQL Server seront donc g\u00e9r\u00e9es      (d\u00e9ploy\u00e9es, ex\u00e9cut\u00e9es, surveill\u00e9es) par une \u00e9quipe experte.<\/li>\n<li>Sinon,      l\u2019ordonnanceur de SQL Server, SQL Agent, convient tout \u00e0 fait, \u00e0 condition      de mettre en place la remont\u00e9 des erreurs d\u2019ex\u00e9cution de t\u00e2ches et de      surveiller que l\u2019Agent est toujours op\u00e9rationnel. L\u2019utilisation du      m\u00e9canisme \u00a0natif centralisation de t\u00e2ches SQL Agent, MSX\/TSX, facilitera      le d\u00e9ploiement et la mise \u00e0 jour des t\u00e2ches (voir par exemple <a href=\"http:\/\/msdn.microsoft.com\/fr-fr\/library\/ms180992.aspx\">cet article <\/a> pour la mise en place de MST\/TSX).<\/li>\n<\/ul>\n<p>La t\u00e2che ex\u00e9cut\u00e9e par l\u2019ordonnanceur doit \u00eatre la plus g\u00e9n\u00e9rique possible pour que sa maintenance reste simple. Pas question par exemple d\u2019avoir \u00e0 mentionner \u00e0 chaque appel le nom des bases sur lesquelles effectuer les sauvegardes.<br \/>\nIl existe un moyen simple de r\u00e9pondre \u00e0 ce besoin: la table de param\u00e8tre.<br \/>\nSur toutes les instances du parc, une table contenant les param\u00e8tres de chaque t\u00e2che permettra de d\u00e9finir le p\u00e9rim\u00e8tre et les options de chaque t\u00e2che:<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" width=\"521\">\n<tbody>\n<tr>\n<td valign=\"top\">TACHE<\/td>\n<td valign=\"top\">PARAMETRE<\/td>\n<td valign=\"top\">CIBLE<\/td>\n<td valign=\"top\">VALEUR<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">\u2018Sauvegarde\u2019<\/td>\n<td valign=\"top\">\u2018Chemin\u2019<\/td>\n<td valign=\"top\">\u2018D\u00e9faut\u2019<\/td>\n<td valign=\"top\">\u2018E:\\sauvegardes\u2019<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">\u2018Sauvegarde\u2019<\/td>\n<td valign=\"top\">\u2018Chemin\u2019<\/td>\n<td valign=\"top\">\u2018model\u2019<\/td>\n<td valign=\"top\">\u2018C:\\temp\u2019<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">\u2018Sauvegarde\u2019<\/td>\n<td valign=\"top\">\u2018Exclusion\u2019<\/td>\n<td valign=\"top\">\u2018base_temp\u2019<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>En se basant sur l\u2019exemple, la t\u00e2che de sauvegarde se d\u00e9roule donc comme ceci:<br \/>\n<em>Pour chaque base:<\/em><br \/>\n<em> <\/em><em>S\u2019il existe une ligne \u2018Sauvegarde\u2019, \u2018Exclusion\u2019, &lt;nom de la base&gt; alors je ne sauvegarde pas cette base<\/em><br \/>\n<em> <\/em><em>S\u2019il existe une ligne \u2018Sauvegarde\u2019, \u2018Chemin\u2019, &lt;nom de la base&gt; alors j\u2019utilise le chemin indiqu\u00e9.<\/em><br \/>\n<em> <\/em><em>Sinon, j\u2019utilise le chemin indiqu\u00e9 dans la ligne \u2018Sauvegarde\u2019, \u2018Chemin\u2019, \u2018D\u00e9faut\u2019<\/em><\/p>\n<p>Pour que la t\u00e2che soit maintenable facilement, deux possibilit\u00e9s:<\/p>\n<ul>\n<li>Le      script ex\u00e9cut\u00e9 est stock\u00e9 sur un r\u00e9pertoire partag\u00e9, accessible par tous      les SQL Agent du parc. La d\u00e9finition du script n\u2019est pas dupliqu\u00e9e, il      n\u2019existe donc qu\u2019une seule version.<\/li>\n<li>Le      script se contente d\u2019appeler une Proc\u00e9dure Stock\u00e9e, d\u00e9ploy\u00e9e sur chaque      instance. Cette m\u00e9thode a ma pr\u00e9f\u00e9rence puisque le DBA aura acc\u00e8s depuis      Management Studio au code et pourra facilement ex\u00e9cuter ces t\u00e2ches      manuellement.<\/li>\n<\/ul>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3179&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3179&#038;title=Production%20SQL%20Server%20%3A%20Ordonnancement\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Production%20SQL%20Server%20%3A%20Ordonnancement&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F3179\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>Second article de la s\u00e9rie Une approche pragmatique de la production SQL Server, il s\u2019agit ici de voir comment g\u00e9rer efficacement l\u2019automatisation des t\u00e2ches de maintenance. Inutile de r\u00e9inventer la roue: Si un ordonnanceur est d\u00e9j\u00e0 en place dans le&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":14,"featured_media":7895,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[206,212],"class_list":["post-3179","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-howto","tag-production"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Production SQL Server : Ordonnancement - Capdata TECH 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:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Production SQL Server : Ordonnancement - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Second article de la s\u00e9rie Une approche pragmatique de la production SQL Server, il s\u2019agit ici de voir comment g\u00e9rer efficacement l\u2019automatisation des t\u00e2ches de maintenance. Inutile de r\u00e9inventer la roue: Si un ordonnanceur est d\u00e9j\u00e0 en place dans le&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-07T16:19:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T13:29:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2012\/03\/calendar.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"670\" \/>\n\t<meta property=\"og:image:height\" content=\"335\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Benjamin VESAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin VESAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/\"},\"author\":{\"name\":\"Benjamin VESAN\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e\"},\"headline\":\"Production SQL Server : Ordonnancement\",\"datePublished\":\"2012-03-07T16:19:18+00:00\",\"dateModified\":\"2019-09-13T13:29:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/\"},\"wordCount\":440,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"howto\",\"Production\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/\",\"name\":\"Production SQL Server : Ordonnancement - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2012-03-07T16:19:18+00:00\",\"dateModified\":\"2019-09-13T13:29:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Production SQL Server : Ordonnancement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e\",\"name\":\"Benjamin VESAN\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/bvesan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Production SQL Server : Ordonnancement - Capdata TECH 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:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/","og_locale":"fr_FR","og_type":"article","og_title":"Production SQL Server : Ordonnancement - Capdata TECH BLOG","og_description":"Second article de la s\u00e9rie Une approche pragmatique de la production SQL Server, il s\u2019agit ici de voir comment g\u00e9rer efficacement l\u2019automatisation des t\u00e2ches de maintenance. Inutile de r\u00e9inventer la roue: Si un ordonnanceur est d\u00e9j\u00e0 en place dans le&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2012-03-07T16:19:18+00:00","article_modified_time":"2019-09-13T13:29:08+00:00","og_image":[{"width":670,"height":335,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2012\/03\/calendar.jpg","type":"image\/jpeg"}],"author":"Benjamin VESAN","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Benjamin VESAN","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/"},"author":{"name":"Benjamin VESAN","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e"},"headline":"Production SQL Server : Ordonnancement","datePublished":"2012-03-07T16:19:18+00:00","dateModified":"2019-09-13T13:29:08+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/"},"wordCount":440,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["howto","Production"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/","url":"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/","name":"Production SQL Server : Ordonnancement - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2012-03-07T16:19:18+00:00","dateModified":"2019-09-13T13:29:08+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/production-sql-server-ordonnancement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Production SQL Server : Ordonnancement"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e","name":"Benjamin VESAN","url":"https:\/\/blog.capdata.fr\/index.php\/author\/bvesan\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/3179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=3179"}],"version-history":[{"count":13,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/3179\/revisions"}],"predecessor-version":[{"id":3250,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/3179\/revisions\/3250"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7895"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=3179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=3179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=3179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}