A deployment reference architecture and guidance for implementing an HADR solution for TEMENOS T24 running on the Microsoft Application Platform

As part of their strategic alliance, Microsoft and Temenos worked together to define a recommended deployment architecture that provides high availability and disaster recovery (HADR) for the TEMENOS T24 core banking solution running on the Microsoft Application Platform and using Microsoft technologies. The main goal for this effort was to minimize the number of Microsoft…

0

Fundamentals: DBCC – SQL Server’s FDISK

[Prior Post In Series]     [Backup Series]  [Next Post in Series] In a time long long ago (last millennium), DBCC was known as Database Consistency Checker; today it stands for Database Console Command. It performs many functions similar to what the old utility FDISK did on hard drives — checks for errors of various types and…

0

Backups: Doing it right so you can recover quickly!– Automating the backups

[Prior Post]    [Next Post] Getting backups scheduled appropriately tends to be a slow process with a lot of keying and mouse clicks.  The process can be simplified by the use of a couple of scripts that will backup every database on your SQL Server (including databases added to your SQL Server later!) There are three…

1

Backups: Doing it right so you can recover quickly! – Checking backups have occurred.

[Next Post] Over the last few months I have been reviewing presentations at user conferences and talking to consultants about their experiences. Backups are a real problem for many installations. The two critical problems that I have seen are: Transaction logs containing years of transactions. User presentations advising an inappropriate backup model. Either of these…

1

Mini-Lab – Part 2 – Backup Compression with Resource Governor

[Prior Post in Series] In Part 1 of this 2 part Mini-Lab series we looked at a new feature that was introduced in SQL Server 2008 called Backup Compression.  We were able compress the backups of our test database ( 2008FeaturesDB ) to roughly 10% of the size of the uncompressed full backup while also…

5

Mini-Lab – Part 1 – Backup Compression

[Next Post in Series] In previous blog posts we have touched briefly on some of the new features that were introduced in SQL Server 2008 but if you’re like me you need to get your hands dirty and work with them before you really understand and see the value. BACKUP COMPRESSION Backup Compression which was…

0

Backing Up Your Siemens Teamcenter Databases

Ask any DBA what the single most important part of their job is and their answer should always be backup/recovery.  The DBA plays a critical role in being able to recover the databases (and overall availability) from a failed state.  Backups can be a tricky thing to define as there can be external pieces that…

0

Scalable, Reliable, Secure, and Cost-Effective (Dassault Systems ENOVIA V6 on SQL Server 2008)

Engineers from Dassault Systèmes and Microsoft ran benchmarking tests to measure the performance and scalability for ENOVIA V6 with SQL Server 2008.  The tests were designed to reflect real-world usage patterns of ENOVIA V6 customers. The benchmarking tests simulated up to 5,000 collaborative users (a number typical for a large enterprise environment). The transaction times…

0

DBA 101: Choosing a Database Recovery Model (Siemens Teamcenter)

The recovery model of a SQL Server database determines how changes are recorded and stored in the database’s transaction log. The three options for the recovery model are Full, Bulk-logged, and Simple: Full: This is the best model for preventing critical data loss and restoring data to a specific point in time, and it is…