tag:blogger.com,1999:blog-58986747388682083572011-11-28T00:44:50.955ZI didn't know what I didn't know. A blog about SQL Server and things I simply did not know. But do now. Well, er, until I forget that is. From John Parker, an occasional expert in the subject. Until he forgets.John Parkerhttp://www.blogger.com/profile/14256711100378423741noreply@blogger.comBlogger71100tag:blogger.com,1999:blog-5898674738868208357.post-33552614692800214652010-06-16T09:21:00.002+01:002010-06-16T09:26:12.263+01:00So I've now got the 70-432, the <span class="goog-spellcheck-word" style="background: none repeat scroll 0% 0% yellow;">MCTS</span> exam on my CV, great.&nbsp; I have to get one more to become <span class="goog-spellcheck-word" style="background: none repeat scroll 0% 0% yellow;">MCITP</span> certified in <span class="goog-spellcheck-word" style="background: none repeat scroll 0% 0% yellow;">SQL</span> Server 2008 Database Administration.&nbsp; Let's check out the preparation materials...<br /><div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/_a1O_ImiZoXQ/TBiH80B8ukI/AAAAAAAAAyI/XjFktgHOwfI/s1600/70-450Prep.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a><a href="http://2.bp.blogspot.com/_a1O_ImiZoXQ/TBiKRWuawCI/AAAAAAAAAyo/MzQKYc6p7KQ/s1600/450-preparation.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="http://2.bp.blogspot.com/_a1O_ImiZoXQ/TBiKRWuawCI/AAAAAAAAAyo/MzQKYc6p7KQ/s640/450-preparation.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><br />Er, looks like I won't be doing this exam then.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5898674738868208357-3355261469280021465?l=sql-server-database.blogspot.com' alt='' /></div>John Parkerhttp://www.blogger.com/profile/14256711100378423741noreply@blogger.com0tag:blogger.com,1999:blog-5898674738868208357.post-42350228703552116592010-06-16T09:10:00.000+01:002010-06-16T09:10:24.881+01:00I normally use the book and question CD to get through a Microsoft <span class="goog-spellcheck-word" style="background: none repeat scroll 0% 0% yellow;">SQL</span> Server exam, so far they have all been very good at matching the content of the exam.&nbsp; However, I studied using the <span class="goog-spellcheck-word" style="background: none repeat scroll 0% 0% yellow;">SQL</span> Server 2008 Implementation and Maintenance Training Kit and although I thought it was a good book, it didn't really match the exam.&nbsp; For example I had a couple of questions on Reporting Services.&nbsp; And in the book, it has a 1 page overview on this topic.<br /><br />I managed to pass though and am relieved to have done so, I had a free second shot voucher, but further revision wouldn't have solved my knowledge gaps as the book wasn't that relevant.&nbsp; And this is very disappointing.&nbsp; Let's hope this is because less effort went into the 2008 certifications rather than a future trend.&nbsp; I enjoy the certification process and didn't enjoy this one.&nbsp; It made my revision feel pointless. Rant over.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5898674738868208357-4235022870355211659?l=sql-server-database.blogspot.com' alt='' /></div>John Parkerhttp://www.blogger.com/profile/14256711100378423741noreply@blogger.com0tag:blogger.com,1999:blog-5898674738868208357.post-5314863291880891432010-06-15T15:53:00.000+01:002010-06-15T15:53:01.237+01:00That's right, starting with <span class="goog-spellcheck-word" style="background: none repeat scroll 0% 0% yellow;">SQL</span> Server 2008, service packs can now be <span class="goog-spellcheck-word" style="background: none repeat scroll 0% 0% yellow;">uninstalled</span>.&nbsp; Hurrah.&nbsp; About time too!<br /><br />Many thanks to Peter for this I didn't know tip. You know who you are.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/_a1O_ImiZoXQ/TBeTuNqKyrI/AAAAAAAAAx4/R0pDW-lsTZo/s1600/SQLServer2008SP1Uninstall.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" src="http://4.bp.blogspot.com/_a1O_ImiZoXQ/TBeTuNqKyrI/AAAAAAAAAx4/R0pDW-lsTZo/s640/SQLServer2008SP1Uninstall.jpg" width="640" /></a></div><br /><br /><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/_a1O_ImiZoXQ/TBeSpHw-_lI/AAAAAAAAAxg/lwjbsLCliow/s1600/SQLServer2008SP1Uninstall.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5898674738868208357-531486329188089143?l=sql-server-database.blogspot.com' alt='' /></div>John Parkerhttp://www.blogger.com/profile/14256711100378423741noreply@blogger.com0tag:blogger.com,1999:blog-5898674738868208357.post-14001698578131256392010-06-09T12:26:00.002+01:002010-06-09T12:26:30.841+01:00.Net Framework 3.5<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5898674738868208357-1400169857813125639?l=sql-server-database.blogspot.com' alt='' /></div>John Parkerhttp://www.blogger.com/profile/14256711100378423741noreply@blogger.com0tag:blogger.com,1999:blog-5898674738868208357.post-77219782645355862762010-06-09T12:25:00.001+01:002010-06-18T07:35:50.742+01:00Windows Server 2008 Core Server because the .NET framework is not supported.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5898674738868208357-7721978264535586276?l=sql-server-database.blogspot.com' alt='' /></div>John Parkerhttp://www.blogger.com/profile/14256711100378423741noreply@blogger.com0tag:blogger.com,1999:blog-5898674738868208357.post-85288698491653102232010-06-09T12:23:00.003+01:002010-06-18T07:35:45.154+01:00requires Service Pack 2 on Windows Server 2003<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5898674738868208357-8528869849165310223?l=sql-server-database.blogspot.com' alt='' /></div>John Parkerhttp://www.blogger.com/profile/14256711100378423741noreply@blogger.com0tag:blogger.com,1999:blog-5898674738868208357.post-88263040988331452212010-06-09T12:22:00.001+01:002010-06-18T07:35:37.980+01:00can be achieved by using a technology called Windows on Windows (WOW). Apparently performance sucks, so don't do it.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5898674738868208357-8826304098833145221?l=sql-server-database.blogspot.com' alt='' /></div>John Parkerhttp://www.blogger.com/profile/14256711100378423741noreply@blogger.com0