Proven Performance: Aspen PIMS Platinum Running on SQL Server 2012

Aspen PIMS Platinum—the newest product  in AspenTech’s industry-leading solutions for petrochemical and refinery planning and optimization—helps planners make fast, accurate, and profitable decisions about production, plant operations, feedstock selection, and market responses. PIMS Platinum provides powerful new user interfaces and analytical features that are accessible over the web. Running Aspen PIMS Platinum on SQL Server…

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

ASPENTECH: AspenONE Support for Microsoft Platforms

I have listed below which Microsoft technologies are supported by AspenTech AspenONE with the release of 7.2. Architecture Tier Product Operating System Client Microsoft Office 2003 SP3Microsoft Office 2007 SP1IE 6 SP2IE 7IE 8 Windows XP SP3 (32 bits)Windows Vista SP (32 bit)Windows 7 (32 bit) Windows Server 2003 (32 bit)Windows Server 2008 R2 (64 bit) Application…

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

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 its free Best Practices…

0

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 character codes (EBCDIC…

0

Right sizing ISV installations for the best bang for the buck!

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 SQL Server configurations were:…

0