Delivering solid user friendly software solutions since the dawn of time.

Restore mssql database checklist 

Categories: SQL Server

using SQL Server Management Studio

Create new database:

  • Databases > Right click > New database
  • General > Databasename
  • General > Databasefiles > Change path
  • OK

Restore backup:

  • Select Database > Right click > Tasks > Restore > Database
  • General > Device > Browse for .bak
  • General > Destination > Select database !
  • Options > Overwrite with replace
  • OK

Asus eee PC as router 

Categories: Linux Network

A white Asus eee PCBurning linux penguin

I still had a small Asus eee Pc, so I decided to turn it into a router I can take with when I travel. I could have installed a full distro on it, but decided to go for one of the prebuild firewall distros. I installed monowall and saw that it was actually not really using the little pc, so I replaced it with ipfire because it allows you install additional packages for file and printer sharing and you switch samba on if needed.

Since the Asus eee Pc has only one wired nic and one wireless adapter, there are some little tricks to remember...

  • Download ipfire cd-rom iso and use Yumi to put it on a usb stick.
  • Press escape on boot to select usb.
  • Internet modem cable goes into red.
  • Wifi will become green. (as opposed to the usual blue)
  • After reboot login to shell as root
  • ifconfig (to check if you got ip from isp)
  • pakfire list (will show all the addons available for ipfire)
  • pakfire install hostapd (turns wifi adaptor into access point)
  • pakfire install elinks
  • elinks (use elinks at to configure wifi)

The tricky part is using elinks text browser, it feels so 1985. Remeber that after selecting the information is at the bottom of the console. You also have to press enter to type into an input field, but should use the arrows to exit the field.

After you enable the wifi (menu > ipfire > WLanAP), you could use the default ssid (ipfire) and password (IPFire-v2.x) to re-configure on another client with the web interface.

other links:

Checklist for new nuget creation 

Categories: .Net

We use this checklist whenever we need to setup a new nuget package, that way it will include tests, coverage, labelling and deployment.

  • Create repository on server: hg init c:\Respository\Nugets\ken.X
  • Clone repository to local machine using TortoiseHg
  • Create new Project: Templates - Windows - Class Library - Create directory for Solution - ken.X
  • Close solution and move everything up one directory (cause of clone) - ken.X.sln
  • Add ken.Tools nuget package to solution
  • Create default hg ignore file with *.suo *.user bin debug packages/ tools/
  • Add new Class Library Project for testing: ken.X.Tests + add ken.XUnit
  • Solution - Configuration Manager - New - 'Publish' copy from Release and create project configurations
  • Update so output directory for Publish is release folder in ken.X.csproj
  • Update so output directory for Publish is release folder in ken.X.Tests.csproj
  • Add Import Project for build.config in ken.X.Tests.csproj (<Import Project="..\tools\build.config" />)
  • Update assembly information for ken.X.Tests
  • Update assembly information for ken.X and add InternalsVisible for ken.X.Tests
  • Add nuspec file to ken.X
  • Rebuild the test project with publish configuration to deploy the nuget.

Fiddler shortcut key to copy request to composer 

Categories: Network

To edit and reissue a request you can drag and drop it to the composer, but I couldn't find the shortcut key for this.

Steps to add this functionality behind the 'X' key:
(edit: changed this to X because the new fiddler uses E for breakpoints)

  • Ctrl + r to open fiddler script
  • In OnBoot() add: 
  • After this method add: 
    static function HandleAKey(Sender, theKey:KeyEventArgs) { 
        if (theKey.KeyData == Keys.X)
               var oS: Session = FiddlerApplication.UI.GetFirstSelectedSession();
               if (null == oS) return;
               theKey.Handled = theKey.SuppressKeyPress = true;
  • Restart fiddler

Remove files from systemprofile and WinDirStat huge unknown space resolved 

Categories: Windows
  1. You check WinDirStat with options > show unknown and see that huge disk space is unknown
  2. You remove system restore points and still see huge disk space in unknown
  3. You run WinDirStat as an admin and the application hangs
  4. You worry, if someone is proxing stuff through my computer
  5. You use  Procmon to check the file activity and see that lots of files are written in C:\Windows\System32\config\ systemprofile\AppData\Local\ Microsoft\Windows\Temporary Internet Files\Content.IE5
  6. Ah, IE again. You delete this files and realize that they are created faster than you delete.
  7. You type one of the htm files and see Assembly Binding Log Entry
  8. You realize you forgot to turn off Fuslogvw (and it somehow logs to this hidden folder wtf)
  9. You open Fuslogvx and click settings > log disabled
  10. You cleanup the milion of files mess you made, understanding why your computer was going slower lately
  11. Priceless, well actually around 850 euros 
Page 10 of 39 << < 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 20 > >>