White Paper: SQL Server 2008 R2 Provides Enterprise-Class Performance and Scalability for SunGard Front Arena

Today’s investors demand a wider variety of asset classes, more complex financial instruments, and a broader geographical range of products than ever before. SunGard meets these demands with Front Arena, an integrated cross-asset platform for sales, trading and risk management, operations, and distribution. Front Arena was designed to handle very large data flows; in high-volume…

0

Solution Brief on Benchmark Results: SQL Server 2008 R2 Provides Enterprise-Class Performance and Scalability for SunGard

SunGard, the largest privately held business software and IT services company, provides software solutions for many industry verticals. For the financial sector, SunGard offers Front Arena, an integrated cross-asset platform for sales, trading and risk management, operations, and distribution. Front Arena was designed to handle very large data flows; in high-volume environments such as equities…

0

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

[DB2 Migration Value]  [Oracle Migration Value] In the early 1990’s I was a consultant to Microsoft when the first alphas of SQL Server were tested as a replacement for Sybase on internal production systems. Those days were sweet because we were working directly with the SQL Server product developers and had turnaround of a few hours…

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

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