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 plans to move all departments to Windchill. “Prior to this decision, our NBC…

0

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 did not scale. Oracle scaled, but was…

0

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 Client Platform IE 7IE 8Office 2003Office 2007Project 2007Outlook 2007 Windows XP Professional (32 +64 bit) Windows 7 (32 +64 bit)…

0

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-improving indexes. This in-depth process takes some…

2

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 series of posts, I will give visual step-by-step instructions on…

0

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 or document the reason for the…

0

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 is not to try…

0

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 its free Best Practices…

0

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 character codes (EBCDIC…

0