Enable xp_cmdshell in Microsoft SQL-server

Disclaimer: Beware of the possible security threat when you enable xp_cmdshell usage. You can also take a look at this article, it’s at bit more complicated, but a lot safer.
The article pretty much walks you through, what you need to do to use SQLCLR. I tried it out and got stuck when i got a security threat. I got the threat because you have to give the assemblies that you use (‘alter assemblies…’) a given state – safe, unsafe and external in the SQL-server.

EXEC master.dbo.sp_configure ‘show advanced options’, 1
EXEC master.dbo.sp_configure ‘xp_cmdshell’, 1

It’s also possible to use ‘sp_oacreate’.

Problem playing MKV on WDTV (Gen1)

If your WDTV (Gen1) freezes when you want to play a MKV-movie you can try the following.

  1. Download and install mkvtoolnix.
  2. Start MKVmerge GUI
  3. Load/Add the MKV-file your having problems playing.
  4. Change the video-stream. Press the video-stream. Go to the ‘Extra options’-tab and change the compression to ‘None’.
  5. Do the same for the audio-stream.
  6. Press ‘Start muxing’

Solution found at here.

Sony Ericsson X10 Mini Pro as WIFI-hotspot eg. for an Ipad

Below is a guide as to how it is possible to turn your Sony Ericsson X10 Mini Pro into a WIFI-hotspot eg. for your Ipad.

Disclamer: You need to root your phone. Read all about the consequences of this action on the Internet before you proceed. The below guide worked for me this doesn’t mean that it will work for you.

  1. On your phone check “debbuging mode” on Setting > Applications > Development
  2. You need to download an install Flashtool.
  3. Go to the folder, where Flashtool gets installed eg. C:\Flashtool\drivers and run Flashtool-drivers.exe to install the correct drivers for Flashtool.
  4. Install the correct drivers for your Sony Ericsson X10 Mini Pro.
  5. Start Flashtool.
  6. Connect your phone to your computer via the USB-cabel and Flashtool will recognize it.
  7. When Flashtool is ready press the open padlock symbol.
  8. Flashtool now roots your Sony Ericsson X10 Mini Pro and reboots it.
  9. After that you will now be able to see the SuperUser icon on your phone.
  10. Go to Android Marked and download ‘Barnacle Wifi Tether’ (http://szym.net/barnacle/).
  11. You probably need to press the ‘Associate’-button in ‘Barnacle Wifi Tether’ on your phone a couple of times when you are connecting with the Ipad before it connects. When it connects ‘Barnacle Wifi Tether’ will notify you and show your connection under ‘Clients’.

I have tried using the WEP-encryption. I doesn’t seem to be able to connect very well. You have to press the “Associate”-button a lot of times. If you leave the connection unencrypted it seems to connect very well. BUT this leaves you with a security issue!
In the settings for ‘Barnacle Wifi Tether’ it is possible to choose ‘Auto Associate’ it will auto associates every 5 seconds until a client connects.