SDCOScripts for SQL Server 3.00

SDCOScripts for SQL Server is a curated set of T-SQL scripts and deployment utilities from Carl Zeiss Industrielle Messtechnik GmbH. It standardizes how ZEISS industrial metrology applications are installed, upgraded, and maintained on Microsoft SQL Server. The toolkit automates database provisioning, schema updates, security hardening, performance tuning, and routine maintenance, helping teams deploy reliably and operate at scale.

Key capabilities:

• Repeatable database setup and version-controlled schema changes
• Idempotent scripts with built-in safeguards and validation checks
• Index and statistics management, partitioning options, and performance baselines
• Data retention, archiving, and cleanup policies for large measurement datasets
• Role-based security templates aligned with least-privilege principles
• Scheduled jobs for backups, integrity checks, and health reporting
• Support for CI/CD workflows and environment configuration

Benefits:

• Faster deployments and reduced operational risk
• Consistent environments across development, test, and production
• Improved performance, reliability, and auditability

Intended audience:

• Database administrators, DevOps engineers, and application owners responsible for ZEISS metrology databases in Microsoft SQL Server environments

Support and licensing are provided by Carl Zeiss Industrielle Messtechnik GmbH.

SDCOScripts for SQL Server is developed by Carl Zeiss Industrielle Messtechnik GmbH. The most popular version of this product among our users is 3.0.