{"id":10952,"date":"2010-08-04T14:27:22","date_gmt":"2010-08-04T14:27:22","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/bharry\/2010\/08\/04\/windows-and-sql-patches-for-tfs\/"},"modified":"2018-08-13T22:45:34","modified_gmt":"2018-08-13T22:45:34","slug":"windows-and-sql-patches-for-tfs-2","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/bharry\/windows-and-sql-patches-for-tfs-2\/","title":{"rendered":"Windows and SQL Patches for TFS"},"content":{"rendered":"<p>My post on TFS updates a couple of weeks ago generated an internal discussion that resulted in the collection of all of the SQL and Windows updates we&rsquo;ve had to apply to our Dogfood server to get it running well.&nbsp; Now, you have to remember that our dogfood server runs at incredibly high scale and many of the issues we&rsquo;ve hit are unlikely to affect you.&nbsp; However, if you really want to be sure you are running your production server as optimally as we run ours, here&rsquo;s some information that may be useful to you:<\/p>\n<h3>App Tier on Windows 2008 R2<\/h3>\n<p><a href=\"http:\/\/support.microsoft.com\/kb\/981898\">http:\/\/support.microsoft.com\/kb\/981898<\/a> &ndash; There was an IIS race condition that would occasionally cause TFS file downloads to fail.<\/p>\n<h3>Data in SQL 2008 SP1<\/h3>\n<p><a href=\"http:\/\/support.microsoft.com\/kb\/973602\">SQL 2008 SP1 <b>CU4<\/b><\/a> &ndash; includes fixes for <a href=\"http:\/\/support.microsoft.com\/kb\/970823\/\">http:\/\/support.microsoft.com\/kb\/970823\/<\/a> (a performance issue) and <a href=\"http:\/\/support.microsoft.com\/kb\/970133\/\">http:\/\/support.microsoft.com\/kb\/970133\/<\/a> (a backup hanging issue)\n&nbsp;<\/p>\n<h3>Data in SQL 2008 R2 (which is what we are currently running)<\/h3>\n<p><a href=\"http:\/\/support.microsoft.com\/kb\/2072493\">SQL 2008 R2 CU2<\/a> &ndash; includes a fix for <a href=\"http:\/\/support.microsoft.com\/?id=982850\">http:\/\/support.microsoft.com\/?id=982850<\/a> that can cause Excel date filters to not work.<\/p>\n<p>Brian<\/p>\n","protected":false},"excerpt":{"rendered":"<p>My post on TFS updates a couple of weeks ago generated an internal discussion that resulted in the collection of all of the SQL and Windows updates we&rsquo;ve had to apply to our Dogfood server to get it running well.&nbsp; Now, you have to remember that our dogfood server runs at incredibly high scale and [&hellip;]<\/p>\n","protected":false},"author":244,"featured_media":14617,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[5],"class_list":["post-10952","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-tfs"],"acf":[],"blog_post_summary":"<p>My post on TFS updates a couple of weeks ago generated an internal discussion that resulted in the collection of all of the SQL and Windows updates we&rsquo;ve had to apply to our Dogfood server to get it running well.&nbsp; Now, you have to remember that our dogfood server runs at incredibly high scale and [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/10952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/users\/244"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/comments?post=10952"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/10952\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/media\/14617"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/media?parent=10952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=10952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=10952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}