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: INFOR ERP: CPAC, Inc uses SQL Server for ease of use and scalability

    CPAC Inc. is a company that serves clients in over 100 countries. For Enterprise Resource Planning (ERP) they selected INFOR ERP Syteline running on SQL Server. The case study is available here . The case study cites: “System integrity and seamless integration with other software were primary...
  • 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: Infor: World Largest Outdoor Advertising Company selects EAM on SQL Server

    Your first question is likely, "What is meant by Outdoor or Out-of-home advertising ?" It means advertising via static billboards, bus stops advertisement, van and taxi advertisement -- even bicycle advertisements. There are dozens of formats. The world largest advertising company is Clear Channel. ...
  • Blog Post: Benchmark Results: Infor EAM and SQL Server 2008 R2

    Infor EAM is a leading enterprise asset management (EAM) software solution that has been helping companies worldwide—including more than 60% of the Fortune 500—for more than 20 years. Infor recognizes that Microsoft is a key vendor in many of their customers' businesses and has engaged in...
  • Blog Post: I'll take SQL Server on HP ProLiant DL980 G7 For The Win (Infor ERP LN)

    Saying that SQL Server is the best database platform for an application is one thing… proving it is another. Recently Infor tested it's ERP LN (Infor’s top ERP application) on the new 8-socket Intel Xeon powered HP ProLiant DL980 G7 scale-up server and achieved it’s highest Baan/LN...
  • 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: INFOR ERP: Flick Packaging choice SQL Server to control costs

    Flick Packaging Company provides military and various commercial industries with packaging systems. For Enterprise Resource Planning (ERP) they selected INFOR ERP VISUAL running on SQL Server. The announcement is available here . The announcement cites that controlling costs was a significant factor...
  • 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: Infor: Heading to Chile? Budget on AVIS running on SQL Server

    In the developing world, there is often a shortage of two things: money and technical skills. People with top technical skills often immigrate to better paying markets, adversely impacting the local economy. AVIS-Budget Chile has grown from a single desk with 10 cars in Santiago in 1970 to every airport...
  • 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: Migration: The value gained moving from Sybase to SQL Server 2008R2

    [DB2 Migration Value] [ Oracle Migration Value ] In the early 1990's I was a consultant to Microsoft when the first alphas of SQL Server were tested as a replacement for Sybase on internal production systems. Those days were sweet because we were working directly with the SQL Server product developers...
  • Blog Post: INFOR ERP: Navico uses SQL Server and Syteline to replace older ERP system

    Navico is a worldwide supplier of marine electronics with 2,500 employees globally. For Enterprise Resource Planning (ERP) they selected INFOR ERP Syteline running on SQL Server to replace their MANMAN ERP system . The case study is available here . The case study cites that SQL Server: “...
  • Blog Post: INFOR ERP: Finding all tables that uses a specific column name

    Author: This article is written by our contributing author Ken Lassesen. His bio can be found here . With INFOR Enterprise Resource Planning (ERP), administrators often need to know where a specific column occurs in the many tables of the database. This issue is not unique to INFOR and...