SQL DBA Scripts for Performance Validation
Budget: $10 – $30 USD
I am in need of strategic SQL DBA scripts to ensure comprehensive performance validation. These scripts should be focused on three principal tasks:
1. Query Optimization: Fine-tuning scripts for a small, simple database. This will enhance efficiency and conserve system resources.
2. Index Management: Manage indexes to improve SQL Server query performance. Capable of dexterous index manipulation specifically with Microsoft SQL Server.
3. Database Backup and Restore: Robust scripts to backup and securely restore our database to safeguard our precious data.
Additionally, I am also interested in scripts that can help with end to end server related queries. Ideally, the freelancer for this project should possess in-depth knowledge of Microsoft SQL Server, query optimization techniques, secure backup and restoration practices, and efficient index management. Being proficient in managing small and relatively simple databases would be crucial for this assignment.
1. Query Optimization: Fine-tuning scripts for a small, simple database. This will enhance efficiency and conserve system resources.
2. Index Management: Manage indexes to improve SQL Server query performance. Capable of dexterous index manipulation specifically with Microsoft SQL Server.
3. Database Backup and Restore: Robust scripts to backup and securely restore our database to safeguard our precious data.
Additionally, I am also interested in scripts that can help with end to end server related queries. Ideally, the freelancer for this project should possess in-depth knowledge of Microsoft SQL Server, query optimization techniques, secure backup and restoration practices, and efficient index management. Being proficient in managing small and relatively simple databases would be crucial for this assignment.