Browse by Tags

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

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

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

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

[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 SQL Server databases is a very rare event for most...

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

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

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

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

It is often a challenge to keep up with supporting your own applications, let alone changes to the underlying platforms, such as Microsoft SQL Server, that the application supports. In the face of these changing conditions, the only way to ensure that your application remains functional, reliable, and...