SQL Server Consolidation

The estimated reading time for this post is 0 minutes

Allianz Malaysia Berhad (“AMB”) is part of Allianz Group in Germany. Allianz General Insurance Company Allianzhad few physical servers for every individual systems which each server uses SQL Server 2005 & 2008.  We introduced by Microsoft Malaysia to Allianz for accomplishing this project and at same timewe guided Allianz to purchase suitable SQL Server license for their business.

Key Points:

  • Project duration was 11 days within 1 month.
  • SQL Server login’s password remain same after login migration.
  • SQL Server Jobs and Schedules remain same and active.
  • Overal down time were less than 2 hours.
  • SQL Server database federation was done without down time.
  • All operational systems were remain intact during consolidation.
  • SQL Server installation and configuration were base on best practices.
  • We did not use Third-Party software.

Note: Our SQL Server Principal Consultant is the Only Microsoft Certified Master in South-East Asia.


Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

More Posts

Follow Me: