Remote Desktop to Hyper-V on Windows 8

So the virtual machine connection inside of hyper-v stinks.  Limited resolution choices and no copy/ past functionality.  None of the niceties of remote desktop.  As a developer a very difficult environment to work in.

So I spent some time trying to get it to work, and found this solution

https://stoknes.sharepoint.com/runesblog/Lists/Posts/Post.aspx?ID=12&mobile=0

I followed the instructions, did not change my default ip address.

Make sure you put the address in your remote desktop window as <your_virtual_machine's_name>.mshome.net

4 Steps to take a SQL SERVER Database out of Single User Mode

Recently my database got stuck in single user mode and I could not open it to change into multi-user.

 I used the scripts below to fix this.
This is in SQL Server management studio with SQL Server R2

1. Find My Database id
    SELECT db_id('MyDB')



2. Find the session id that was using the single user mode, using the dbid returned from step 1 

    SELECT SPID,DBID,*
  FROM SYSPROCESSES
  WHERE DBID NOT IN(1,2,3,4) 
  AND SPID>50 
  AND SPID<>@@spid 
  AND dbid=[DBID]



3.Kill the session using the SPID from step 2

   SELECT SPID,DBID,*
   FROM SYSPROCESSES
   WHERE DBID NOT IN(1,2,3,4) 
   AND SPID = 99
   AND dbid=11


4.put the database back into multi-user mode
   ALTER DATABASE MyDatabase
   SET MULTI_USER

Now you can get back into your database, 

To Format this TSQL I Used http://www.ubitsoft.com/products/t-sql-beautifier/ it worked great
         

JQuery for a select all checkbox

So I have a asp.net repeater with a bunch of check boxes.  I want to have a select all/unselect all checckbox at the top of the repeater.

I used this little snippet of jquery to do it.

I got this great script from the bottom of a stack overflow post Here is a small revision on this, when doing this in asp.net with an ajax update panel you need to add the live. This way when the update panel refeshed the html, you can re-connect to your event.

asp.net Update Panel and hiding elements

When working on a asp.net application that was using multiple update panels I was getting an error something like


Could not find UpdatePanel with ID 'xxx'. If it is being updated dynamically then it must be inside another UpdatePanel

I found the post below on stack overflow.

http://stackoverflow.com/questions/3928253/could-not-find-updatepanel-with-id-xxx-if-it-is-being-updated-dynamically-the

Basically my issue was that I was hiding the <asp:Panel> that contained the update panel.  This does not work at all.  You cannot do

<asp:panel visible="false" runat="server">

     <asp:UpdatePanel runat="server">

          <ContentTemplate>

                    <div>some stuff</div>

         </ContentTemplate>

    </asp:UpdatePanel>

</asp:panel>

Once I removed the visible="false" from the <asp:Panel> that my <asp:UpdatePanel> and everything worked like a charm.

WPF XAML App.config Transformations - Slow Cheeta

I was really tired of commenting and un-commenting out my app.config for my wpf application.  When  deploying I would forget to switch my database connection from dev to test or production.

I am now using Slow Cheeta to transform my app.config by build configuration.  Tying a build configuration to each one of my environments.  It is super easy and works great.

Visual Studio Keyboard Shortcut - Highlight Word Ctrl + Shift + Arrow

Sometimes when I am selecting text to cut "Ctrl+x" or paste "Ctrl+v" in visual studio I am selecting a bunch of text. This can take some time by holding the "Shift+right arrow" or "Shift+left arrow".

Recently I found a quicker way "Ctrl + Shift + Right Arrow" or "Ctrl + Shift + Left Arrow" will select a whole word.

Next time you are selecting a bunch of text try it out.  I tried this keyboard shortcut and it even works in Blogger.

Windows 8 - Day 1 Keyboard Shortcuts

So I got a new laptop with Windows 8.  So far its been Ok, but I really miss my start button.

To replace the start button I am using the keyboard shortcut key + Q searches applications.

So when I want to run SQL Server, or visual studio this works great.

I also found this other handy list of keyboard shortcuts

http://windows.microsoft.com/en-us/windows-8/new-keyboard-shortcuts#1TC=t1