-
SSMA 2005 & 2008 V4.0 - 7 New additions
-
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.
-
Hyper-V and VHD performance
-
Catch the blog by the performance team around using Hyper-V and VHD files. Read it here.
-
XML - FAQ's from XML Team
-
Check the Part I and Part II of the Frequently asked questions around XML and .NET integration.
-
SharePoint Performance Optimization - The MS Story
-
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.
-
Using Microsoft Dynamics CRM to Reduce Non-Value-Add Activities at Microsoft
-
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.
-
Introduction to Hyper-V in Windows Server 2008
-
This has become the buzz word and it is difficult to keep track of all that happens around us. Catch this article over TechNet that talks about the basics around Hyper-V inside Windows Server 2008.
-
Microsoft Synchronization Services for ADO.NET - Updated
-
Synchronization Services for ADO.NET 1.0, which released with Visual Studio 2008, enabled synchronization between a server database and a SQL Compact 3.5 client database running on a desktop. With this download, you can also synchronize between a server database and a SQL Compact database on a Windows Mobile 5 or 6 device. Download it here.
-
VTD - Wraps up
-
We finished all the three days of our online premier event - Virtual TechDays. I would consider it a success and I had lots of fun delivering something on each and every day. 2 session on Day 1 and Day 2 and today I did a lightweight session around Office tools and productivity features with Nikhil on the common session.
Folks, who did manage to get to my blogs post the VTD, please do drop a line if you need any specific session for our next VTD's. Sessions around SQL will be good as I can see how relevant these can be to our general audiences and will surely slot them in.
-
Infrastructure Planning and Design Guide
-
This guide targets key information to bring your infrastructure up to date, thereby enhancing user experience and delivering business benefits. Find out how new features like Application Virtualization management support and support for Windows Server® 2008 clients will assist decision making in the planning of your Configuration Manager infrastructure. Follow detailed steps and graphics as you redesign your infrastructure, examining roles to be deployed and upgrade strategies to be used, along with designing sites and hierarchies. Use this guide to determine the scope of the services to be provided and choose to partially or completely redesign your infrastructure. Have confidence in knowing that the steps in each phase are described in detail and that the necessary tools are provided to manage the process. Join the Beta here.
Some related links:
System Center Configuration Manager 2007 SP1 with R2
System Center Operations Manager 2007
System Center Virtual Machine Manager 2008
-
VTD - What a start !!!
-
Whew, Day 1 of VTD is over but how glad am I to see that this was a super-duper hit for me :). Close to 600+ people logged online for each of my session. I couldnt have asked for more. Today I talked about "SQL Server Security" and "Beyond Relational: Managing unstructured and semi-structured data with SQL Server 2008". I had a lot to talk and I was super excited in doing each of these sessions. We did have some audio glitches but that is part of the online experiences :) ... But, I am sure people who attended had a wonderful time. Please feel free to drop a line to me over the blogs.
Now, that was not the end. I have two awesome sessions lined up for tomorrow - "5 hidden gems inside SQL Server" and "Extended Events" to speak. Moreover, there are also sessions around "Performance tuning" and "Top 10 DMV's you must know". These will be equally exciting sessions for tomm and you must attend them. Apologize for the shameless plugs, couldnt resist :) ...
The sessions start 10AM IST and you need to connect here to join us.
-
Free e-book: Introduction to SQL Server 2008
-
Get this free e-book on Introduction to SQL Server 2008. This atleast is a good starting point for people who want to understand the BI, High-availability, Programmability, Data-types etc introduced with SQL Server 2008. Just get online and keep reading :) ...
-
Data Mining UrlScan 3.0 Logs using LogParser 2.2
-
Check this interesting post on IIS.NET of using LogParser and getting vital stats. Read it here.
-
Power of Views with SSIS
-
This is an interesting and a common requirement of locking the schema once the SSIS package is created. Else I have seen manytimes the nasty error and we need to open the package to re-validate the Tasks. Check this post from Roche that explains how to mitigate this using simple views.
-
SQL 2005 - NS Components Package RC1
-
The SQL Server 2005 Notification Services components package made available in the February 2007 release of the Feature Pack for SQL Server 2005 is being updated to include server components and work with both SQL Server 2005 and SQL Server 2008 databases. This will surely be an interesting addition to the SQL Server 2008 arsenal and helps for backward compatibility and solutions who rely on NS features. Check the download here.
-
Free Data Structures and Algorithms Book
-
Book written by Granville Barnett and Luca Del Tongo is part of an effort to provide all developers with a core understanding of algorithms that operate on various common, and uncommon data structures. Download it here.