The problem

As I had an issue with the performance I wanted to create indexes without DATAREAID in Dynamics AX 2009.

The indexes didn’t have the DATAAREAID column which is automatically added to the index as the first column on creation.

Because the newly created indexes shouldn’t have this column in the first position I had a problem.
The second problem is that every time an update or synchronization takes place in Dynamics AX 2009 the database objects which are not part of the software architecture are removed.

Powershell can do a lot of stuff and with the right libraries, you can do about anything.

I had to configure the SNMP service on a bunch of servers and I wasn’t going to do this by hand for over 80 servers. It uses three parameters for configuring the service.

ServerList

Path to file that contains all the servers. The text file must have only one server per row.

Manager

I had a problem with the delivery of e-mails. The script presented below creates an Excel document with all the e-mails sent from a specific e-mail address with the event. The script takes four arguments:

1. AddressList
2. StartDate
3. EndDate
4. Output

AddressList

The address list is a mandatory parameter containing the full path to the text file containing the e-mail addresses. The file is formatted as follows:

Email
[email protected]
[email protected]

StartDate

The start date is the date from when the list is generated. The start date is not mandatory. If no parameter is given the standard start date is seven days from the day the script is executed.

I was very interested in the new features of SQL 2008, especially the Resource Governor.

By implementing the Resource Governor you need to calculate the maximum shared and the calculated maximum. In the MSDN documentation “Resource Governor Concepts”, Microsoft explains how this can be calculated.

Because I like to let computers do as much for me automatically as possible I created an Excel document that calculates the values for you.

Introduction

You come to work and set your mind to start installing your new SQL 2005 64-bit cluster. You’ve prepared your servers with the installation of Windows Server 2003 Enterprise Edition 64-bit, created all the right users and groups, all the IP addresses are available and all the needed disks are already created. There is a little more to it like names for virtual servers but that’s outside of the scope of this article.