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: TechNet Webcast: Deploying Dassault Systèmes ENOVIA Using SQL Server 2008

    Dassault Systèmes ENOVIA delivers a proven service-oriented architecture to help manage a product's life cycle for any size company, whether a small business or a large enterprise. ENOVIA v6 is Dassault's most powerful version to date, and using Microsoft SQL Server 2008 as the database for Enovia...
  • Blog Post: Migration: Pentair experience migrating to Enovia V6R2009x on SQL Server from Oracle

    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, don't upgrade it! Time marches on, they found that...
  • Blog Post: What SQL Server Services Are Necessary for Dassault Enovia?

    If you are having performance issues with your SQL Server system, the last thing you need is to have unnecessary services running, consuming resources that you need for productive work. A common issue I've found when I work on sites that are using SQL Server with Enovia is that unnecessary SQL Server...
  • 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: Meet Microsoft at Dassault Systemes Customer Conference: Nov. 9–11th, Orlando, FL

    Are you a DS Customer attending the upcoming Customer Conference in Orlando next week? There are a couple of opportunities to meet with Microsoft (Premium Sponsor at the Conference). Microsoft has a keynote session on Tuesday delivered by Caglayan Arkan, General Manager of the Manufacturing and Resources...
  • Blog Post: Tuning Enovia Smarteam – End Solution

    [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 at least 15% and may be considerably more. A trace...
  • 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: Tuning Enovia SmarTeam – Indexes – Part 1

    [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 disk. For the most common reads, you want the records...
  • Blog Post: Using Read-Committed Snapshot Isolation - Mini-Lab

    Dassault ENOVIA requires the use of read-committed snapshot isolation. By using the read-committed snapshot isolation level introduced in Microsoft SQL Server 2005, you can reduce blocking and deadlocking issues caused by lock contention. Every time a row is modified by a specific transaction, the instance...
  • Blog Post: Tuning Enovia SmarTeam - Indexes - Conclusion

    [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 putting a clustered index on every table is a must...
  • Blog Post: Best Practices Analyzer Exceptions expected for Dassault Systèmes ENOVIA

    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 click [Exclude this Result]. For any other exception...
  • 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: Dassault Systèmes acquires SQL Server based Intercim

    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 intregration of real-world information captured...
  • Blog Post: Tuning Enovia Smarteam at Langen Packaging Group – Summary

    [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. Mirek Tokarz facilitated the access: dealing...
  • 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: Scalability - Dassault Systèmes ENOVIA V6 on SQL Server 2008 Benchmarking Datasheet

    SQL Server 2008 provides built-in enterprise-class scalability—there is no need to purchase costly add-ons. With SQL Server 2008, you can utilize: Resource Governor to manage SQL Server workload and system resource consumption. WIth Resource Governor you can specify limits on resources (CPU...
  • 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: Tuning Enovia SmarTeam – Indexes – Part 2

    [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 path and show the results. I took the wrong...
  • Blog Post: Seperate Servers for Dassault Systèmes ENOVIA V6

    Here is an easy-to-implement suggestion to optimize your setup right out of the gate: SQL Server runs best on a computer by itself, with ENOVIA V6 running on a separate physical computer. Why separate servers? The short answer—because it will make your life easier. The long answer—for...
  • Blog Post: Best Practices for Running Dassault Systèmes ENOVIA on SQL Server 2008

    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 is unreliable or slow, the PLM software cannot...
  • Blog Post: Dassault: TÜV Rheinland resolving the conflict between the environment and technology

    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 portal for customers. What is a compliance portal...
  • Blog Post: Apparel Manufacturer Mammut Sports AG adopts ENOVIA V6 on SQL Server

      Mammut is a Swiss company that has specialized in mountain sports for 150+ years.  They recently announced the selection of ENOVIA V6 on SQL Server 2008 to manage the development processes from initial product design to sourcing, manufacturing and sales.  The Apparel and Footwear vertical...