{"id":2673,"date":"2011-07-07T09:25:28","date_gmt":"2011-07-07T08:25:28","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=2673"},"modified":"2019-09-13T14:37:57","modified_gmt":"2019-09-13T13:37:57","slug":"how-to-reduire-lenveloppe-de-tempdb","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/","title":{"rendered":"How-To : r\u00e9duire l’enveloppe de tempdb"},"content":{"rendered":"\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>

Pour r\u00e9\u00e9quilibrer un peu le discours global des articles, dans lesquels on essaie d’aborder des sujets tr\u00e8s peu \u00e9tay\u00e9s sur le net, et qui du coup peuvent para\u00eetre parfois obscurs \u00e0 celui qui cherche juste comment\u00a0 r\u00e9duire son journal de transactions o\u00f9 changer son compte de service, nous allons partir sur une autre s\u00e9rie de How-To sur des actions basiques, avec des d\u00e9mos sous la forme de petites vid\u00e9os. Et ce pour deux raisons principales:<\/p>\n

– C’est plus pratique pour nous ;-). Il m’est arriv\u00e9 de passer plusieurs semaines sur un seul article donc \u00e7a ne va pas faire de mal de parler de choses communes, et en plus s’il y a une d\u00e9mo \u00e0 l’appui…
\n– \u00c7a parle \u00e0 plus de gens. Je suis conscient qu’on ne doit pas \u00eatre tr\u00e8s nombreux \u00e0 s’int\u00e9resser aux schedulers non-pr\u00e9emptifs et aux IO completion ports (re- \ud83d\ude09 ).<\/p>\n

Ces articles seront tagg\u00e9s ‘howto<\/strong><\/em>‘ dans le nuage de tags, vous pourrez donc les retrouver tous facilement. Pour ce premier, on va parler d’un sujet qui revient de temps en temps dans les forums, \u00e0 savoir comment faire pour r\u00e9duire la taille de tempdb sur SQL 2005 et SQL 2008.<\/p>\n

Sur SQL Server 2005:<\/h2>\n

Parce que \u00e7a a l’air trivial comme \u00e7a, en th\u00e9orie. Vous vous dites, trop facile je fais un dbcc shrinkfile du ou des fichiers de donn\u00e9es de tempdb. Ou alors je fais un ALTER DATABASE tempdb MODIFY FILE (NAME=…, SIZE=…) et je red\u00e9marre.<\/p>\n

Voyons voir:<\/p>\n

select serverproperty('productversion')\r\n<\/span>-- Taille initiale<\/span><\/span>\r\nSELECT size\/128 FROM master.sys.master_files WHERE file_id=1 and database_id=2 <\/span>\r\n<\/span> -- Taille courante<\/span><\/span>\r\nselect size\/128 from tempdb.sys.database_files WHERE file_id=1\r\n<\/span><\/pre>\n
---------------------------\r\n9.00.4035.00\r\n<\/span>\r\n---------------------------\r\n<\/span>1699\r\n<\/span>\r\n---------------------------\r\n1699<\/span><\/em>\r\n<\/span><\/pre>\n
alter database tempdb modify file(name='tempdev',size=500MB)<\/span>\r\n\r\nMsg\u00a05039, Niveau\u00a016, \u00c9tat\u00a01, Ligne\u00a02\r\n\u00c9chec de MODIFY FILE. La taille sp\u00e9cifi\u00e9e est inf\u00e9rieure \u00e0 la taille en cours.<\/span><\/em><\/pre>\n
Dans cette version de SQL Server, la base tempdb est consid\u00e9r\u00e9e comme les autres bases: on ne peut pas r\u00e9duire l’enveloppe \u00e0 une valeur inf\u00e9rieure \u00e0 la taille en cours. Quant au DBCC SHRINKFILE \/ SHRINKDATABASE, il ne va fonctionner que sur une base sans activit\u00e9, or sur une instance en production, il y a toujours de l’activit\u00e9 dans tempdb: tris, agr\u00e9gats, tables temporaires, version store, etc… Toute cette activit\u00e9 va le plus souvent emp\u00eacher DBCC SHRINKFILE de r\u00e9duire l’enveloppe \u00e0 la taille d\u00e9sir\u00e9e:<\/p>\n
select name,size\/128 from master.sys.master_files where database_id=2 and file_id=1\r\nGO\r\n<\/span>\r\n<\/em>-----------------\r\n1699\r\n\r\n<\/em><\/span>dbcc shrinkfile('tempdev',500)\r\nGO\r\n\r\nDbId\tFileId\tCurrentSize\tMinimumSize\tUsedPages\tEstimatedPages\r\n------- ------- --------------  --------------- --------------  --------------\r\n2\t1\t200200\t         1024\t         200192\t         200192<\/em><\/span><\/pre>\n
Les tailles sont exprim\u00e9es en nombre de pages. Taille en Mb = 200200\/128 = 1564 Mb, donc on n’a pas r\u00e9cup\u00e9r\u00e9 grand chose. Vous pouvez tenter le shrinkfile avec moins d’activit\u00e9 si vous ne souhaitez pas une interruption de service, mais si \u00e7a ne fonctionne pas, il n’y qu’une seule fa\u00e7on de r\u00e9gler le probl\u00e8me: il faut red\u00e9marrer l’instance avec la configuration minimale:<\/p>\n
D\u00e9marrer SQL Server manuellement dans un prompt DOS en utilisant les options -f -c:<\/p>\n
C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Binn>sqlservr -c -f<\/strong>\r\n2011-07-06 07:35:12.17 Server      Microsoft SQL Server 2005 - 9.00.4035.00<\/span> (Intel X86)\r\n        Nov 24 2008 13:01:59\r\n        Copyright (c) 1988-2005 Microsoft Corporation\r\n        Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)\r\n\r\n2011-07-06 07:35:12.18 Server      (c) 2005 Microsoft Corporation.\r\n2011-07-06 07:35:12.18 Server      All rights reserved.\r\n2011-07-06 07:35:12.18 Server      Server process ID is 4076.\r\n2011-07-06 07:35:12.18 Server      Authentication mode is MIXED.\r\n2011-07-06 07:35:12.19 Server      Logging SQL Server messages in file\r\n                                    'V:\\DBA2\\MSSQL.1\\MSSQL\\LOG\\ERRORLOG'.\r\n2011-07-06 07:35:12.19 Server      This instance of SQL Server last reported using a process\r\n                                  ID of 3496 at 06\/07\/2011 07:34:18 (local) 06\/07\/2011 05:34:18\r\n                                  (UTC). This is an informational message only;\r\n no user action is required.\r\n2011-07-06 07:35:12.19 Server      Registry startup parameters:\r\n2011-07-06 07:35:12.19 Server            -d V:\\DBA2\\MSSQL.1\\MSSQL\\DATA\\master.mdf\r\n2011-07-06 07:35:12.20 Server            -e V:\\DBA2\\MSSQL.1\\MSSQL\\LOG\\ERRORLOG\r\n2011-07-06 07:35:12.20 Server            -l V:\\DBA2\\MSSQL.1\\MSSQL\\DATA\\mastlog.ldf\r\n2011-07-06 07:35:12.20 Server      Command Line Startup Parameters:\r\n2011-07-06 07:35:12.20 Server            -c\r\n2011-07-06 07:35:12.20 Server            -f\r\n2011-07-06 07:35:12.26 Server      Warning: The server instance was started using minimal\r\n                                   configuration startup option (-f). Starting an instance\r\n                                   of SQL Server with minimal configuration places the server\r\n                                   in single-user mode automatically.  After the server has been\r\n                                   started with minimal configuration, you should change the appropriate\r\n                                   server option value or values, stop, and then restart the server.<\/span>\r\n2011-07-06 07:35:12.27 Serveur     SQL Server is starting at normal priority base (=7)...\r\n2011-07-06 07:35:12.27 Serveur     Detected 2 CPUs. This is an informational message; no user action is required.\r\n2011-07-06 07:35:12.94 Serveur     Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node...\r\n2011-07-06 07:35:12.96 Serveur     Support for distributed transactions was not enabled for this instance of the Database Engine because it was started using the minimal\r\n                                  configuration option. <\/span>\u00a0<\/span>\r\n2011-07-06 07:35:12.97 spid5s      Starting up database 'master'.\r\n2011-07-06 07:35:13.11 spid5s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.\r\n2011-07-06 07:35:13.16 spid5s      Server started with '-f' option. Auditing will not be started. This is an informational message only; no user action is required.<\/span>\r\n2011-07-06 07:35:13.18 spid5s      Starting up database 'mssqlsystemresource'.\r\n2011-07-06 07:35:13.20 spid5s      The resource database build version is 9.00.4035. This is an informational message only. No user action is required.\r\n2011-07-06 07:35:13.40 spid6s      Starting up database 'model'.\r\n2011-07-06 07:35:13.40 spid5s      Server name is 'DBA2'. This is an informational message only. No user action is required.\r\n(...)<\/span><\/pre>\n
-f indique \u00e0 SQL Server de d\u00e9marrer avec les options minimales et en mode mono utilisateur (pas besoin d’utiliser le mode -m). Dans ce mode, tempdb reprend la taille initiale de la base model (2Mb), donc on va pouvoir faire passer un ALTER DATABASE MODIFY FILE.
\n-c indique que SQL Server ne d\u00e9marre pas en tant que service<\/p>\n
A partir de l\u00e0 on se connecte dans une seconde fen\u00eatre DOS:<\/p>\n
DOS>sqlcmd -E\r\n1> select size\/128 from tempdb.sys.database_files WHERE file_id=1\r\n2> go\r\n\r\n-----------\r\n          2<\/em>\r\n\r\n1> alter database tempdb modify file(name='tempdev',size=500MB)\r\n2> go<\/span>\r\n1> <\/span>exit\r\n<\/span><\/pre>\n
En on red\u00e9marre via SQL Configuration Manager.<\/p>\n
Sur SQL Server 2008:<\/h2>\n
La bonne nouvelle, c’est qu’\u00e0 partir de SQL Server 2008, on n’a plus besoin de red\u00e9marrer en mode minimal, un ALTER DATABASE MODIFY FILE fonctionne avec des tailles inf\u00e9rieures \u00e0 la taille en cours (uniquement sur tempdb):<\/p>\n
select serverproperty('productversion')\r\n-- Taille initiale<\/span>\r\nSELECT size\/128 FROM master.sys.master_files WHERE file_id=1 and database_id=2\r\n -- Taille courante<\/span>\r\nselect size\/128 from tempdb.sys.database_files WHERE file_id=1\r\n\r\n-------------------\r\n10.0.2757.0\r\n\r\n-------------------\r\n1564\r\n\r\n-------------------\r\n1564<\/em>\r\n\r\nalter database tempdb modify file(name='tempdev',size=500MB)\r\n\r\nCommand(s) completed successfully.<\/em><\/span><\/pre>\n
Suivi d’un arr\u00eat \/ red\u00e9marrage de l’instance avec SQL Configuration Manager.<\/p>\n
A suivre un autre how-to SQL Server. A+<\/p>\n
David B.<\/p>\n
Liens:<\/h2>\n
http:\/\/support.microsoft.com\/kb\/307487\/en-us<\/a><\/p>\n
9.00.4035.00<\/div>\n\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"
Pour r\u00e9\u00e9quilibrer un peu le discours global des articles, dans lesquels on essaie d’aborder des sujets tr\u00e8s peu \u00e9tay\u00e9s sur le net, et qui du coup peuvent para\u00eetre parfois obscurs \u00e0 celui qui cherche juste comment\u00a0 r\u00e9duire son journal de… Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":7915,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[206,40],"class_list":["post-2673","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-howto","tag-tempdb"],"yoast_head":"\nHow-To : r\u00e9duire l'enveloppe de tempdb - 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\/how-to-reduire-lenveloppe-de-tempdb\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How-To : r\u00e9duire l'enveloppe de tempdb - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Pour r\u00e9\u00e9quilibrer un peu le discours global des articles, dans lesquels on essaie d’aborder des sujets tr\u00e8s peu \u00e9tay\u00e9s sur le net, et qui du coup peuvent para\u00eetre parfois obscurs \u00e0 celui qui cherche juste comment\u00a0 r\u00e9duire son journal de… Continuer la lecture →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2011-07-07T08:25:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T13:37:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/07\/tempdb2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"657\" \/>\n\t<meta property=\"og:image:height\" content=\"435\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Baffaleuf\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Baffaleuf\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 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\/how-to-reduire-lenveloppe-de-tempdb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/\"},\"author\":{\"name\":\"David Baffaleuf\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\"},\"headline\":\"How-To : r\u00e9duire l’enveloppe de tempdb\",\"datePublished\":\"2011-07-07T08:25:28+00:00\",\"dateModified\":\"2019-09-13T13:37:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/\"},\"wordCount\":580,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"howto\",\"tempdb\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/\",\"name\":\"How-To : r\u00e9duire l'enveloppe de tempdb - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2011-07-07T08:25:28+00:00\",\"dateModified\":\"2019-09-13T13:37:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How-To : r\u00e9duire l’enveloppe de tempdb\"}]},{\"@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\/136297da9f61d6e4878abe0f48bc5fbf\",\"name\":\"David Baffaleuf\",\"sameAs\":[\"http:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How-To : r\u00e9duire l'enveloppe de tempdb - 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\/how-to-reduire-lenveloppe-de-tempdb\/","og_locale":"fr_FR","og_type":"article","og_title":"How-To : r\u00e9duire l'enveloppe de tempdb - Capdata TECH BLOG","og_description":"Pour r\u00e9\u00e9quilibrer un peu le discours global des articles, dans lesquels on essaie d’aborder des sujets tr\u00e8s peu \u00e9tay\u00e9s sur le net, et qui du coup peuvent para\u00eetre parfois obscurs \u00e0 celui qui cherche juste comment\u00a0 r\u00e9duire son journal de… Continuer la lecture →","og_url":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2011-07-07T08:25:28+00:00","article_modified_time":"2019-09-13T13:37:57+00:00","og_image":[{"width":657,"height":435,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/07\/tempdb2.png","type":"image\/png"}],"author":"David Baffaleuf","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"David Baffaleuf","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/"},"author":{"name":"David Baffaleuf","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf"},"headline":"How-To : r\u00e9duire l’enveloppe de tempdb","datePublished":"2011-07-07T08:25:28+00:00","dateModified":"2019-09-13T13:37:57+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/"},"wordCount":580,"commentCount":6,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["howto","tempdb"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/","url":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/","name":"How-To : r\u00e9duire l'enveloppe de tempdb - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2011-07-07T08:25:28+00:00","dateModified":"2019-09-13T13:37:57+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-lenveloppe-de-tempdb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"How-To : r\u00e9duire l’enveloppe de tempdb"}]},{"@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\/136297da9f61d6e4878abe0f48bc5fbf","name":"David Baffaleuf","sameAs":["http:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/2673","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=2673"}],"version-history":[{"count":44,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/2673\/revisions"}],"predecessor-version":[{"id":7916,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/2673\/revisions\/7916"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7915"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=2673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=2673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=2673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}