Speeding up Import times from SQL MAs

1. Snapshot Views to Tables If you are using a view to bring data from different tables into one location you may well find that your import times improve dramatically when you first copy the data into a table. Create a Table with the same fields as the view, in the same order. Take care…

Who needs Group Populator when you have Multivalue tables?

Getting members into groups seems to be an early hurdle for many people. Microsoft provide the Group Populator – an obtusely round-about method involving SQL tables, Select queries, input text files and code that must be run outside of MIIS. Once I got the hang of the multivalue aspect of the SQL MA, I couldn’t…

Keep Provisioning Logic out of the Provisioning Code

Early on in my MIIS project I had a consultant in to give me some pointers. He showed me how to create two functions ShouldObjectExist and ReadyForCreation at the top of my MVExtensions, and use them to control provisioning. Private Function ShouldObjectExist(ByVal mventry As MVEntry) As Boolean  << Evaluate mventry to determine if CS object…

What do you mean I have to WRITE CODE???

I first installed MIIS as a way of supporting the Exchange 2003 project I was working on. The environment was an educational institution with both short- and long-term courses, and hence a LOT of user churn. Add to that the large number (over 4000) of mail groups that were to be implemented – many of…