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: Siemens PLM’s UniCam FX now running on SQL Server

    I’ve been catching up on press releases for Siemens and noticed this one from January, 2011. Siemens is responding to customer demands for lower TCO for their offerings by adding SQL Server as a database option. “UniCam FX now supports Microsoft SQL Server® software and SAP® Crystal...
  • Blog Post: Siemens' PLM: Thomas Instrument runs on SQL Server

    Thomas Instrument provides engineering, manufacturing, repair, and overhaul services to the United States Department of Defense (DoD). The company is used by the DoD to produce and/or support orphan parts, components, and systems. Orphans are items that are no longer produced and/or supported by the...
  • Blog Post: Siemen's PLM: SPÄNEX runs on SQL Server

    SPÄNEX based in Uslar, Germany, design and provide chip-extraction, dust-extraction and filtering plants around the world. They are a small company with only 60 employees with minimial information technology support. After two years of consideration, they selected SQL Server based Solid Edge Insight...
  • Blog Post: SIEMENS: Teamcenter reduces storage requirements by 50% on SQL Server

    Siemens is a leading provider of enterprise manufacturing execution and quality systems. Teamcenter 2007 is a suite of lifecycle management solutions improving productivity by connecting people with the product and process knowledge. There are over 4 million licensed seats of Teamcenter worldwide. ...
  • 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: Selecting the Right Database Platform for Siemens PLM Teamcenter

    Today’s manufacturing companies depend on product lifecycle management (PLM) software solutions such as Teamcenter® to help globally distributed teams bring better products to market faster and at less cost. Microsoft SQL Server is a secure, reliable and scalable platform for business-critical...
  • 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: Siemens: Migration Experiences at Boeing

    For those of you attending Siemens PLM Connection in Las Vegas, Nevada (May 2nd-5th, 2011), you may wish to grab Keith Gartenlaub's presentation on May 4th. Boeing made a strategic decision to cut costs by migrating applications from Unix/Oracle to Windows Server/SQL Server. One of those applications...
  • 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: Siemens PLM running on SQL Server saves costs across the board

    Recently I was reading the PLM World e-Newsletter and saw this nice table reflecting the Total Cost of Ownership (TCO). TCO Category Microsoft SQL Server 2008 Benefit over Oracle Database 11 g IT Labor 24 percent lower IT labor costs Software...
  • Blog Post: Migration Guide - Oracle to SQL Server (Siemens Teamcenter)

    In recent posts we've discussed some of the comparisons between the Microsoft SQL Server platform and it's competitors. We've discussed (in Why Pay More For Less ) the difference in cost of Microsoft SQL Server versus it's competitors and (in Buying a Vehicle vs. Buying a Database Platform ) the differences...
  • Blog Post: Siemens PLM: Improving Workplace Environments with Kinect and Jack

    Siemens PLM Software is working on innovative ways to bring the natural user interfaces (NUI) capabilities of Microsoft Kinect to Jack , their human simulation solution that helps manufacturers design safe, efficient, and comfortable workplace environments. This video shows how Jack can use the full...
  • Blog Post: Siemens PLM: Lincoln Electric runs on SQL Server

    Lincoln Electric, founded in 1895, is a world leader in the design, development, and manufacture of arc welding products, robotic arc-welding systems, plasma, oxyfuel cutting equipment and brazing and soldering alloys market. Lincoln Electric has a work force of approximately 9,000 with a presence in...
  • Blog Post: Why You Should Upgrade Siemens Teamcenter to SQL Server 2008?

    We've seen in previous blog posts how SQL Server stacks up against the competition when it comes to features, price, and performance but how does SQL Server stack up against itself? Siemens engineers visited the Microsoft Engineering Excellence Center Laboratory in Redmond, Washington to conduct...
  • 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: Siemens Teamcenter Running on SQL Server and Windows Server Successfully Supports 5K Concurrent Users

    As part of their strategic alliance, Siemens and Microsoft, in partnership with HP and Intel, ran benchmarking tests to evaluate the performance and scalability of current versions of Teamcenter, Microsoft SQL Server, and Windows Server. These tests were completed in March 2011 in the HP labs in Houston...
  • 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: Instant File Initialization - Oh you didn't know?

    One feature that (in my opinion) hasn't gotten the attention that it deserves is Instant File Initialization. As documented in the Siemens Teamcenter and SQL Server Best Practices whitepaper is it recommended to have this options enabled but you might be asking yourself what this is and why you should...
  • Blog Post: Choosing the Right Edition of SQL Server for Siemens Teamcenter

    Teamcenter 8.1 can run on either the Standard or Enterprise Edition of SQL Server 2005 or 2008. Regardless of version and edition, you should always run on the latest SQL Server service pack, which you can find in the Downloads section of the SQL Server Developer Center . For most functional aspects...
  • Blog Post: Backing Up Your Siemens Teamcenter Databases

    Ask any DBA what the single most important part of their job is and their answer should always be backup/recovery. The DBA plays a critical role in being able to recover the databases (and overall availability) from a failed state. Backups can be a tricky thing to define as there can be external pieces...
  • Blog Post: Volvo Aero uses Siemens PLM and made the switch from Oracle to SQL Server

    Volvo Aero, a subsidiary of AB Volvo, develops and manufactures high-technology components for aircraft, rocket, and gas turbine engines. The company partners with original equipment manufacturers such as General Electric, Pratt & Whitney, and Rolls-Royce to serve both private and military customers...
  • 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: Siemens PLM running on SQL Server is less work for one man support staff

    Recently I was reading the PLM World e-Newsletter article entitled “ A One-Man Show: Maintenance Tips from a Solo CAxPLM Administrator ” by Larry Carpenter (P.E.) I have encountered this situation often in talking with PLM support staff: the typical PLM support person is a P.E. (Professional...