TechNet Blogs

Enterprise Applications on Microsoft SQL Server

| |

Enterprise Applications on Microsoft SQL Server

Benchmark Test Results: SQL Server Provides Performance, Scalability, and Value for RedPrairie’s Parcel

Posted over 1 year ago

by ISV Apps on SQL
- 0 Comments
A team of engineers from RedPrairie and Microsoft worked together to test the performance and scalability of RedPrairie’s Parcel on Microsoft SQL Server 2008 R2 and the Windows Server 2008 R2 operating system. Tests were also run on a pre-release...
Enterprise Applications on Microsoft SQL Server

Benchmark Results: RedPrairie Commerce Suite running on SQL Server 2008 R2

Posted over 2 years ago

by ISV Apps on SQL
- 0 Comments
The RedPrairie Commerce Suite delivers an integrated shopping experience on the web, in stores, on mobile phones, on Facebook, and anywhere else consumers choose to interact with their favorite retail brands. Using Microsoft SQL Server as a database platform...
Enterprise Applications on Microsoft SQL Server

RedPrairie: Removing Unneeded Table Indices

Posted over 2 years ago

by lonnyeb
- 2 Comments
By David Erickson , RedPrairie I wrote some internal notes to our developers recently, that I called "Lessons from the Lab”. I had the pleasure of joining RedPrairie’s WM Product Development team at a Microsoft testing lab in Dallas, Texas...
Enterprise Applications on Microsoft SQL Server

RedPrairie: Improving performance by using Parallelism

Posted over 2 years ago

by lonnyeb
- 0 Comments
By David Erickson , RedPrairie Most of you know that computer CPUs are not getting faster anymore, instead they are getting more cores. Microsoft SQL Server has two parameters that control whether work goes to one core or to many cores. I'd like to...
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

RedPrairie: When cooking in almost 400 restaurants, SQL Server provides prompt service!

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Culver Franchising Systems, Inc. has grown to 381 restaurants since 1984. RedPrairie’s Performance Management solution running on SQL Server has given CFSI better visibility into the performance of Culver’s restaurants and menu items. The...
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: 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: 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

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

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

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