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: PTC: An example of a production Windchill Backup plan

    Patrick Lee is the Windchill Administrator at Sierra Nevada Corporation (SNC). He shared his backup plan with me for their production databases. SNC has 4 instances of Windchill (3 @ version 9.1 M030, 1 @ version 10) with production databases approaching 20 Gigabytes in size. His Windchill...
  • 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: SQL Server Security – Additional Resources

    [Prior Post in Series] The intellectual property (IP) stored on SQL Server in your PLM may be your firm’s greatest asset. Its value is more than credit card records (credit cards can be cancelled if lost, IP can’t). It is equivalent to a state secret for your firm. The logical solution...
  • Blog Post: PTC Windchill Microsoft SQL Server vs. The Competition

    As documented in the Microsoft SQL Server: Improved Performance for PTC Windchill whitepaper benchmark testing results showed that some Pro/ENGINEER and Windchill 9.1 operations performed up to 88 percent faster on SQL Server 2005 than on a competitor’s database, with an average performance advantage...
  • 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: PTC: Groupe Bénéteau set sails with Windchill running on SQL Server 2008's engine

    Groupe Bénéteau (GB) is the world's leading manufacturer of sailboats and one of Europe's top manufacturers of powerboats. GB also engages in low-environmental impact sustainable housing. Windchill will be used initially for the design and manufacture of both sailboats and powerboats. GB...
  • Blog Post: Backing Up All SQL Server Databases Using PowerShell

    One of the many great features in Microsoft SQL Server is the ability to perform a particular task numerous ways. While watching Technet Webcast: Deploying PTC Windchill Using Microsoft SQL Server the speaker at approximately 31 minutes in discusses a bunch of different ways to backup a Microsoft SQL...
  • 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: Penske Racing Winning with SQL and PTC

    Penske Racing details the improvements in performance, gains in efficiencies, and reduction in complexity they are seeing from implementing a PTC Windchill on Microsoft SQL Server solution. “At Penske Racing, we understand the importance of speed and performance...
  • Blog Post: Best Practices Analyzer Exceptions expected for PTC’s Windchill

    If you run the SQL Server 2005/2008R2 Best Practices Analyzer (see my prior post) on a PTC Windchill installation, the BPA report might show the exception shown below. Do not correct it – this is by design and you should click [Exclude this Result]. For any other exception, correct it...
  • Blog Post: PTC: Windchill 10.0 Support for Microsoft Platforms

    I have listed below which Microsoft technologies are supported by PTC Windchill with the release of 10.0. There is a virtual event describing its feature on May 10th, 2011, you may register here . Architecture Tier Product Operating System ...
  • 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: TechNet Webcast: Deploying PTC Windchill Using Microsoft SQL Server

    In a competitive manufacturing environment, it can be difficult to gain an edge on competitors by delivering products that go to market faster while also addressing other business concerns such as minimizing costs, adhering to regulations, and maintaining a global supply chain. PTC Windchill is an industry...
  • Blog Post: Protecting Intellectual Property with PLM Products

    Author: This article is written by our contributing author Ken Lassesen. His bio can be found here . [Next Post in Series] Your firm critical Intellectual Property (IP) is often stored in products such as Enovia or Windchill. Intellectual property includes designs and specification of current...