TechNet Blogs

Resources

Benchmarks
Dassault Systèmes ENOVIA V6 on SQL Server 2008 Benchmark: This datasheet covers the benchmark highlights which confirm the scalability of Dassault Systèmes ENOVIA V6 on SQL Server 2008.
Whitepapers
Dassault Enovia and SQL Server Best Practices: This white paper provides best practices for setting up a Microsoft SQL Server 2008 database platform for ENOVIA V6.
Webcasts
Deploying Dassault Systèmes ENOVIA Using SQL Server 2008 : In this session, experts explain why SQL Server 2008 is the best choice for ENOVIA deployments, and cover some of the more important technical considerations for deploying ENOVIA using a Microsoft software stack.

Dassault Systemes Enovia - related blog posts

| |

Enterprise Applications on Microsoft SQL Server

Scalability and Performance of Dassault Systèmes ENOVIA V6 Running on SQL Server 2008 R2: Impressive Benchmark Testing Results

Posted over 1 year ago

by Tali Smith
- 0 Comments
Enterprises have come to rely on increasingly robust product lifecycle management (PLM) systems to streamline their business processes and to keep costs down. PLM systems, in turn, rely on high-performance databases. Dassault Systèmes ENOVIA V6...
Enterprise Applications on Microsoft SQL Server

Dassault: Tesla Motors builds for an electric future on SQL Server

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Electric car manufacturer Tesla Motors is upgrading to Dassault Systèmes’ V6 PLM solution running on SQL Server. Tesla has not only been pushing the cutting edge of electric car design, it has for the last four years piloted numerous Dassault...
Enterprise Applications on Microsoft SQL Server

Dassault: TÜV Rheinland resolving the conflict between the environment and technology

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
TÜV Rheinland Group (TÜV) is the world's leader in comprehensive, global independent product testing and assessment of environmental impact. TÜV has selected ENOVIA V6 PLM solutions running on SQL Server to launch an integrated compliance...
Enterprise Applications on Microsoft SQL Server

Migration: Pentair experience migrating to Enovia V6R2009x on SQL Server from Oracle

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Pentair has more than 13,000 employees in more than 20 countires produce a wide variety of products. More than 1500 employees regularly used their PLM systems which was running on Oracle. Pentair is typical of many businesses: if a system is working,...
Enterprise Applications on Microsoft SQL Server

Tuning Enovia Smarteam – End Solution

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Prior Post in Series] The result of the tuning exercise is TSQL shown below. The items included are those suggested by Database Engine Tuning Advisor (DTA) evaluated as being prime candidates by the author. The performance improvement expected is...
Enterprise Applications on Microsoft SQL Server

Tuning Enovia SmarTeam -- Statistics

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Prior Post in Series] [Next Post in Series] Adding statistics helps SQL Server to determine which tables to scan first when there are joins. To understand statistics better, see Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 ...
Enterprise Applications on Microsoft SQL Server

Migration: The value gained moving from Oracle to SQL Server 2008R2

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[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...
Enterprise Applications on Microsoft SQL Server

Migration: The value gained moving from DB2 to SQL Server 2008R2

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[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...
Enterprise Applications on Microsoft SQL Server

Tuning Enovia SmarTeam - Indexes - Conclusion

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Prior Post in Series] [Next Post in Series] In this part, I will deal with the fact that many remaining tables do not have clustered indexes on them. In my humble opinion, ANY reasonable order of the disk will perform better than a random order, so...
Enterprise Applications on Microsoft SQL Server

Tuning Enovia SmarTeam – Indexes – Part 2

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Prior Post in Series] [Next Post in Series] In this post I continue on with index analysis from my prior post. First, I will intentionally walk you into a dead end to illustrate when things go wrong and what you should do. Second I will take the right...
Enterprise Applications on Microsoft SQL Server

Tuning Enovia SmarTeam – Indexes – Part 1

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Prior Post in Series] [Next Post in Series] Adding indexes helps SQL Server retrieve records in a table faster. There is a special type of index called ‘clustered’; a clustered index determines the physical order of the records on the...
Enterprise Applications on Microsoft SQL Server

Dassault: Taylor-Deal Aviation picked SQL Server for SolidWorks DB

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Taylor-Deal Aviation (TDA), LLC, is an aviation consultancy providing engineering services for corporate jet, state-of-the-art VIP aircraft and military modifications. The company was founded in 2004 and has grown to over 30 engineers specializing in...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes

Posted over 2 years ago

by Ken Lassesen
- 3 Comments
[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...
Enterprise Applications on Microsoft SQL Server

Tuning Enovia Smarteam at Langen Packaging Group – Summary

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Prior Post in Series] [Next Post in Series] Recently I had an opportunity to do an example tuning on an Enovia SmarTeam installation. Marc Young at xML Solutions arranged for me to work with the folks at Langen Packaging Group in Mississauga, Ontario...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

Posted over 2 years ago

by Ken Lassesen
- 1 Comments
[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...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Creating a Workload by Using a Trace Log

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[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...
Enterprise Applications on Microsoft SQL Server

Dassault Systèmes acquires SQL Server based Intercim

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Intercim provides software based on Microsoft SQL Server for real-time Manufacturing Operations Management (MOM) and Predictive Analytics for Discovery, Design, Manufacturing and Operations. This complimented Dassault Systèmes offerings by allowing...
Enterprise Applications on Microsoft SQL Server

Best Practices Analyzer Exceptions expected for Dassault Systèmes ENOVIA

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
If you run the SQL Server 2005/2008R2 Best Practices Analyzer (see my prior post) on a for Dassault Systèmes ENOVIA or SmarTeam, the BPA report might show the exception shown below. Do not correct it – this is by design and you should...
Enterprise Applications on Microsoft SQL Server

SQL Server Security – Additional Resources

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[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...
Enterprise Applications on Microsoft SQL Server

Best Practices Analyzer for ISV SQL Servers to protect your company’s property

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
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...
Enterprise Applications on Microsoft SQL Server

Migrating from Oracle to SQL Server

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[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...
Enterprise Applications on Microsoft SQL Server

Right sizing ISV installations for the best bang for the buck!

Posted over 2 years ago

by SQL Server ISV
- 0 Comments
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...
Enterprise Applications on Microsoft SQL Server

Protecting Intellectual Property with PLM Products

Posted over 2 years ago

by SQL Server ISV
- 0 Comments
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...
Enterprise Applications on Microsoft SQL Server

Best Practices for Running Dassault Systèmes ENOVIA on SQL Server 2008

Posted over 2 years ago

by SQL Server ISV
- 0 Comments
Enterprises have come to rely on increasingly robust product lifecycle management (PLM) systems to streamline their businesses and keep costs down. PLM systems, in turn, rely on high-performance databases. When the database system underlying the PLM software...
Enterprise Applications on Microsoft SQL Server

Use CPU Instance Counters for Better Insight

Posted over 3 years ago

by SQL Server ISV
- 0 Comments
Windows Performance Monitor, a management tool included with Windows, is a key tool for understanding the performance characteristics of your database server. Performance Monitor lets you observe a wealth of metrics about the activity of the operating...