SQL Server Product Managers Adam Carroll and Al Hilwa explore some common misconceptions regarding IBM DB2 and compare IBM DB2 version 8.1 to SQL Server 2000. To view these videos, you'll need Windows Media Player.
| Resources | Topic Samples | Download or View File |
Part 1: | Microsoft's Adam Carroll and Al Hilwa introduce the topics of comparison between IBM DB2 and SQL Server 2000. | |
Part 2: | Many customers assume that IBM DB2 is a single product, but there are a number of IBM DB2 products with different storage architectures, error messages, and structured query language (SQL) syntax. | |
Part 3: | Though known to scale well on the mainframe, not all IBM DB2 environments are equally scalable; and while the mainframe is a good workload consolidation environment, it has few performance proof points running modern-day application architectures. | |
Part 4: | IBM DB2 is known to run centralized data warehouses through a partitioned database architecture that is difficult to plan for, install, and manage. | |
Part 5: | IBM provides tools to address inherent complexities in IBM DB2, rather than providing automatic or truly self-managing features. | |
Part 6: | IBM has made some product packaging changes with minimal implications for customers but the price increases of the enterprise edition are significant. | |
Part 7: | IBM DB2 has a way to go in terms of natively supporting SQL stored procedures, whereas Microsoft SQL Server has supported SQL stored procedures from version 1.0. |