Technet Blog Images
Enterprise Applications on Microsoft SQL Server
Search this blog
Search all blogs
Email Blog Author
RSS for posts
RSS for comments
Browse by Tags
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...
16 Nov 2011
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...
25 May 2011
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...
19 May 2011
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...
10 May 2011
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...
5 May 2011
Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes
[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...
15 Apr 2011
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...
8 Apr 2011
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...
1 Apr 2011
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...
30 Mar 2011
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: “...
29 Mar 2011
INFOR ERP: CPAC, Inc uses SQL Server for ease of use and scalability
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...
23 Mar 2011
INFOR ERP: Finding all tables that uses a specific column name
SQL Server ISV
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...
22 Mar 2011
Best Practices Analyzer for ISV SQL Servers to protect your company’s property
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...
7 Mar 2011
Migrating from Oracle to SQL Server
[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...
4 Mar 2011
Right sizing ISV installations for the best bang for the buck!
SQL Server ISV
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...
28 Feb 2011
I'll take SQL Server on HP ProLiant DL980 G7 For The Win (Infor ERP LN)
SQL Server ISV
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...
20 Oct 2010
Page 1 of 1 (16 items)
© 2013 Microsoft Corporation.
Privacy & Cookies