# Create indexes without DATAAREAID in Dynamics 2009

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.

# Configure SNMP with Powershell

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

# Tracking E-mail on Exchange With Powershell

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: AddressList StartDate EndDate 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.

# Resource Governor Pool Calculator

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.

# Failing SQL 2005 cluster installation because of amount processors

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.

# Prepare SQL Server 2005 in a clustered environment for SP3

Introduction Recently I was asked to create a new high-availability solution for MS SQL Server 2005. When I finished the installation of SQL Server 2005, I found myself troubled as to why the installation of SP3 failed with the update of the database services. After a lot of searching, I found the solution to my problem. Because I spend a lot of time figuring out why my installation failed I decided to write this article so other people won’t have to spend so much time and frustration installing the service pack.