The key to remember here is that all commands that relate to file paths in Exchange 2010 have to be UNC based. This is so they are not bound to a local machine but can run from any server to any server over the network. So keep this in mind when running Exchange PST Imports, Database defragmentation’s etc.

So in this example the Exchange Database is called db01. The location of the temp file has to be specified so Exchange knows where it is to dump the temp files during a Defrag. In this case the location will be C:defrag and the temporary file is called temp.edb.

Remember the temp file destination requires a minimum of 110% of the total size of the Live Database of free space to complete

Here is an example of the wrong way to format the .edb destination. You cannot use the mount path you must use a UNC path.
1. Dismount-Database ‘db01′
2. eseutil /d ‘db01.edb’ /t c:defragtemp.edb
3. Mount-Database ‘db01′

Here are the correct commands:
1. Dismount-Database ‘db01′
2. eseutil /d ‘db01.edb’ /t\localhostc$defragtemp.edb
3. Mount-Database ‘db01′

Windows 8 – PC, Tablet

March 2nd, 2013 | Posted by jason in Information Technology | Microsoft | Windows - (Comments Off)

Myself and the team have continued debates regarding the direction Microsoft has taken regarding Windows 8. I will be honest and say I started out like many other tech’s have with the first look they took at Windows 8 start screen/metro experience. OMG what have they done! It was a shock it took everyone by surprise and everyone cringed. Forums raged, bloggers flamed and in general everyone’s first impressions where Microsoft DONT DO IT.
But when the first dust settled, beta users and RC users got going. I myself got it installed on my own PC and forced myself to do what everyone is going to have to get used too and before I knew it I was loving it. We are starting to see a new Windows maybe even a new Microsoft. Gone was the idea that Windows was just a boring OS that sat in the background and did nothing. Gone was the idea that everything Microsoft offered was a separate product. Here is not just a new product its an entire Eco-system built for every user to enjoy.
First thing I like to point out to new users of Windows 8 is that its just a start screen! The old windows you all need to do your job everyday is still there, just click ‘Desktop’ and your back! Metro is just a new option for opening programs, give developers and indy game designers a new way to create applications great or small for windows that are portable from normal windows to the new RT platform that runs on ARM tablets. It also allows developers to provide details regarding their applications to the user via the ‘Live tiles’ feature, which is actually really useful. I don’t bother opening my email anymore, unless my live tile says I have some email.
All you need to get the full benefit from Windows 8 across the board is get yourself a Microsoft Live account (also known as or all of these old accounts work just fine, good idea to use the one with some other services you already use, see below), if you don’t already have one. This live account is like your pass to all things Microsoft, you can link email, SkyDrive cloud storage, Skype now owned by Microsoft and replacing MSN Messenger very soon, MSN, Xbox Live account, Technet or Partner account. It also acts as your Windows login username and password (if you want) storing all the person windows settings and Internet Explorer history and favorites in the cloud for free so you can login to your work laptop or wife’s computer with your user account and its looks like you never left home.
Overall a fun new experience with nothing lost, if anything with all the major speed improvements, improved battery and more secure kernel there is no reason i can see to stump up the small upgrade cost. Clearly the future of computing is Touch & Cloud good to see Microsoft riding the curve.

Its been a while since I posted but i figured that this was important enough to spread the word. There is little out there on forums about this fault at the moment as its a fairly new one.
Microsoft have a KB2597166 Security Update for Microsoft Excel 2010 (x86 & x64) mine installed on the 16/08/2012 so a couple of weeks ago. I myself am not a big Excel user however one of my clients is and called me today with an issue with the Excel Data Sort feature, which they use alot to sort data they bring in from an Oracle database via ODBC. They found that when excel sort by exceeded 2000 rows and more than a few columns it would Error with the following:

“The Operation you are about to perform affects a large number of Cells and man take a significant amount of time to complete. Are you sure you want to continue?

Ok fair enough… But when you press OK you get More:

“Excel cannot complete this task with avaliable resources. Choose less data or close other applications”

We tried all the Microsoft surgestions on this fault, Close other & 3rd Party applications, clean up Roaming profile Excel folder, disable the Viewing/Preview Panels… nothing.
Lastly we removed the update listed here KB 2597166 the last Excel update, as it was installed about the same time as the issue reportedly started. Bit of a shot in the dark but it works. I have now added it to the clients WSUS declined list to prevent future accidental installation.
Hope this helps… Until next time.


Excel Error (KB2597166)

A simple request I had the other day I thought I would share. Connecting an ESXi host to an existing NFS share to access User based ISO file Repository.
First you need to connect you ESXi Hosts to the NFS storage.
Second Create a New VM or Use and exisiting VM to use an ISO from the NFS as a CD Rom

Step 1 Connecting NFS
Check that you can ping the ESXi host from the NFS storage box. Then you Need to ass the NFS as a storage device in the Storage Configuration.
Open vSphere Client and Login
Select Hosts & Clusters
Select the ESXi host that you want connect to the NFS share.
Select the Configuration Tab
Select Storage
Select Add storage
Choose Network File System
Enter the Server and Path details of the NFS storage location.
And give the storage location a name so you can identify it. i.e: NFS_Store1
This will add the NFS volume as a storage location in VMware

Step 2
Now Choose the ‘New Virtual Machine’ option or use an existing Virtual Machine.
Edit the Virtual Machine configuration.
Choose the CD Rom, choose ‘Datastore ISO’ Browse to your newly created Datastore connection and choose the ISO.
Tick the Connect at Power On Box

Now when the VM boots it will use the ISO’s you put in the NFS share as its Virtual CD ROM.

Another project across my desk this last week or so has been the monster that is CRM 2011. With the large scale switch from our creaking old servers in our own office to something a little more swish. All of which is going to happen in the next 4 weeks.

The new servers were in the rack yesterday and running a VMware virtual environment, planning on hosting between 6-8 servers in total. A pair of Domain Controllers (DFS, DHCP, AD, FP, and DNS the works, linking in to our domain servers at the datacentre to finally complete the site spanning domain) a backend Exchange & SQL servers with a frontend apps server hosting: SharePoint 2010, CRM 2011, and Exchange 2010. Just to begin with, we have plans also to look at implanting Lync 2010 Enterprise and SCOM 2012, to replace our existing monitoring solution, when it moves from RC to full version next month (March/April).

Anyway back to CRM land. This product is in my honest opinion possibly the greatest CRM product I have even seen or used in any company, I cannot praise Microsoft enough for the fine work they have put in compared to past attempts at this market.

With an open platform construction as with all their new web based products allowing cross platform compatibility and in to the mobile world. With a customisation system that is out of this world and so simple to implement. Drag & Drop linking and the ability to build pretty much any process you would ever require, too run any kind of business ever conceived. The real joy of this product is the ease in which you can create new parts to the system that are required for your business and have it automatically add the correct links. For example: We require a modular that allows us to track assets that are sold to clients so we know which assets we have provided allowing us to provide better support. This feature does not exist in CRM 2011 by default. In CRM 2011 it was so simple to add I could not believe. I simply created a New Custom Entity called Asset/Assets. Next created a N:1 Relationship to the Accounts Entity (So can track assets 1 Account : N Assets), created a 1:N Relationship to Case Entity (So can track N Cases : 1 Asset). My work here is done: CRM does the rest Account now has an Asset List automatically added to view on the form. Cases now have an Asset field lookup that can be added to the form for completion so a case can have an asset related to it. All that is left to do now is add a few Text, Number & look fields on the Asset Default Form such as Make, Model, and Serial No etc.

My last CMR wonder is the Outlook/Email integration. 2nd to none is the easiest approximation I can make, but it’s simple integration with all email and with the ability to add any complexity you would require with rules/routing/process and assignment to queues. A few days’ work and I have a system that works exactly how we want, including automatically tracking emails, queuing them for the team to deal with automatically, finding the reply emails and assigning them to the correct Case or Quote or Account. Sending an email from CRM has never been so easy; as it uses the Outlook we all know and love with no added complexities. Just click the familiar New Email, New Appointment, New Task and CRM has already logged it tracked it assigned it to the correct Customer Account and your whole team can see, share and check back.