TechNet Blogs

OpenText related blog posts

| |

Enterprise Applications on Microsoft SQL Server

Impressive Results: SQL Server 2012 and OpenText Email Monitoring and Records Management

Posted 1 month ago

by Neeraj A Joshi
- 0 Comments
In February 2012, OpenText and Microsoft conducted performance and scalability testing on the email-monitoring and records-management components of the OpenText ECM Suite running on the Microsoft SQL Server 2012 data-management software. The benchmark...
Enterprise Applications on Microsoft SQL Server

OpenText: Multiple Instances or a Single Instance of SQL Server - Part 4: Uninstalling Instances

Posted 10 months ago

by Ken Lassesen
- 0 Comments
[ Prior Post ] In the prior post of this series, I recommended not uninstalling the other SQL Server instances unless you are planning to reuse the license elsewhere. Reasons to retain the instance include: It can take a significant amount of...
Enterprise Applications on Microsoft SQL Server

OpenText: Multiple Instances or a Single Instance of SQL Server - Part 3: Disabling Instances

Posted 10 months ago

by Ken Lassesen
- 0 Comments
[ Prior Post ] [Next Post] In the prior post of this series, we showed how to move databases to one SQL Server instance. Once this process is completed, we need to disable or uninstall the other instances. My recommendation is to always disable instances...
Enterprise Applications on Microsoft SQL Server

OpenText: Multiple Instances or a Single Instance of SQL Server - Part 2: Moving Databases

Posted 11 months ago

by Ken Lassesen
- 0 Comments
[Previous Post] [ Next Post ] In our last post, we described how random acts of installation may result in two or more instances of SQL Server on the same machine. If you are reading this post, you are likely the proud owner of such a machine. Moving...
Enterprise Applications on Microsoft SQL Server

OpenText: Multiple Instances or a Single Instance of SQL Server - Part 1: Counting Instances

Posted 11 months ago

by Ken Lassesen
- 0 Comments
[Next Post] OpenText often installs with two SQL Server databases. One database is for OpenText and the other database is for Microsoft SharePoint Server. This often leads to random acts of installation including putting two or more instances of SQL...
Enterprise Applications on Microsoft SQL Server

OpenText: When cash counts, go Microsoft SQL Server

Posted over 1 year ago

by Ken Lassesen
- 0 Comments
Recently I reviewed Steve Simpson's OPENTEXT document “ OpenText eDOCS DM 5.3 - Technical Architecture, Tips and Tricks ” and noticed some useful information worth repeating. Financial Cost difference between Oracle™and SQL Server...
Enterprise Applications on Microsoft SQL Server

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

Posted over 1 year ago

by Ken Lassesen
- 0 Comments
[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...
Enterprise Applications on Microsoft SQL Server

OpenText: Guidance for Administrators

Posted over 1 year ago

by Ken Lassesen
- 0 Comments
Contributed by Steve Simpson Optimizing your database is the key to good performance. OpenText libraries are created with generic performance parameters to support the basic document and record creation for an average customer site. Indexes created...
Enterprise Applications on Microsoft SQL Server

OpenText: Business Development Bank of Canada using SQL Server for their Commercial Lending Solution

Posted over 1 year ago

by Ken Lassesen
- 0 Comments
On March 28th, 2011 Business Development Bank of Canada (BDC) signed an agreement with the CGI Group for detailed analysis, manufacturing, testing and rollout of the commercial lending IT solution. This solution will be based on Microsoft technology consisting...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes

Posted over 1 year ago

by Ken Lassesen
- 3 Comments
[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...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

Posted over 1 year ago

by Ken Lassesen
- 1 Comments
[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...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Creating a Workload by Using a Trace Log

Posted over 1 year ago

by Ken Lassesen
- 0 Comments
[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...
Enterprise Applications on Microsoft SQL Server

OPENTEXT Acquires Metastorm–a SQL Server based BPM product

Posted over 1 year ago

by Ken Lassesen
- 0 Comments
On February 18, 2011 OPENTEXT acquired the Business Process Management (BPM) firm Metastorm , a Microsoft Gold Certified Partnership . This is an ideal complement to OPENTEXT, especially when OPENTEXT is running on SQL Server 2008 R2. There are significant...
Enterprise Applications on Microsoft SQL Server

Best Practices Analyzer for ISV SQL Servers to protect your company’s property

Posted over 1 year ago

by Ken Lassesen
- 0 Comments
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...
Enterprise Applications on Microsoft SQL Server

Migrating from Oracle to SQL Server

Posted over 1 year ago

by Ken Lassesen
- 0 Comments
[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...
Enterprise Applications on Microsoft SQL Server

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

Posted over 1 year ago

by SQL Server ISV
- 0 Comments
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...
Enterprise Applications on Microsoft SQL Server

OpenText Content World 2010 Presentation on Technical Architecture, Tips and Tricks

Posted over 2 years ago

by SQL Server ISV
- 0 Comments
OpenText announced today via twitter that over 100 OTCW (OpenText Content World) breakout presentations were available for download. Steve Simpson (a Senior Principal Product Specialist from OpenText) did a presentation on OpenText eDOCS DM 5.3 - Technical...