{"id":1645,"date":"2010-08-25T17:13:42","date_gmt":"2010-08-25T16:13:42","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=1645"},"modified":"2019-09-13T14:52:15","modified_gmt":"2019-09-13T13:52:15","slug":"saines-lectures","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/","title":{"rendered":"Saines lectures"},"content":{"rendered":"\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>

Une autre question fr\u00e9quemment pos\u00e9e en formation et d’ordre plus g\u00e9n\u00e9ral concerne les lectures conseill\u00e9es sur SQL Server et les sujets associ\u00e9s. La liste qui suit n’engage bien \u00e9videmment que moi.<\/p>\n

Les bouquins<\/h2>\n

En g\u00e9n\u00e9ral les stagiaires rechignent toujours autant \u00e0 se mettre \u00e0 l’anglais, et c’est bien dommage car la plupart du temps la doc est en anglais et n’est souvent pas traduite du tout. Pour les bouquins en fran\u00e7ais sur SQL Server je ne saurais que trop recommander de lire des livres \u00e9crits par des fran\u00e7ais car les traductions sont parfois hasardeuses. Personnellement je ne connais que celui de Rudi Bruchez<\/a>, c’est le seul qui rentre un peu dans les d\u00e9tails.<\/p>\n

Mon exemplaire de Guru’s Guide for SQL Server Architecture and Internals<\/a> de Ken Henderson<\/a> est tellement noirci de notes et de commentaires qu’il n’est presque plus lisible. A chaque relecture je suis souffl\u00e9 par le niveau de d\u00e9tail et la qualit\u00e9 des exemples qu’il apporte pour d\u00e9montrer la fa\u00e7on dont le moteur est construit. Jusqu’ici, personne n’a r\u00e9ussi \u00e0 arriver au quart du dixi\u00e8me de la cheville de ce qu’il montre. Toute personne d\u00e9sirant vraiment plonger dans le moteur devrait l’avoir sur son bureau.<\/p>\n

SQL Server 2005 Practical Troubleshooting Guide<\/a> a \u00e9t\u00e9 r\u00e9dig\u00e9 sous la baguette de mister Henderson encore lui, par des membres de l’\u00e9quipe de d\u00e9veloppement de SQL Server (Slava Oks, Santeri Voutilainen, Sameer Teijani, Cesar Galindo-Legaria,\u00a0 etc…) ainsi que des membres du support (Bob Ward, Bart Duncan, Cindy Gross). Chacun parle de son domaine d’expertise, Santeri de la partie Waits, Slava de SQLOS et de la gestion de la m\u00e9moire, Sameer du scheduling, Cindy Gross du cluster, et Bob Ward nous livre deux chapitres magistraux sur le d\u00e9bogage, la lecture de minidumps, des tonnes d’informations qu’on ne trouve nulle part ailleurs sur le net. L\u00e0 encore un must-read pour tous ceux qui souhaitent approfondir le sujet.<\/p>\n

SQL Server 2008 Internals<\/a>: Le dernier en date vraiment int\u00e9ressant, r\u00e9dig\u00e9 par les stars du moment (Randal \/ Tripp \/ Delaney \/ Machanic \/ Cunningham). L\u00e0 encore, chaque personne parle de ce qu’il conna\u00eet le mieux, Kim Tripp des indexes, Paul Randal de DBCC CHECKDB,\u00a0 Conor Cunningham de l’optimiseur et Adam Machanic de la partie tracing. Kalen Delaney se charge d’envoyer tout le reste comme \u00e0 son habitude avec une extr\u00eame clart\u00e9. C’est le moins profond des trois, mais on se fait quand m\u00eame des bonnes migraines.<\/p>\n

Au del\u00e0 de ces trois l\u00e0, je ne vois pas ce qu’il pourrait y avoir d’autre \u00e0 raconter sur le moteur. Peut \u00eatre les livres d’Allan Hirt<\/a> sur le cluster SQL Server, d’Itzik Ben-Gan<\/a> sur Transact-SQL et celui d’Hillary Cotter<\/a> sur la r\u00e9plication, il faudrait qu’il en r\u00e9\u00e9crive un sur la version 2008 un jour.<\/p>\n

Je n’ai pas encore lu le bouquin <\/a>auquel ont particip\u00e9 John Kehayias, James Rowland Jones et Brent Ozar, si quelqu’un veut donner son avis dans les commentaires.<\/p>\n

Les blogs:<\/h2>\n

Le probl\u00e8me des blogs, c’est qu’il y en a tellement qu’on ne peut pas tous les suivre, et que les plus int\u00e9ressants sont aussi souvent les plus actifs.<\/p>\n

Les blogs en fran\u00e7ais:<\/strong><\/p>\n

– Mikedavem<\/a>.
\n– Fr\u00e9d\u00e9ric Brouard<\/a>.
\n– Christian Robert<\/a>.
\n– Rudi Bruchez<\/a>.
\n– SQLPac<\/a>.<\/p>\n

Les blogs US:<\/strong><\/p>\n

– PSS<\/a>.
\n– SQL Server Support Team<\/a>.
\n– SQL Server Storage Engine Team<\/a>
\n– SQL Server Relationnal Engine team<\/a>.
\n– SQLCLR Support team<\/a>.
\n– Micheal Wories<\/a> (SQLPS)
\n– SQLSKILLS<\/a>.
\n– Craig Freedman.<\/a>
\n– Liste \u00e9tendue<\/a>.<\/p>\n

Sur Windows:<\/h2>\n

– Windows Internals, 5th edition<\/a>, de Mark Russinovich et Dave Solomon.
\n– Le blog de Mark Russinovich<\/a>.<\/p>\n

Les videos:<\/h2>\n

– Les interviews des d\u00e9veloppeurs et architectes\u00a0 Windows sur Channel 9:<\/strong>
\n– Dave Probert.<\/a> (Kernel)
\n– Arun Kishan<\/a>. (Scheduling & Dispatcher lock)
\n– Neal Christiansen<\/a> (Filter Driver Manager)
\n– Molly Brown<\/a>. (Cache Manager)
\n– Nar Ganapathy<\/a>.\u00a0 (IO Manager)
\n– Mark Russinovich<\/a>. (Windows 7 kernel)
\n– Rob Short<\/a>. (Vista Kernel)
\n– Landy Wang<\/a>. (Memory Manager)<\/p>\n

– Videos sur SQL Server :<\/strong>
\n– Interview de Dave Campbell<\/a> sur Channel9 (SQL Azure).
\n– Interview de Jim Gray<\/a> en 2005.
\n– Euan Garden fait la visite des bureaux du building\u00a0 35\u00a0 –\u00a0 Part I<\/a> – II<\/a> – III<\/a> –IV<\/a>.
\n– Engagez-vous<\/a> qu’y disaient.<\/p>\n

Il existait aussi une tonne de vid\u00e9os de la TechEd 2008 sur Spotlight malheureusement elles ont toutes \u00e9t\u00e9 retir\u00e9es.<\/p>\n

A+ David B.<\/p>\n\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"

Une autre question fr\u00e9quemment pos\u00e9e en formation et d’ordre plus g\u00e9n\u00e9ral concerne les lectures conseill\u00e9es sur SQL Server et les sujets associ\u00e9s. La liste qui suit n’engage bien \u00e9videmment que moi. Les bouquins En g\u00e9n\u00e9ral les stagiaires rechignent toujours autant… Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":7937,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[176],"class_list":["post-1645","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-livres"],"yoast_head":"\nSaines lectures - 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\/saines-lectures\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Saines lectures - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Une autre question fr\u00e9quemment pos\u00e9e en formation et d’ordre plus g\u00e9n\u00e9ral concerne les lectures conseill\u00e9es sur SQL Server et les sujets associ\u00e9s. La liste qui suit n’engage bien \u00e9videmment que moi. Les bouquins En g\u00e9n\u00e9ral les stagiaires rechignent toujours autant… Continuer la lecture →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-25T16:13:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T13:52:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2010\/08\/bookshelf.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"612\" \/>\n\t<meta property=\"og:image:height\" content=\"408\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"4 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\/saines-lectures\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/\"},\"author\":{\"name\":\"David Baffaleuf\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\"},\"headline\":\"Saines lectures\",\"datePublished\":\"2010-08-25T16:13:42+00:00\",\"dateModified\":\"2019-09-13T13:52:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/\"},\"wordCount\":729,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"livres\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/\",\"name\":\"Saines lectures - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2010-08-25T16:13:42+00:00\",\"dateModified\":\"2019-09-13T13:52:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Saines lectures\"}]},{\"@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":"Saines lectures - 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\/saines-lectures\/","og_locale":"fr_FR","og_type":"article","og_title":"Saines lectures - Capdata TECH BLOG","og_description":"Une autre question fr\u00e9quemment pos\u00e9e en formation et d’ordre plus g\u00e9n\u00e9ral concerne les lectures conseill\u00e9es sur SQL Server et les sujets associ\u00e9s. La liste qui suit n’engage bien \u00e9videmment que moi. Les bouquins En g\u00e9n\u00e9ral les stagiaires rechignent toujours autant… Continuer la lecture →","og_url":"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2010-08-25T16:13:42+00:00","article_modified_time":"2019-09-13T13:52:15+00:00","og_image":[{"width":612,"height":408,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2010\/08\/bookshelf.jpg","type":"image\/jpeg"}],"author":"David Baffaleuf","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"David Baffaleuf","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/"},"author":{"name":"David Baffaleuf","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf"},"headline":"Saines lectures","datePublished":"2010-08-25T16:13:42+00:00","dateModified":"2019-09-13T13:52:15+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/"},"wordCount":729,"commentCount":1,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["livres"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/","url":"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/","name":"Saines lectures - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2010-08-25T16:13:42+00:00","dateModified":"2019-09-13T13:52:15+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/saines-lectures\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Saines lectures"}]},{"@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\/1645","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=1645"}],"version-history":[{"count":50,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/1645\/revisions"}],"predecessor-version":[{"id":7938,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/1645\/revisions\/7938"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7937"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=1645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=1645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=1645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}