Defining ILM Best Practices
The ILM Best Practices website provides information about Microsoft Identity Lifecycle
Manager [ILM]. Microsoft ILM is the new name for the former [MIIS] Microsoft Identity Integration
Server 2003 Service Pack 2 with the Certificate Lifecycle Manager.
Further information about ILM and MIIS can be found at
Microsoft IDA.
You can get information about ILM training by contacting
ILM MIIS Training from Microsoft.
At the 2007 Directory Experts Conference in Las Vegas, David hosted two intermediate level sessions. The slide presentations from the sessions are available below:
Fuzzy Transforms for MIIS Delayed Join Resolution
Monday, April 24, 2007 
Get Slides
When dirty data in existing systems creates a join nightmare, escape by unleashing the power of Fuzzy Transformations in SQL Server 2005 Integration Services. During the Data Discovery process is it quite common to encounter problems with joining identities from various systems together. HR has an Employeeid field, but has this been entered elsewhere? If so has it been accurately entered? If not we will match on names, but those are even more subject to error and duplicates. Learn how to make use of SQL Server 2005 Integration Services: Fuzzy Lookups and Fuzzy Grouping transformations to solve many of your unmatched and duplicate match problems encountered during joining.
Care and Feeding of MIIS SQL Server Database
Tuesday, April 25, 2007
Get Slides
Are your synchronization runs taking too long? Does it take a while to load up Identity Manager because of run history? When you clear run history, does your transaction log get so big that your DBA starts screaming at you that the log is full or that the disk is out of space? Is your Run History clogging up your database? Learn how to Automate Clearing the Run History without filling up the transaction log – even if you haven’t cleared it in a while. Learn the best practices of backing up your MIIS database and maintaining your indexes and statistics. Harness the power and ease of SQL Server Agent jobs to automate your maintenance, schedule your run profiles and coordinate the execution of your DTS packages and other objects.
David recently delivered another pair of sessions at the 2008 Directory Experts Conference DEC 2008
David Lundell specializes in SQL Server and MIIS/ILM and has trained
employees from more than 30 different organizations on how to implement MIIS/ILM. Recently, David helped
a large telcom with an identity management crisis resulting from the impending spinoff of some
of their units.
David earned an MBA and a BS in Computer Engineering both from the Univerisity
of Arizona. His certifications include: MCSE, MCSD, MCDBA,
MCITP: Database Administrator, MCITP: Database Developer, CCNA,
and CNA. He is Microsoft Certified as a Trainer in Database
Development, Database Administration, Systems Engineering and Systems Administration.
He is also the author of a text on Microsoft Windows Server 2003.