TechNet Blogs

Enterprise Applications on Microsoft SQL Server

| |

Enterprise Applications on Microsoft SQL Server

Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

Posted over 2 years 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: Improving Insert and Update Performance by Dropping Unused Indexes

Posted over 2 years 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: Creating a Workload by Using a Trace Log

Posted over 2 years 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

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

Posted over 2 years 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

Migrating from Oracle to SQL Server

Posted over 2 years 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

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

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Oracle Migration Value] [Sybase Migration Value] Two decades ago, I made my living as a DB2 developer working for GTENW (now Verizon). In this year's spring-cleaning, I came across my old DB2 certificates; perhaps it is time to do a spring-cleaning...
Enterprise Applications on Microsoft SQL Server

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

Posted over 2 years 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

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

Posted over 2 years ago

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

Running Opics Plus on SQL Server 2012 increases performance in scenarios with heavy database utilization

Posted 11 months ago

by Tali Smith
- 0 Comments
Mysis Opics Plus is an out-of-the-box solution that helps financial institutions consolidate and streamline treasury processing, increase STP rates, reduce the cost of transactions, minimize reconciliation, and provide strategic web access for their customers...
Enterprise Applications on Microsoft SQL Server

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

Posted over 2 years 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

SQL Server 2012 provides performance, scalability, and value for Summit FT

Posted 11 months ago

by Tali Smith
- 0 Comments
Summit FT is the Misys cross-asset, front-to-back solution that specializes in derivatives and structured products for global investment banks. As part of their partnership, Misys and Microsoft worked together to demonstrate that Summit FT’s foreign...
Enterprise Applications on Microsoft SQL Server

Testing confirms the enterprise-class performance of Kondor+ and Misys Global Risk running on SQL Server and Windows Server

Posted 6 months ago

by Tali Smith
- 0 Comments
Kondor+ is a leading trade and risk management solution from Misys that lets users manage global trading activities on a single flexible, extensible platform. Misys Global Risk (MGR) is a framework for collaborative risk management, which includes components...
Enterprise Applications on Microsoft SQL Server

MISYS: Summit FT moved to SQL Server 2008 to reduce costs and improve efficiencies

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Misys has announced that Summit FT has migrated its product to SQL Server 2008 (32 bits) and planning to add support for SQL Server 2008 (64 bits) soon. Misys states that it is responding to market needs to reduce the total cost of ownership and improve...