Best Practices for Running Temenos T24 on SQL Server and Windows Server

SQL Server provides an ideal database platform for TEMENOS T24. By choosing the Microsoft platform, T24 customers experience faster funds transfers, higher security-trade volumes, and quicker close-of-business processes. This white paper provides best practices for configuring and running T24 on SQL Server 2012, SQL Server 2008 R2, and Windows Server 2008 R2, including guidance for building…

0

Misys: Managing Risk & Compliance in a Volatile Market: Streamlining Trades and Ensuring ROI (Free Aberdeen Webinar!)

Global financial turmoil has grown, from the credit crisis crippling many financial institutions, to the current debt crisis that is bringing much valuation uncertainty to the capital markets. Within this market uncertainty is the firms continued commitment to reduce operational risk and cost, ensure regulatory compliance, and improve ROI measures. These initiatives are a necessary…

0

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

[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 time to do compared to disabling. It will only free up a little disk space. If…

0

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

[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 and delay uninstalling the instance. Disabling the instance is quick and can be…

0

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

[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 Server on the same computer. This situation should be avoided for several reasons: Each instance consumes a license,…

0

OpenText: Guidance for Administrators

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 on the database by Library Generator benefit when clients tune them to their environment. As the volume of data…

0

INFOR ERP: Finding all tables that uses a specific column name

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 applies to many ISV products.   I noticed…

2

How To: Clean up old database backup history

The MSDB database is a system database that stores important configuration and historical information relating to SQL Server system functionality like: Jobs Log Shipping Alerts and Notifications Operators Policies Database Mail Mainteance Plans Data Collector Backup and Restore operations Depending on how you perform certain operations orphaned data can exist that will remain in your MSDB…


Great SQL Server Whitepapers – all in one location

SIlvano Coriani has done a great job compiling the most relevant SQL Server whitepapers available on SQL CAT and Technet sites.  These papers are categorized into the major categories of Performance and Tuning, High Availability and DR, Security, Manageability, Migrations and Upgrade and Business Intelligence. The papers are a great resource for customers who want…

2