SQL
There are a number of Tools that can be used to determine if SQL is set up correctly as described in the SOLIDWORKS PDM / Manage Installation guide. The first two tools are located in the SQL Server Install Center and are located under Tools:…
SOLIDWORKS PDM provides a secure environment for users to store files, and safely keeps archived copies of these files on a central server, preventing most potential causes of data loss on local user’s computers. However, it is essential that copies of the PDM Archives and…
Starting with the 2017 release of SOLIDWORKS PDM Professional, administrators can now take advantage of the “AlwaysOn Availability Groups” or AOAG in Microsoft SQL Enterprise edition. This will allow for replication of the vault database to multiple locations. Previously, replication in PDM was available for Archives…
While helping a customer to resolve SOLIDWORKS EPDM performance issues, I came across an SQL query in the SOLIDWORKS Knowledge Base, which can help determine if Rebuild, Reorder, or Shrink SQL maintenance tasks can be used to improve SOLIDWORKS EPDM Vault Performance. I found this utility…
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…
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…