Guest Article: Storing CAD Databases in the Cloud

Author: Deelip Menezes The following article is authored by PLM industry analyst and CAD expert Deelip Menezes. His complete bio can be found here.    For some time now, Computer-Aided Design (CAD) systems have been storing project data in individual files. But recent developments in product lifecycle management platforms, such as Dassault Systemes CATIA V6,…

9

Mini-Lab – Part 2 – Backup Compression with Resource Governor

[Prior Post in Series] In Part 1 of this 2 part Mini-Lab series we looked at a new feature that was introduced in SQL Server 2008 called Backup Compression.  We were able compress the backups of our test database ( 2008FeaturesDB ) to roughly 10% of the size of the uncompressed full backup while also…

5

Kronos WFC 6.2 Support for Microsoft Platforms

It was great to meet customers at Kronosworks last week in Las Vegas. Microsoft had two packed sessions – one in the Retail and the other in the Healthcare track. At our booth we met lots of customers who were excited about the 6.2 release and support for Microsoft Hyper-v, SQL Server 2008 and Windows…

4

PTC Windchill Microsoft SQL Server vs. The Competition

As documented in the Microsoft SQL Server: Improved Performance for PTC Windchill whitepaper benchmark testing results showed that some Pro/ENGINEER and Windchill 9.1 operations performed up to 88 percent faster on SQL Server 2005 than on a competitor’s database, with an average performance advantage of approximately 10 percent. Test Performed Time SQL Server 2005 Performance…

3

Kronos: Oracle to SQL Server Migration – Performance – Part 2

Author: This article is written by our contributing author Ken Lassesen. His bio can be found here [Prior Post in Series]    [Next Post in Series] This is part of the post-arc started by this overview of Migrating from Oracle to SQL Server, and deals with experiences with Kronos migrations. Javed Iqbal, a Kronos Migration specialist…

3

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

Great SQL Server Whitepapers – all in one location

SIlvano Coriani has done a great job compiling the most relevant SQL Server whitepapers available on SQL CAT and Technet sites.  These papers are categorized into the major categories of Performance and Tuning, High Availability and DR, Security, Manageability, Migrations and Upgrade and Business Intelligence. The papers are a great resource for customers who want…

2

Telvent: When the lights go out, SQL Server is working to turn them back on!

Telvent’s Responder Outage Management Solution (OMS) reduces outage time for customers from power outages. Outages may result from adverse weather, aging power infrastructure, and energy constraints. Responder OMS significantly improves the dispatch and management of crews over prior systems. Responder OMS builds on the functionality of Microsoft SQL Server 2008 to provide the business intelligence platform for best of breed…

2

Testing Hot Fixes, Cumulative Updates and Service Packs

It is often a challenge to keep up with supporting your own applications, let alone changes to the underlying platforms, such as Microsoft SQL Server, that the application supports. In the face of these changing conditions, the only way to ensure that your application remains functional, reliable, and high-performing is through ongoing testing.  Let’s first…

2