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 »
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 be the fastest so here are my very unscientific results. Read the rest of this post »
Change Ubuntu keyboard layout
To change the layout of the keyboard in ubuntu 12.04 use the following command:
sudo dpkg-reconfigure keyboard-configuration