Windows
Remember this post? I’ve had the same issue again but since the server I was connecting to only worked by IP address and not by name, the method did not work. A little Googling showed another nifty trick up the sleave of Remote Desktop connections.
If you’re having the same issue, all you have to do is start you RDP by going to Start – Run and type:
MSTSC /ADMIN
Just connect as you would normally and everything should work!
Found an interesting piece of code to count by colours in Excel. Thought I would share it:
Open the spreadsheet in which you want to add the new function and press Alt+F11 to go into the VBA Editor. Now click Insert –> Module to add the new function to the active document. Here’s the script you need:
Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean)
Dim rCell As Range
Dim lCol As Long
Dim vResult
lCol = rColor.Interior.ColorIndex
If SUM = True Then
For Each rCell In rRange
If rCell.Interior.ColorIndex = lCol Then
vResult = WorksheetFunction.SUM(rCell, vResult)
End If
Next rCell
Else
For Each rCell In rRange
If rCell.Interior.ColorIndex = lCol Then
vResult = 1 + vResult
End If
Next rCell
End If
ColorFunction = vResult
End Function
A few days ago, I received a message through LinkedIn from Mikita Bleshchyk from ScienceSoft to tell me that they’ve launched a new version of their Office365 migration effort calculator. I was happy to read this news but unfortunately it didn’t quite meet my expectations.
The only thing that has changed in the new release is that a button has been added to ‘Select your business size’. I’ve tried the calculator with exactly the same data as I did last time and it seems the new option has no influence at all.
I’ve contacted the guys at ScienceSoft again and I hope to give your more information soon.
Most people today have heard about the term DDOS or Distributed Denial Of Service attack. The basic principle of this attack is that a group of devices start sending requests to a single (web)server, causing it to slow down or even become completely unavailable. The easiest example to set here, is to take a bunch of Windows computers and get them to start a PING request to the same server.
Now, I know this might sound hard to explain to someone who does not have a connection or an interest in IT but here’s a helping hand. After a DDOS attack on the website for VideoLAN, one of their developers, Ludovic Fauvet, created a very clear visualization on this topic using Logstalgia. Just watch the video below, it’s pretty well done!
Interesting question I’ve got here,… sounds like a true follower! 
It’s quite easy really! Just head over to http://www.arnecroughs.be/feed/ and subscribe using your RSS reader (Outlook will do).
Remember the Office365 migration effort calculator I’ve tested? The company who built it, ScienceSoft in Belarus, were kind enough to call me back and followed up on my test. They told me a new version of the test was being release somewhere during this week and I’m very much looking forward to test it again!
Today I passed my Prince2 Foundation exam after a 2-day course at Global Knowledge. The course was given by Jasper Vilé.
I can highly recommend taking a course or at least learning about this to everyone working in projects, managed through PRINCE2. You’ll have a much better understanding on how, why and when certain actions have to be taken and if they have to be taken. If only, you can compare the methodology to how the project process works in your company and (try to) assess and improve the structure.
Windows
I’ve create a batch script to automize the fix for the clipboard issue I’ve been having. You can now download it on our brand new downloads page.
Office365
Remember this one? A while back, I discussed the issue of seeing the ‘To’ field in Exchange Online in Asian characters. Microsoft Support told me that implementation of a fix would take several weeks. So look at it now,… No more Asian characters in my Exchange Online window. Well done Microsoft!
Must say that a short call would have been rather nice to inform me…
Office365
Just noticed in the portal that there are 2 maintenance windows coming up for Office365. One today and one April 16th. I’ve added a calendar to the side bar, you’ll find all information here!