Browse by Tags

Related Posts
  • Blog Post: 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...
  • Blog Post: Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes

    [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 they save. Indexes primary use is to find records...
  • Blog Post: Step-by-step guidance for setting up high availability for the PROS Pricing Solution Suite running on SQL Server 2008 R2 Enterprise

    Pricing is a powerful lever for improving business profits. Organizations can use the PROS Pricing Solution Suite (PPSS) to uncover the value that is hidden in their data and to improve their financial performance. Because continuous access to PROS data is critical for an organization, Microsoft SQL...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Migrating from Oracle to SQL Server

    [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 those days, computer manufacturers often had different...
  • Blog Post: PROS: Tarmac cements future growth and profits with PROS Pricing running on SQL Server

    Tarmac is a cement and aggregates manufacturer operating in the United Kingdom. Tarmac produces the material to build roads and buildings: crushed rock, sand, gravel, asphalt, cement, concrete and mortar. Tarmac was PROS' first customer in the quarrying and construction industry. "PROS' references...
  • Blog Post: Migration: The value gained moving from Oracle to SQL Server 2008R2

    [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 like dBase II were power-user friendly but...
  • Blog Post: PROS: Energy pricing showcased on SQL Server

    PROS, the world leader in enterprise business-to-business pricing and margin optimization software showcased its energy industry solution at the Microsoft Global Energy Forum 2011 in Houston, TX. PROS showcased how they worked together with Microsoft to enable customers to improve control, visibility...
  • Blog Post: PROS: Oracle to SQL Case Study

    Companies must address complex pricing issues, involving increasingly sophisticated trading partners, to improve profitability in business-to-business (B2B) transactions. Successful pricing software needs to deliver meaningful business intelligence to front-line sellers in real time, integrate with existing...
  • Blog Post: TechNet Webcast: Best Practices on Deploying PROS with SQL Server

    Event Overview Join us for this webcast as we share the best practices for deploying the PROS Pricing Suite application on Microsoft SQL Server 2008 data management software. We talk in detail about performance, high availability, and scaling the Pricing Suite application on the Windows Server 2008 R2...
  • Blog Post: 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...
  • Blog Post: PROS: Reducing the cost to health care by using SQL Server

    A leading health care distribution company selected PROS on SQL Server to increase visibility into transaction types, and identify opportunities within customer and product segments. “the company needed a partner that would hold down total cost of ownership. PROS leveraged its relationship...