Microsoft SQL

Checking for Index Fragmentation in SOLIDWORKS EPDM

This article was originally intended to introduce the Reorder and Reorganize tasks in SQL. These tasks will be discussed in other articles, but while researching for this article my mindset on the aforementioned tasks, has shifted somewhat. First let’s look at how to check for fragmentation. Check…

Read More...

SOLIDWORKS EPDM SQL Maintenance Task Shrink Database

The Shrink Database task reduces the size of SQL Server database data and log files. This task can cause index fragmentation and is not recommended by SOLIDWORKS. SOLIDWORKS does note that “on large databases or environments with hundreds of users, shrinking the SOLIDWORKS® Enterprise PDM…

Read More...

SOLIDWORKS Electrical Cannot Connect to Database?!

One of the most commonly seen errors when trying to launch SOLIDWORKS Electrical is the “cannot connect to database” error.  If you have ever run into the error message below, this article will give a how-to guide for quickly and easily resolving the issue. This error message…

Read More...

Backing Up PDM Databases Automatically with SQL Server Agent

Proper backups are an essential part of data management.  For SOLIDWORKS PDM, there are two key elements that must be backed up to ensure that data is safe, the vault archives, and the vault database. The vault archives are copies of the actual files stored…

Read More...

SOLIDWORKS Electrical IT Architecture

What constitutes a great installation, migration, or upgrade with SOLIDWORKS Electrical and the SOLIDWORKS Solutions? An informed audience of Users, IT Administrators, and Management, in conjunction with your friendly neighborhood SOLIDWORKS Product Gurus. Keeping all the experts in mind, I’ve shared my experience with the SOLIDWORKS Electrical IT…

Read More...