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: 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: Proven Performance for Accenture Duck Creek Policy Administration Commercial Lines on SQL Server 2012

    Accenture, Microsoft, and Intel worked together to test the performance and scalability of Accenture Duck Creek insurance policy-administration software for Commercial Package Policies (CPPs) running on SQL Server 2012, Windows Server 2008 R2, and servers based on the Intel Xeon processor family. ...
  • 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: Accenture: XL Insurance uses ACCS on SQL Server to excel globally

    XL Insurance is implementing a new centralized global claims management system based on the Accenture Claim Components solution. XL Insurance is already in use in the U.S., Canada and Bermuda. The next phase expands to South America, Europe and Asia. It was important to XL Insurance to have a best-in...
  • Blog Post: Accenture: ACE Private Risk Services takes no risks running on SQL Server

    ACE Private Risk Services handles high-net-worth personal lines insurance business. Accenture Claim Components (ACC) running on SQL Server handle all claims submitted under its personal and specialty lines. "We believe a high-performing claims management system is critical to achieving customer satisfaction...
  • 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: 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: Accenture: SQL Server helping to transform the P&C industry

    IDC Financial Insights recently issued a white paper, Delivering Customer Value Through Improved Policy Administration and Claims Management Solutions. This white paper focused on how Accenture and Microsoft are transforming the Property and Casualty (P&C) insurance industry. The forces affecting...
  • 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...