SQL Server DBA Support
eGolem SQL server teams have extensive knowledge in all aspects of Installation & configuration, Monitoring, Replication, Tuning, Upgrading, Auditing, reporting, cloud and High availability solutions. We support On-Prem SQL server database, Private cloud & Microsoft Azure based environment. Our team equipped in Database migration from OnPrem to Microsoft Azure and setting all database aspects from Azure prospective.
Installation, Configuration Of sql Server:
- SQL Server on Windows
- SQL Server on Linux.
- SQL Server patching
Automated SQL Server Backup:
- Full backups
- Differential backup
- Transactional log backup.
- Configuring Recovery models
- Setting up the retention policy for older backups.
Query/Server Optimization:
- Creation of clustered and non-clustered indexes
- Index Defragmentation.
- Rebuild and reorganize indexes.
- Managing and updating Statistics.
- TempDB Configuration and growth control
- Database file configurations
- Log files usage and growth analysis
High Availability and Disaster Recovery: We access the client environment and may propose below high availability solutions based on their business requirement.
- Replication: - The source data will be copied to destination through replication agents (jobs). Object level technology.
- Log Shipping: The source data will be copied to destination through Transaction Log backup jobs. Database level technology.
- Mirroring: - The primary data will be copied to secondary through network transaction basis with the help of mirroring endpoint and port number. Database level technology.
- Clustering: - The data will be stored in shared location which is used by both primary and secondary servers based on availability of the server. Instance level technology.
- Always ON Availability Groups: - The primary data will be copied to secondary through network transaction basis. Group of database level technology. Windows Clustering setup is required without shared storage.