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: Benchmark Results: Lawson System Foundation Running on SQL Server

    Lawson and Microsoft worked together on a series of benchmarking tests using Lawson System Foundation (LSF) 9.0.1 running on Microsoft SQL Server 2008 R2 Enterprise and Windows Server 2008 R2 Enterprise. The goal of the benchmark testing was to confirm that the LSF module running on the Microsoft platform...
  • 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: Lawson: S3 version 9.0 handles 256000 General Ledger Transactions with SQL Server taking a nap

    I recently read a white paper on the performance of Lawson S3 Enterprise Management System running on SQL Server 2008 and was struck by the idleness of SQL Server in handling the type of load seen with large corporations. The SQL Server hardware used was approaching prosumer levels: 2 x Quad Code...
  • 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: 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: Lawson: Support for Microsoft Platforms

    I have listed below which Microsoft technologies are supported by Lawson M3 (7.1) and S3 (9.0) releases. Architecture Tier Product Operating System Client Microsoft Office 2003 SP3 Microsoft Office 2007 SP1 Windows XP...
  • Blog Post: Migration: The value gained moving from DB2 to SQL Server 2008R2

    [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 of perceptions about DB2 and SQL Server. As a developer...
  • Blog Post: Solution Brief: Lawson System Foundation Running on SQL Server

    In August 2011, Lawson and Microsoft worked together to confirm the scalability and performance of Lawson System Foundation (LSF) 9.0.1 on SQL Server 2008 R2 Enterprise and Windows Server 2008 R2 Enterprise. Human resources, payroll, accounts payable, and general ledger application procedures were tested...
  • Blog Post: Lawson: AddTech's 80 operating companies uniting by M3 running on SQL Server

    I came across an article on AddTech and M3 in iStone.Magazine (2010, #5), page 4. Addtech is a Swedish company consisting of 80 operating companies in ten countries. During the financial crisis, they found that they could move from in-house staff to as-need staff from iStone. A factor in making this...
  • Blog Post: Lawson: LR Health and Beauty Systems stays healthy on SQL Server

    One of the largest German network companies in health and beauty products, LR Health & Beauty Systems GmbH (LR) went to Lawson M3 running on SQL Server to empower the company's growth strategy. LR operates in over thirty countries. The key factors for choosing M3 included: Lower total cost...
  • 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...