Author Archive
Using DD-WRT on an Asus RT-N16 router to share a 3 MIFI Internet connection on LAN
Yes a snappy title! I’ve spent so long getting this configuration to work that I have to save the info here for my own future reference. I originally tried to use the latest firmwares and spent a couple of frustrating day’s trying to get it working. I eventually gave up and tried the specifically mentioned […]
How to clear down winsxs folder in Windows 7
If you have found that you have a folder called winsxs that is eating up gigs and gigs of your C drive, then this command line can free up several of those valuable gigs.
In: Windows · Tagged with: ms-dos, windows 7
Simple script to backup all databases at once
Script to backup all non system databases To backup all your MS SQL databases quickly on a SQL instance use the following script in a new query window. You must change the “SET @path” string to a suitable location.
In: SQL · Tagged with: backup, script, sql, T-SQL
Mount SMB shares in Ubuntu
Here is a quick guide on how to install CIFS and use it to mount SMB shares (aka Windows shares) in Ubuntu. This is tested on Ubuntu 12.04 but should work on most recent versions as well as other Debian releases.
In: Linux · Tagged with: cifs, linux, mount, shares, smb, Ubuntu, umount
Which is faster iSCSI or NFS when used as an ESXi datastore
I have a QNAP NAS (which is an excellent bit kit by the way), and I have 2 servers running ESXi 4 and 5 respectively. I had some free time tonight so finally got around to setting up both an NFS and an iSCSI datastore on the NAS. I was curious as to which would […]
Change Ubuntu keyboard layout
To change the layout of the keyboard in ubuntu 12.04 use the following command: sudo dpkg-reconfigure keyboard-configuration
Change Ubuntu Time or Timezone
It took me a while to figure out how to change the timezone in Ubuntu 12.04. it wasn’t at all intuituve, so to save you the bother here are the commands you’ll need:
Setting SQL Server to accept date in DD/MM/YYYY format
I’ve been working on a web based database project for the wifes business and during development I realised that half of the dates where being saved in M-D-Y format. As I live in the UK we use the correct date format which is D-M-Y obviously ;). The problem turned out to be a single settings […]
In: ASP.NET, SQL, Tech · Tagged with: asp.net, database, dmy, sql
Query AD group membership with Powershell
Here are a couple of very useful scriptlets if you ever need to enumerate or count the quantity of users in an AD group.
Assign a static IP to Ubuntu (old config)
When installing a new Ubuntu system it sets up the network cards to use DHCP by default. I like to give my servers a static address. So here are the instructions detailing how to assign a static IP to Ubuntu. These instructions were written with Ubuntu 12.04 in mind, though will probably work on most […]