Which version of Ubuntu am I running
To find out which version Ubuntu is installed simply type the following in to a console: Read the rest of this post »
CentOS Fixing Error writing fstab Read-only file system
If you’ve accidentally broken your /etc/fstab file and re
booted and found yourself in the repair console. You might run into some issues while trying to fix it. Read the rest of this post »
How to add a new user to vCenter Server Virtual Appliance
If you use vSphere 5 vCenter Server Virtual Appliance and you don’t have, or chose not to use Active Directory for user access then there is another way to add users to the appliance.
In: Vmware · Tagged with: add user, new user, vcenter, vmware
Change Exchange mailbox type from shared to user mailbox
When migrating many mailboxes to an Exchange 2010 system, or after an existing object has been mail enabled you may find you have some mailboxes that are set as type ‘Shared’ even though they belong to a single user. You can see this either through the Exchange Management Console (EMC) by applying a filter of Recipient Type = Shared, or by running the following command in the Exchange Management Shell (EMS): Read the rest of this post »
Disable complex password requirement on Hyper-V server 2012
I recently experimented with Hyper-V 2012 and found there was no easy way to disable complex passwords, so after searching the net for a while I came across a nice solution that didn’t involve joining and leaving domains and interfering with group policy. Here it is –
In: Windows · Tagged with: complex password, hyper-v
Grant a MS SQL login Read Only access to ALL databases
Here is a SQL code snippet I used today that loops through all the databases on a server and creates a SQL script that will give a user Read Only access to all databases (including system databases).
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 firmware below and it worked as expected.
DD-WRT is an open source firmware that can be installed on many different routers. It opens a whole world of possibilities and configuration options, turning a mediocre router in to something that could cost a lot more.
ASUS RT-N16 is a wireless router that is considered particularly good to use with DD-WRT, mainly because it has masses of internal memory which allows you to install the biggest versions of DD-WRT which gives you all the bells and whistles such as OpenVPN, USB support, Hotspot etc.
MIFI is a small portable Internet connected Access Point that connects via 3G/4G. Mine is provided by the 3 network and I can get better speeds using the MIFI than i can from my home ADSL connection. I use the MIFI as a backup internet connection or for when I’m away from home. I wanted a way to share that MIFI connection with my home wired LAN, and DD-WRT is the way to do it.
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. Read the rest of this post »
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. Read the rest of this post »