Browse by Tags

Product lifecycle management (PLM) is an enterprise, business, and information strategy that helps companies develop and deliver world-class products quickly and efficiently. Teamcenter from Siemens PLM Software is the most widely used PLM system in the world, powering innovation and improving productivity...

In November 2011, Siemens PLM Software, Microsoft, and Intel conducted performance and scalability testing on Teamcenter 8.3 with Microsoft SQL Server 2012 running on servers based on Intel Xeon processors. The benchmark testing was very successful, confirming that Teamcenter can successfully scale to...

Successful automobile design today requires electronics and software design expertise in addition to traditional mechanics. Automotive engineers and product developers must be able to simultaneously design the various elements of mechatronic products to ensure that mechanical, electrical, systems, and...

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...

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...

Chris Kelley interviewed Lonnye Bower at PLM Connections held in Las Vegas, May 2nd-5th 2011. The video is on his Siemens PLM Software blog . Lonnye, an IT Pro Evangelist at Microsoft, works with Siemens Teamcenter. She described the latest developments from Teamcenter’s and Microsoft’s...

In prior posts , I have described the benefit of Read-Committed Snapshot Isolation (RCSI). RCSI will usually benefit most ISV databases . Another method may benefit many ISV databases (running on SQL Server 2008 and later): compression . Compression is often ignored because of user experiences with the...

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...

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...

[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...

[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...

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...

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. ...

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...

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...

[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...

[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...

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...

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...

[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...

[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...

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...

[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...

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...

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...