Categories
Tech

Setting Up a JMeter Instance on the Cloud to Inject Load Against Microsoft SQL Azure

So, you want to set-up load injection capabilities on the Amazon EC2 cloud to throw load against a Microsoft SQL Azure database?

This quick tutorial will show you how to do the following:

  • Setting up Apache JMeter (version 2.4 as of this post) on the Amazon EC2 Cloud
  • Setting up appropriate JDBC drivers
  • Setting the correct connection attributes to be able to successfully connect to the Microsoft SQL Azure database
Categories
Tech

Setting JMeter Timestamp to Human Readable Format in Logs

The default timestamp format in JMeter csv logs is given in a Unix style format.
For some (including my colleagues and I), this simply introduces an unnecessary delay to the analysis process of performance tests. Granted it is pretty straightforward converting the format from Unix time to human time with the help of the Excel ‘HOUR’ function, but when you are analysing many tests, it becomes slightly repetitive and cumbersome when you have an option in JMeter to switch to a more human readable format 🙂

Categories
Tech

Archiving a User’s Mailbox on Office 365

So an employee has left the company and you now need to archive the mailbox due to legal and/or company policies.
This article will give you a quick overview on how you can achieve this goal on an Office 365 mailbox while maintaining the integrity and security of your organisation’s 365 account.
Although not necessary, I recommend (as a pre-requisite) disabling account ‘sign-in’ capabilities and resetting the user account password.
This will prevent the user from logging in to the account and messing around with it whilst you are attempting to archive their mailbox.

Categories
Tech

Disable Remote PowerShell for Office365 Users

For one reason or another, you may want to disable remote PowerShell access for all the users in your organisation.
The main reason for doing so would be to prevent ‘reconnaissance’ type attacks whereby a user will try to gain information about your network/organisation/topology/system etc by simply running (in this case) PowerShell queries against your organisation.

Categories
Tech

Add E-mail Aliases to Your Office 365 Distribution Groups

If you’ve set up distribution groups on Office 365, you will notice a section in the DG ‘details’ page titled ‘E-Mail Options’… under this title is the following text:
“The group can receive messages sent to the following addresses.”

From this, you can safely assume that it is possible to add e-mail aliases to the group so that the group can receive e-mails sent to several different e-mails.
Sadly, there is no easy way of actually doing this via the UI so it must be done via a PowerShell command…