Archive for September, 2008

SSMA 2005 & 2008 V4.0 – 7 New additions September 30th, 2008

Vinod Kumar

SSMA 2005 for Oracle 4.0 : http://www.microsoft.com/downloads/details.aspx?FamilyId=6D9BC6A7-75DA-493E-BEE5-50F4A4352B91&displaylang=en
SSMA 2008 for Oracle 4.0 : http://www.microsoft.com/downloads/details.aspx?FamilyId=3E8722AE-77F3-4288-906D-F421E24D322F&displaylang=en
SSMA 2005 for Sybase 4.0 : http://www.microsoft.com/downloads/details.aspx?FamilyId=842B092D-C123-4C76-8051-30B16E45D554&displaylang=en
SSMA 2008 for Sybase 4.0 : http://www.microsoft.com/downloads/details.aspx?FamilyId=4FC68B67-149F-4237-8869-E70B68947F4F&displaylang=en
SSMA 2005 for Access 4.0 : http://www.microsoft.com/downloads/details.aspx?FamilyId=4ECD1E67-C64E-49E6-821E-C4D83D9D5FED&displaylang=en
SSMA 2008 for Access 4.0 : http://www.microsoft.com/downloads/details.aspx?FamilyId=133B59C2-C89C-4641-BEBB-6D04476EC1BA&displaylang=en
SSMA 2008 for Sybase PowerBuilder Applications 1.0 : http://www.microsoft.com/downloads/details.aspx?FamilyId=AD09F718-7D6F-499B-8A6A-0EA98E0C0295&displaylang=en

Some new features include:

i. Converter for Oracle was greatly improved. New SQL and PL/SQL constructions such as ROLLUP/CUBE clauses, MERGE statement, NEXTVAL/CURVAL in one statement can now be converted. New packages DBMS_LOB, DBMS_SQL are migrated to T-SQL. Long awaited conversion or record variables into multiply variables (instead of single XML variable) is now a converter option. XML emulation of records and collections was revised.
ii. Converter for Sybase can now work with new Sybase 15.0 datatypes. Temporary tables created with SELECT INTO statement are supported, along with IDENTITY function in SELECT INTO statement. Temporary tables conversion has been improved greatly (“temporary table clean up option” was introduced, constraints and indexes for temporary tables conversion added, Pre-SQL text for procedures and triggers added). Many other migration algorithms have been redesigned.
iii. SSMA now supports Microsoft SQL Server 2008 as a target server. New SQL Server 2008 features make it possible to generate more efficient T-SQL code during conversion. Extended DATETIME datatypes, MERGE statement, CLR implementation for Oracle collections are just few examples.
iv. SSMA for Access now support Access 2007 databases
v. Tester component has been added to SSMA for Sybase. New features of Sybase Tester (such as tables’ data testing and new comparison modes) were added to Oracle Tester too.
vi. SSMA v4.0 users can now enjoy new usability features like layouts, bookmarks, advanced browsing and search, banners
vii. SSMA v4.0 installation does not require J# redistributable anymore.

Continue reading...


 

Hyper-V and VHD performance September 27th, 2008

Vinod Kumar

 Catch the blog by the performance team around using Hyper-V and VHD files. Read it here.

Continue reading...


 

XML – FAQ’s from XML Team September 26th, 2008

Vinod Kumar

 Check the Part I and Part II of the Frequently asked questions around XML and .NET integration.

Continue reading...


 

SharePoint Performance Optimization – The MS Story September 23rd, 2008

Vinod Kumar

After deploying Microsoft Office SharePoint Server 2007 in the corporate production environment, Microsoft IT noticed opportunities to enhance performance, especially long page render times, and spikes in disk I/O and CPU utilization. By working to discover root causes, Microsoft IT identified areas of opportunity for performance optimization, including the back-end SQL Server storage subsystem, and front-end IIS servers. Download this interesting whitepaper here

Continue reading...


 

Using Microsoft Dynamics CRM to Reduce Non-Value-Add Activities at Microsoft September 22nd, 2008

Vinod Kumar

 The Microsoft OEM division has developed an implementation of Microsoft Dynamics CRM to reduce the Non-Value Add Activities of the OEM Sales and Marketing teams. The goal of the program was to reduce by 30% these Non-Value Add activities. Download the paper here.

Continue reading...