Browse by Tags

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...

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...

[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...

[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...

[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...

[Prior Post in Series] [Next Post in Series] In my prior posts, I looked at adding indexes with Database Engine Tuning Advisor. In this post, I will look at the other side of the coin and delete indexes that are unused or that cost more resources than they save. Indexes primary use is to find records...

[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...

[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...

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...

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: “...

CPAC Inc. is a company that serves clients in over 100 countries. For Enterprise Resource Planning (ERP) they selected INFOR ERP Syteline running on SQL Server. The case study is available here . The case study cites: “System integrity and seamless integration with other software were primary...

Author: This article is written by our contributing author Ken Lassesen. His bio can be found here . With INFOR Enterprise Resource Planning (ERP), administrators often need to know where a specific column occurs in the many tables of the database. This issue is not unique to INFOR and...

The intellectual property(IP) or other valuable information may be stored on SQL Server in your ISV product. Its value is more than credit card records (credit cards can be cancelled if lost, IP can’t). It may be the equivalent of a state secret for your firm. Microsoft provides two versions of...

[Next Post in Series: Kronos Migration] My first experience with data migration dates from the 1970’s when a firm was moving from a Honeywell Mainframe (64KB of memory, no DASD -- just tape drives) to an IBM 4331 (2 MB of memory and DASD). In those days, computer manufacturers often had different...

Author: This article is written by our contributing author Ken Lassesen. His bio can be found here . Recently I have seen two configurations that caused me to shake my head in disbelief. In reality, the problem is the classic one of people working off valid but stale past knowledge. Two...

Saying that SQL Server is the best database platform for an application is one thing… proving it is another. Recently Infor tested it's ERP LN (Infor’s top ERP application) on the new 8-socket Intel Xeon powered HP ProLiant DL980 G7 scale-up server and achieved it’s highest Baan/LN...