Benchmark Results: Infor EAM and SQL Server 2008 R2

Infor EAM is a leading enterprise asset management (EAM) software solution that has been helping companies worldwide—including more than 60% of the Fortune 500—for more than 20 years. Infor recognizes that Microsoft is a key vendor in many of their customers’ businesses and has engaged in a long-standing strategic partnership with Microsoft built on a…

0

Infor: Heading to Chile? Budget on AVIS running on SQL Server

In the developing world, there is often a shortage of two things: money and technical skills. People with top technical skills often immigrate to better paying markets, adversely impacting the local economy.  AVIS-Budget Chile has grown from a single desk with 10 cars in Santiago in 1970 to every airport in the country.  AVIS needs included: A need to improve productivity…

0

Migration: The value gained moving from Sybase to SQL Server 2008R2

[DB2 Migration Value]  [Oracle Migration Value] In the early 1990’s I was a consultant to Microsoft when the first alphas of SQL Server were tested as a replacement for Sybase on internal production systems. Those days were sweet because we were working directly with the SQL Server product developers and had turnaround of a few hours…

0

Migration: The value gained moving from Oracle to SQL Server 2008R2

[DB2 Migration Value]  [Sybase Migration Value] In the early 1980’s I was an Oracle Developer on mainframes and on MS-DOS using Oracle 5.1 on MS-DOS (distributed on some 20+ diskettes — I still have them). It was an interesting time because PC products like dBase II were power-user friendly but did not scale. Oracle scaled, but was…

0

Migration: The value gained moving from DB2 to SQL Server 2008R2

[Oracle Migration Value]   [Sybase Migration Value] Two decades ago, I made my living as a DB2 developer working for GTENW (now Verizon). In this year’s spring-cleaning, I came across my old DB2 certificates; perhaps it is time to do a spring-cleaning of perceptions about DB2 and SQL Server. As a developer, I have become hopelessly biased for…

0

Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

 [Prior Post in Series]   [Next Post in Series] In my last post Fundamentals: Creating a Workload by Using a Trace Log, I illustrated how to create a workload. In this post, I will look at the complimentary step, using the log as input to the Database Engine Tuning Advisor to identify performance-improving indexes. This in-depth process takes some…

2

Fundamentals: Creating a Workload by Using a Trace Log

[Next Post in Series] This is the kick-off post of a regular Friday series of posts, “Basic Skills for SQL Server ISV Administrators”. I have found that ISV Administrators are often Professional Engineers (P.E.) — rich in business knowledge and light in Information Technology expertise.  In this series of posts, I will give visual step-by-step instructions on…

0

INFOR ERP: Flick Packaging choice SQL Server to control costs

Flick Packaging Company provides military and various commercial industries with packaging systems. For Enterprise Resource Planning (ERP) they selected INFOR ERP VISUAL running on SQL Server.  The announcement is available here. The announcement cites that controlling costs was a significant factor in their decision: “Our company was at the growth point where we needed to…

0

INFOR ERP: Navico uses SQL Server and Syteline to replace older ERP system

Navico is a worldwide supplier of marine electronics with 2,500 employees globally. For Enterprise Resource Planning (ERP) they selected INFOR ERP Syteline running on SQL Server to replace their MANMAN ERP system.  The case study is available here. The case study cites that SQL Server: “provides data management and analysis that are enterprise-ready, highly scalable and…

0