<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-2194112072206333819</id><updated>2012-02-17T01:40:08.841Z</updated><category term='visual studio'/><category term='messenger'/><category term='outlook'/><category term='cisco'/><category term='office 2007'/><category term='sql'/><category term='debugging'/><category term='photography'/><category term='vmware'/><category term='development'/><category term='vs2010'/><category term='vpn'/><category term='.net'/><category term='review'/><category term='d830'/><category term='nvidia'/><category term='hardware'/><category term='resharper'/><category term='unity'/><category term='windows 7'/><title type='text'>My gap in the void</title><subtitle type='html'>A few of my thoughts...
&lt;p&gt;
&lt;a href="http://www.linkedin.com/in/danielabbatt"&gt;&lt;img src="http://www.linkedin.com/img/webpromo/btn_myprofile_160x33.gif" width="160" height="33" border="0" alt="View Daniel Abbatt&amp;#39;s profile on LinkedIn"&gt;&lt;/a&gt;&lt;/p&gt;</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>19</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-7847780554257102940</id><published>2012-01-24T14:36:00.003Z</published><updated>2012-01-24T14:36:51.247Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='debugging'/><category scheme='http://www.blogger.com/atom/ns#' term='vs2010'/><title type='text'>VS2010 project runs slow when attached to debugger</title><content type='html'>I had an interesting problem occur to me today. I was using a new installation of Visual Studio 2010 Ultimate onto a machine other than my usual development machine. I needed to do some performance analysis on a machine that was nearer to a deployment configuration.&lt;br /&gt;After copying the code project over and running the project as normal inside the debugger, I found it to be extremely slow. General interaction was a bit sluggish, but the chunks of code that did some serious work were crawling. Running the program outside the debugger (CTRL+F5 instead of F5) found the application to run at normal speed.&lt;br /&gt;After a couple of reboots and head scratching, upon investigation I found that people were suggesting to delete any breakpoints, so I went to the debug menu to delete all, but it was greyed out (I assume because no breakpoints were present).&lt;br /&gt;&lt;i&gt;So I added a breakpoint on a line of code and then went to the menu option and removed all breakpoints.&amp;nbsp;&lt;/i&gt;&lt;i&gt;Strangely after this the code started working at full speed.&lt;/i&gt;&lt;br /&gt;&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-7847780554257102940?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/7847780554257102940/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2012/01/vs2010-project-runs-slow-when-attached.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/7847780554257102940'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/7847780554257102940'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2012/01/vs2010-project-runs-slow-when-attached.html' title='VS2010 project runs slow when attached to debugger'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-6055421263072510673</id><published>2012-01-19T09:19:00.000Z</published><updated>2012-01-19T09:20:18.385Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='photography'/><title type='text'>Digital SLR Cheat Sheet</title><content type='html'>Here's a handy cheat sheet that helps quickly remind you of what all those fiddly settings on your shiny new SLR do.&lt;br /&gt;&lt;br /&gt;&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://livinginthestills.tumblr.com/cheatsheet"&gt;&lt;img border="0" height="320" src="http://i.imgur.com/kWAJo.jpg" width="213" /&gt;&lt;span id="goog_253618192"&gt;&lt;/span&gt;&lt;span id="goog_253618193"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;div style="text-align: center;"&gt;&lt;a href="http://livinginthestills.tumblr.com/cheatsheet"&gt;http://livinginthestills.tumblr.com/cheatsheet&lt;/a&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-6055421263072510673?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/6055421263072510673/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2012/01/digital-slr-cheat-sheet.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/6055421263072510673'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/6055421263072510673'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2012/01/digital-slr-cheat-sheet.html' title='Digital SLR Cheat Sheet'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-1276940613883934837</id><published>2012-01-12T11:17:00.001Z</published><updated>2012-01-12T11:17:03.339Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='development'/><category scheme='http://www.blogger.com/atom/ns#' term='resharper'/><category scheme='http://www.blogger.com/atom/ns#' term='vs2010'/><title type='text'>VS2010 Keyboard and Mouse Shortcuts</title><content type='html'>Keyboard and mouse shortcuts are critical to fast coding in VS2010:&lt;br /&gt;&lt;br /&gt;Useful frequently used shortcuts for me are:&lt;br /&gt;Ctrl+K -&amp;gt;&amp;nbsp;Ctrl+C = Comment code&lt;br /&gt;Ctrl+K -&amp;gt;&amp;nbsp;Ctrl+U = Uncomment code&lt;br /&gt;Shift+F12 = Find usages&lt;br /&gt;Ctrl+] = Find matching brace/bracket&lt;br /&gt;F9 - Add/remove breakpoint&lt;br /&gt;F12 - Go to definition&lt;br /&gt;Ctrl+K -&amp;gt; Ctrl+S = Surround code with... choose snippet.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-1276940613883934837?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/1276940613883934837/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2012/01/vs2010-keyboard-and-mouse-shortcuts.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1276940613883934837'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1276940613883934837'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2012/01/vs2010-keyboard-and-mouse-shortcuts.html' title='VS2010 Keyboard and Mouse Shortcuts'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-6620577689929199225</id><published>2011-12-08T08:54:00.001Z</published><updated>2011-12-08T09:01:08.716Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='hardware'/><category scheme='http://www.blogger.com/atom/ns#' term='review'/><title type='text'>Best mouse... ever!</title><content type='html'>I bought a new mouse about 6 months ago and, like with all gadgets, I decided to wait a while before deciding to score it.&lt;br /&gt;Very simply I have to say this is the nicest mouse I've had I think. It's wireless, rechargable (even while using), keeps a good battery life and is very comfortable and responsive. I've used mostly Microsoft and Logitech mouses and when I saw this 'darkfield' mouse I thought I had to try it.&lt;br /&gt;It's a nice size in the hand, but not too heavy or big. It has plenty of buttons including one just below the left side of the thumb which is different. As usual the software allows you to configure all these.&lt;br /&gt;The wireless dongle is tiny and is one of&amp;nbsp;those Logitech® Unifying receivers so if you have another device using the same type of dongle, you only need one and can register the multiple devices with it.&lt;br /&gt;&lt;br /&gt;This is pretty much easily the nicest mouse I've had - I'd strongly recommend it.&lt;br /&gt;&lt;br /&gt;&lt;div style="text-align: center;"&gt;&lt;span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"&gt;Logitech Performance Mouse MX™&lt;/span&gt;&lt;/div&gt;&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://www.logitech.com/en-us/mice-pointers/mice/devices/5845"&gt;&lt;img border="0" height="320" src="http://www.logitech.com/assets/19678/19678.png" width="291" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div style="text-align: center;"&gt;&lt;a href="http://www.logitech.com/en-us/mice-pointers/mice/devices/5845"&gt;http://www.logitech.com/en-us/mice-pointers/mice/devices/5845&lt;/a&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-6620577689929199225?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/6620577689929199225/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2011/12/best-mouse-ever.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/6620577689929199225'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/6620577689929199225'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2011/12/best-mouse-ever.html' title='Best mouse... ever!'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-8877847790223697970</id><published>2011-11-28T10:07:00.001Z</published><updated>2011-11-28T10:13:10.319Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='visual studio'/><category scheme='http://www.blogger.com/atom/ns#' term='development'/><category scheme='http://www.blogger.com/atom/ns#' term='.net'/><title type='text'>SlowCheetah - XML Transforms</title><content type='html'>If you've ever developed a web-based project in Visual Studio, you'll probably know about the need configuration transforms you can do with the web.config file. The downside is that these can't be applied to the app.config for a normal application.&lt;br /&gt;&lt;br /&gt;There have been several workarounds available including scripting changing the app.config file when a build is performed, but frequently they are not straightforward or easy to configure.there is an easy to configure new alternative though in the form of visual studio extension called SlowCheetah.&lt;br /&gt;&lt;br /&gt;SlowCheetah allows you to automatically transform the app.config when you press F5 in Visual Studio. Just like with the web.config file, it is possible to have a different transform for each build configuration.&lt;br /&gt;&lt;br /&gt;Have a read up on how to use SlowCheetah &lt;a href="http://visualstudiogallery.msdn.microsoft.com/69023d00-a4f9-4a34-a6cd-7e854ba318b5"&gt;here in the Microsoft Visual Studio Gallery&lt;/a&gt;.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-8877847790223697970?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/8877847790223697970/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2011/11/slowcheetah-xml-transforms.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/8877847790223697970'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/8877847790223697970'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2011/11/slowcheetah-xml-transforms.html' title='SlowCheetah - XML Transforms'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-6822682474169556944</id><published>2011-09-22T12:44:00.000+01:00</published><updated>2011-09-22T12:44:10.014+01:00</updated><title type='text'>Android Market missing most of your applications?</title><content type='html'>After a recent update to the Android market application I noticed that most of my applications were missing. This was a real pain when it came to trying to update the applications.&lt;br /&gt;Going into the main application settings page and clearing the cache for the market application brought them back, but subsequent loads, or on finding updates, seemed to reset the list back to only showing about 4 applications.&lt;br /&gt;After much frustration, on closer investigation I found that the account being used in the market application wasn't my main account. I changed accounts and now everything seems to be back to normal!&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-6822682474169556944?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/6822682474169556944/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2011/09/android-market-missing-most-of-your.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/6822682474169556944'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/6822682474169556944'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2011/09/android-market-missing-most-of-your.html' title='Android Market missing most of your applications?'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-1970643627817027073</id><published>2011-04-02T09:56:00.000+01:00</published><updated>2011-04-02T09:56:31.097+01:00</updated><title type='text'>Windows Installer pain</title><content type='html'>I can't believe that it should be this hard to create a solid Windows Installer MSI. Sure, there's a bunch of applications out there which can make your life easier, but the good ones aren't exactly cheap.&lt;br /&gt;&lt;br /&gt;It seems strange that Microsoft are pushing MSI and Wix and yet there's no easy way of creating them. As far as I understand it, according to &lt;a href="http://msdn.microsoft.com/en-us/library/ee721500.aspx"&gt;this&lt;/a&gt;, Microsoft are phasing out the Windows installer project that came with VS2010 in the next version, I guess in favour of the limited edition of InstallShield.&lt;br /&gt;&lt;blockquote&gt;"Future versions of Visual Studio will not include the Visual Studio Installer project templates." &lt;/blockquote&gt;&lt;br /&gt;Don't get me wrong, InstallShield is a really nice and simple environment, but if you want to start doing anything slightly complicated, or compile for 64-bit, you have to stump up to the Professional or Premium editions which start getting quite expensive! &lt;br /&gt;&lt;br /&gt;I wonder if there are are decent integrated solutions out there that don't require quite a bit of hand crafting XML against Wix?&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-1970643627817027073?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/1970643627817027073/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2011/04/windows-installer-pain.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1970643627817027073'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1970643627817027073'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2011/04/windows-installer-pain.html' title='Windows Installer pain'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-2929724718913740808</id><published>2010-12-10T20:01:00.000Z</published><updated>2010-12-10T20:01:21.593Z</updated><title type='text'>Back in the blog</title><content type='html'>It's winter and I've finally managed to resurrect my blog, which was off-line for a bit while I was changing providers. I try not to blog anything too useless so I won't be putting loads of content up, but hopefully something of benefit to someone.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-2929724718913740808?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/2929724718913740808/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2010/12/back-in-blog.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/2929724718913740808'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/2929724718913740808'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2010/12/back-in-blog.html' title='Back in the blog'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-5581879566832018862</id><published>2010-05-12T11:23:00.009+01:00</published><updated>2011-09-22T12:44:56.175+01:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql'/><title type='text'>TSQL - Grouping data by year and month</title><content type='html'>A useful way to group data in result sets using only one date field is often to employ a YYYY-MM or YYYY-MM-DD format.&lt;br /&gt;&lt;br /&gt;In the past I'd opted for a slightly painful way of taking the dateparts of the year and month, converting them to varchars and then concatinating them together with the hyphens. The following are examples use getdate(), but obviously you'd use your own field.&lt;br /&gt;&lt;br /&gt;&lt;pre class="brush: sql"&gt;&lt;br /&gt;SELECT CAST(DATEPART(YYYY, GETDATE()) as CHAR(4)) + '-' + REPLICATE('0', 2-LEN(CAST(DATEPART(M, GETDATE()) as VARCHAR(2)))) + CAST(DATEPART(M, GETDATE()) as VARCHAR(2))&lt;/pre&gt;&lt;br /&gt;Not very pretty I think you'll agree. Especially if you want to immediately use it in a group by. The following is much more elegant and returns the same result!&lt;br /&gt;&lt;pre class="brush: sql"&gt;&lt;br /&gt;SELECT CONVERT(CHAR(7),GETDATE(),23)&lt;/pre&gt;&lt;br /&gt;If you want to include the day part as well then use all 10 characters returned:&lt;br /&gt;&lt;pre class="brush: sql"&gt;&lt;br /&gt;SELECT CONVERT(CHAR(10),GETDATE(),23)&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-5581879566832018862?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/5581879566832018862/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2010/05/tsql-grouping-data-by-year-and-month.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/5581879566832018862'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/5581879566832018862'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2010/05/tsql-grouping-data-by-year-and-month.html' title='TSQL - Grouping data by year and month'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-1395557603684542128</id><published>2009-08-06T20:49:00.000+01:00</published><updated>2009-08-06T20:50:28.374+01:00</updated><title type='text'>Windows 7 RTM</title><content type='html'>Yes it's true. Windows has finally been finished and released to MSDN. Go and get it! It's good, really it is! Forget Vista and move on.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-1395557603684542128?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/1395557603684542128/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/08/windows-7-rtm.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1395557603684542128'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1395557603684542128'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/08/windows-7-rtm.html' title='Windows 7 RTM'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-833841660746209122</id><published>2009-07-29T17:17:00.006+01:00</published><updated>2009-07-29T17:24:31.599+01:00</updated><title type='text'>Control multiple machines with one keyboard and mouse</title><content type='html'>Previously I've solved this scenario by utilising a very useful tool called Synergy. It's development has waned somewhat in recent years though, and with the advent of the new Windows 7 operating system it was time to look for another solution. I'm happy to say though that &lt;a href="http://www.inputdirector.com/"&gt;Input Director &lt;/a&gt;does the trick very nicely. It's powerful and yet very easy to configure and worked immediately with no issues on Windows 7.&lt;br /&gt;&lt;a href="http://www.inputdirector.com/"&gt;&lt;img style="display:block; margin:0px auto 10px; text-align:center; width: 200px; " src="http://www.inputdirector.com/images/title.jpg" border="0" alt="" /&gt;&lt;/a&gt;&lt;br /&gt;If you've got more than one machines that you want to be able to control with the one keyboard and mouse then this is ideal. I have the scenario where I have a desktop with two monitors and a laptop next to it with a single monitor attached. &lt;br /&gt;&lt;br /&gt;I can now have all three in a row and use the desktop or push the mouse off the side of the middle monitor and it immediately appears on the laptop connected screen on the right. It supports machine configurations of screens and really allows some easy use of multiple machine/screen setups.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-833841660746209122?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/833841660746209122/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/07/control-multiple-machines-with-one.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/833841660746209122'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/833841660746209122'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/07/control-multiple-machines-with-one.html' title='Control multiple machines with one keyboard and mouse'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-1203089027691239119</id><published>2009-07-14T20:56:00.002+01:00</published><updated>2009-07-14T21:00:55.034+01:00</updated><title type='text'>WSS &amp; MOSS</title><content type='html'>I've spent the last 2 weeks obtaining my MCTS in WSS and MOSS Configuration.  Very interesting to get to grips with the architecture and seeing how the WSS platform fits into the Microsoft offering. There seem to be so many products now that either tie into WSS or actively require it.&lt;br /&gt;The next version of Sharepoint will no longer be known as Microsoft Office Sharepoint Server (MOSS), but will revert to the old name of Sharepoint Server. My understanding is that this is to help retain the separation between the WSS product and Microsoft Office.&lt;br /&gt;Microsoft Office 2010 Technical preview is already around and brings some great interface improvements and features. The only problem is that to take advantage of all these neato enhancements you have to have the latest versions of Office, WSS and Exchange.  It's tough being in IT when there's not much money available in the budget but you want to implement new systems...&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-1203089027691239119?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/1203089027691239119/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/07/wss-moss.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1203089027691239119'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1203089027691239119'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/07/wss-moss.html' title='WSS &amp; MOSS'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-3406103132514799250</id><published>2009-02-04T10:44:00.004Z</published><updated>2009-02-04T10:49:47.175Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='outlook'/><category scheme='http://www.blogger.com/atom/ns#' term='office 2007'/><title type='text'>Strange Outlook 2007 Error</title><content type='html'>Today I started getting a fabulous new message from Outlook 2007 whenever I tried to open pretty much any type of object, i.e. a mail message or a calendar appointment:&lt;br /&gt;&lt;blockquote style="font-family: courier new;"&gt;Could not install the custom actions. The object could not be found.&lt;/blockquote&gt;&lt;br /&gt;Curious I thought, this was all working yesterday. It turns out it seems to be a corruption of the form cache file &lt;span style="font-family:courier new;"&gt;frmcache.dat&lt;/span&gt;.&lt;br /&gt;&lt;ol&gt;&lt;li&gt;Close Outlook. Wait a few seconds for it to finish shutting down in the background.&lt;/li&gt;&lt;li&gt;Go to your&lt;span style="font-family:courier new;"&gt; c:\users\[&lt;/span&gt;USERNAME&lt;span style="font-family:courier new;"&gt;]\&lt;/span&gt;Appdata&lt;span style="font-family:courier new;"&gt;\Local\Microsoft\FORMS&lt;/span&gt; directory and delete the cache file from there.&lt;/li&gt;&lt;li&gt;Restart Outlook and the problem should have gone away.&lt;br /&gt;&lt;/li&gt;&lt;/ol&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-3406103132514799250?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/3406103132514799250/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/02/strange-outlook-2007-error.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/3406103132514799250'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/3406103132514799250'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/02/strange-outlook-2007-error.html' title='Strange Outlook 2007 Error'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-1951621314558973568</id><published>2009-01-21T17:06:00.003Z</published><updated>2009-01-21T17:11:27.830Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='windows 7'/><title type='text'>Windows 7 - Can't modify wireless network profile</title><content type='html'>I came across an interesting problem caused by a group policy enforcing a wireless network policy to attach to the local corporate network and automatically authenticate.&lt;br /&gt;&lt;br /&gt;The wireless network in question does not broadcast its SSID.  Under Vista and XP this isn't a problem as the checkbox that allows you to connect even if the WLAN is not broadcasting its SSID is checked.  However in Windows 7 this checkbox was not ticked and because it was a group policy it was not possible to change it.&lt;br /&gt;&lt;br /&gt;It's possible to take a copy of the profile and change that one instead though using the netsh command.&lt;br /&gt;&lt;br /&gt;To export the existing profile that has all the settings in you want, just type&lt;br /&gt;&lt;blockquote&gt;netsh wlan export profile 'profilename'&lt;/blockquote&gt;&lt;br /&gt;This will give you an XML file with your settings in. Rename it to 'newprofile.xml' or similar and then edit this file and change the name of the profile to something you want, like Profile2. Then run the following&lt;br /&gt;&lt;blockquote&gt;netsh wlan add profile newprofile.xml&lt;/blockquote&gt;&lt;br /&gt;&lt;br /&gt;Then happily you will see the profile in your wireless network choices and can change the tickbox to allow to connect to the non broadcasting SSID.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-1951621314558973568?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/1951621314558973568/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-cant-modify-wireless-network.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1951621314558973568'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/1951621314558973568'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-cant-modify-wireless-network.html' title='Windows 7 - Can&apos;t modify wireless network profile'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-8517825460502421337</id><published>2009-01-19T19:25:00.003Z</published><updated>2009-01-19T19:30:10.853Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='unity'/><category scheme='http://www.blogger.com/atom/ns#' term='vmware'/><title type='text'>VMWare Unity</title><content type='html'>Upon installing the latest version of VMWare Workstation (6.5.1) under Windows, I discovered a fantastic new feature called 'Unity'.&lt;br /&gt;&lt;br /&gt;What is Unity you ask yourself? Well it's very simple, it takes the windows from within the guest operating system and integrates them as windows in your host operating system. This way you dont have to go full screen or have a frame around your virtual machine to get to one useful window that you're trying to use.&lt;br /&gt;&lt;br /&gt;It's also available in VMWare Fusion on the Mac, so running your Windows programs has never been so easy!&lt;br /&gt;&lt;br /&gt;&lt;a href="http://www.youtube.com/watch?v=JIApJMzGzDQ&amp;feature=player_embedded"&gt;Video&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-8517825460502421337?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/8517825460502421337/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/01/vmware-unity.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/8517825460502421337'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/8517825460502421337'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/01/vmware-unity.html' title='VMWare Unity'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-3508732655181990054</id><published>2009-01-19T11:52:00.002Z</published><updated>2009-01-19T14:08:29.194Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='windows 7'/><title type='text'>Windows 7 - Windows installer has stopped working</title><content type='html'>&lt;div xmlns='http://www.w3.org/1999/xhtml'&gt;This is a pain if it happens. I haven't seen it at all on a couple of installations, but on another I had this problem pop up constantly after installing Microsoft Office. Everything that uses the Windows Installer seems to crash without really even trying to run. It turns out it's to do with the Customer Experience Improvement Program!&lt;br/&gt;&lt;ol&gt;&lt;li&gt;Navigate to HKLM\Software\Microsoft\SQMClient\Windows\DisabledSessions in the registry and delete all the string values, except for the 'Default' entry.&lt;/li&gt;&lt;li&gt;Run the group policy editor - gpedit.msc &lt;/li&gt;&lt;li&gt;Navigate to Computer Configuration -&amp;gt; Administrative Templates -&amp;gt; System -&amp;gt; Internet Communication Management -&amp;gt; Internet Communication settings. &lt;/li&gt;&lt;li&gt;On the right find 'Turn off Windows Customer Experience Improvement Program' and double click it, which brings up a dialog where you can select 'Enabled'.&lt;/li&gt;&lt;/ol&gt;&lt;span style='font-size: 78%;'&gt;Solution found at &lt;/span&gt;&lt;a href='http://chris123nt.com/2009/01/18/sqm-client-causing-crashing-in-windows-7/'&gt;&lt;span style='font-size: 78%;'&gt;http://chris123nt.com/2009/01/18/sqm-client-causing-crashing-in-windows-7/&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-3508732655181990054?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/3508732655181990054/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-windows-installer-has-stopped.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/3508732655181990054'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/3508732655181990054'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-windows-installer-has-stopped.html' title='Windows 7 - Windows installer has stopped working'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-8980246838752058883</id><published>2009-01-15T12:45:00.001Z</published><updated>2009-01-15T12:46:01.100Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='windows 7'/><category scheme='http://www.blogger.com/atom/ns#' term='messenger'/><title type='text'>Windows 7 - Live Messenger 2009</title><content type='html'>&lt;div xmlns='http://www.w3.org/1999/xhtml'&gt;Well here's something thats a bit wierd. Upon installing Windows Live Messenger 2009, the first thing you notice is that the damn window just wont minimize. It's very odd. Even after you've closed all your discussion windows and the main contacts window, you still get an entry on the taskbar, which personally just isn't desirable.&lt;br/&gt;It's easy to fix though!&lt;br/&gt;Change the properties of the Windows Live Messenger shortcut and set the compatibility level to Vista. Then when you next run it, you'll see it minimizes exactly how it used to...&lt;br/&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-8980246838752058883?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/8980246838752058883/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-live-messenger-2009.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/8980246838752058883'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/8980246838752058883'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-live-messenger-2009.html' title='Windows 7 - Live Messenger 2009'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-4758546307809111233</id><published>2009-01-14T14:53:00.000Z</published><updated>2009-01-14T15:00:53.560Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='windows 7'/><category scheme='http://www.blogger.com/atom/ns#' term='cisco'/><category scheme='http://www.blogger.com/atom/ns#' term='vpn'/><title type='text'>Windows 7 - Cisco VPN Client</title><content type='html'>&lt;p&gt;&lt;span &gt;I recently started using Windows 7 and so decided to push it to the limit and run all the software I was previously running under Vista.  The only serious problem I had with incompatibility was a known issue with Daemon Tools in that it simply isn't compatible with Windows 7, so I used the free version of &lt;a href="http://www.slysoft.com/en/virtual-clonedrive.html"&gt;Virtual CloneDrive &lt;/a&gt;by ElaborateBytes instead.&lt;/span&gt;&lt;/p&gt;&lt;p&gt;My next stumbling block was to get the Cisco VPN client working. Oddly enough I had no problems getting this to work on build 6956, but on moving to 7000 I kept getting a dreaded blue screen everytime I tried to start Windows. Luckily the system repair managed to get round this and take me back to the system point just before I'd installed the VPN client.&lt;/p&gt;&lt;p&gt;After hunting round the web for a while I found a simple combination of things that seemed to result in a reliable way of getting the VPN client to install and work properly. &lt;/p&gt;&lt;p&gt;The VPN client version is &lt;span&gt;v5.0.04.0300. First I changed the properties of the Setup application so that it was running Vista compatibility mode, then I ran the setup as an administrator. Once the client installed, I set up the profile and connected to the remote site to check it was working. All no problems, so I rebooted and no blue screen, all worked as advertised and I haven't had a problem since.&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span&gt;You can also run the compatibility troubleshooter which provides a nice wizard type view to set the compatibility options and the security level for running the application as administrator.&lt;/span&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-4758546307809111233?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/4758546307809111233/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-cisco-vpn-client.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/4758546307809111233'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/4758546307809111233'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-cisco-vpn-client.html' title='Windows 7 - Cisco VPN Client'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2194112072206333819.post-6297584518571811348</id><published>2009-01-12T17:16:00.001Z</published><updated>2009-01-12T17:30:28.801Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='windows 7'/><category scheme='http://www.blogger.com/atom/ns#' term='d830'/><category scheme='http://www.blogger.com/atom/ns#' term='nvidia'/><title type='text'>Windows 7 - Graphics issues NVS 135M</title><content type='html'>While it seems to be well understood that Windows 7 is in early beta and has many graphics issues, I did come across one particular issue that really drove me up the wall.&lt;br /&gt;&lt;br /&gt;My laptop, a Dell D830, had been running 6956 for a week or so with no problems and was displaying the new superbar taskbar with it's nice Aero peek function no problem.&lt;br /&gt;I found Windows 7 to be pretty stable and run all the software I was running on Vista, so I thought OK, I'll upgrade to the 7000 Beta 1 build which was release a week or two after I had installed 6956. However, after installing the new build, my nice Aero affect had gone and the taskbar was back to a rather cut-down version of the Aero peek feature.&lt;br /&gt;&lt;br /&gt;I decided to work on this one as it had been working so it seemed quite plausible it should still work on the 7000 build. I had done an upgrade from 6956 to 7000 so I decided to install 7000 from fresh. This resulted in the same problem. I had been accepting the Windows Update recommendation to install the latest WDDM 1.1 version of the nVidia driver for the NVS 135M graphics card onboard and so I thought maybe it was this.  Then I started trying really basic things like typing 'Aero' into the start button search. One entry this brought up was to find and fix problems with transparency and other visual effects. Ah-hah I thought!&lt;br /&gt;&lt;br /&gt;So I ran this Aero troubleshooting wizard and it came back that Aero required 32-bit colour. That's odd I thought, my card was displaying 32-bit before, I thought that my nice blue background was looking a little more dithered than before. Looking at the screen resolution options and then going to advanced and selecting the monitor tab I noticed that the colour depth was 16-bit and with no option to change it to anything else! I spent some time being frustrated about this and trying other versions of the graphics drivers but to no avail.&lt;br /&gt;&lt;br /&gt;Finally I noticed in the nVidia control panel an advanced option to manage custom resolutions. I added a new resolution of 1920x1600 and set the colour depth to 32-bit. Lo and behold it worked! I had to reboot and then run the Aero troubleshooter again which enabled all the Aero options again and my taskbar and nice transparency were all back!&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2194112072206333819-6297584518571811348?l=daniel.abbatt.net' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://daniel.abbatt.net/feeds/6297584518571811348/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-graphics-issues-nvs-135m.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/6297584518571811348'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2194112072206333819/posts/default/6297584518571811348'/><link rel='alternate' type='text/html' href='http://daniel.abbatt.net/2009/01/windows-7-graphics-issues-nvs-135m.html' title='Windows 7 - Graphics issues NVS 135M'/><author><name>Daniel Abbatt</name><uri>https://profiles.google.com/112804263259446871491</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//lh3.googleusercontent.com/-N-q3k2GuKgU/AAAAAAAAAAI/AAAAAAAAAAA/w5imDrLmFwE/s512-c/photo.jpg'/></author><thr:total>0</thr:total></entry></feed>
