Wednesday, July 26, 2006

SQL Server 2005 vs 2000 Components

When customers received from Microsoft the latest CDs it included GP 9.0, FRx 6.7 and SQL Server 2005.

A lot of questions had been asked in forums about the difference between SQL Server 2000 and 2005. Below is a table which shows the components of both versions:
Component SQL Server 2000 SQL Server 2005

Extract, transformation, and load

Data Transformation Services (DTS)

SQL Server 2005 Integration Services

Relational data warehouse

SQL Server 2000 relational database

SQL Server 2005 relational database

Multidimensional database

SQL Server 2000 Analysis Services

SQL Server 2005 Analysis Services

Data mining

SQL Server 2000 Analysis Services

SQL Server 2005 Analysis Services

Managed reporting

SQL Server 2000 Reporting Services

SQL Server 2005 Reporting Services

Ad hoc reporting


SQL Server 2005 Reporting Services

Ad hoc query and analysis

Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal)

Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal)

Database development tools

SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other

SQL Server 2005 Business Intelligence Development Studio

Database management tools

Enterprise Manager, Analysis Manager

SQL Server 2005 SQL Server Management Studio

Wednesday, July 05, 2006

Microsoft MVP for Dynamics GP

I'm very proud to say that I've been awarded the Microsoft Most Valuable Professional (MVP) for Dynamics GP. I'm very passionate about this product and had been supporting it since 1996. I’ll be around the community and hopefully would be fortunate to see the next wave of transformation including the deployment of the merge product in the near future. My congratulations to the other awardees.

Below was the email I got from Microsoft:

Hello everyone,

I know you are all anxious to hear our new MVPs are effective today. Firstly, all existing Dynamics MVPs were re-awarded so there is no one leaving the fold J

So let us welcome the following to our community:

GREAT PLAINS
Duke DelPrado
Richard Whaley
Brenner Klenzman

CRM
Ronald Lemmen
Frank Lee

Navision
Ahmed Amini
Alain Krikilion

Solomon
Toni Savage

I also want to mention Will Hadley. Will was to be awarded an MVP in CRM but sadly Will passed away last week at a very young age.

Melissa Travers
MVP Lead | Microsoft Exchange Server,
ISA Server, Virtual Machine,
Windows Security & Dynamics
Tel. 980.776.9678| mtravers@microsoft.com
http://www.microsoft.com/mvp

Digital Transformation unleashed

You're the CIO/CDO sitting in your weekly update executive meeting with the CEO, CFO, COO, and others. You start the meeting with the pr...