Applications & Services

SQL Server Performance Tuning: Best Practices

No comments

Getting tired of slow queries? Wondering how you can improve SQL performance? The answer lies in SQL performance tuning or SQL server audit. Developers and database administrators (DBA) can significantly improve SQL server performance by fine-tuning how it carries out the queries. Optimal performance is crucial for relational databases and the applications that use them.

Olga BurnaevaSQL Server Performance Tuning: Best Practices
read more

Enterprises reprioritizing automated database monitoring due to the effects of remote work and global lockdown

No comments

According to Redgate’s third annual State of Database Monitoring Report enterprises are reprioritizing cloud adoption and automated database monitoring due to the effects of Covid-19 and the global lockdown. The focus of business moves not only to ensuring application performance, but also security for remote working and ensuring business continuity.

 

The two biggest causes of problems with database management are human errors and ad hoc user access

Usually, the most common priorities for database professionals are performance and backups. In third and fourth places, people point out security management and user permissions. According to the respondents in the same research, the two biggest causes of problems with database management are human errors and ad hoc user access, which comes as a result of increased remote working and tasks being more widely distributed. Automated database monitoring seems to be the right solution to all these problems. 

vmetricBlogEnterprises reprioritizing automated database monitoring due to the effects of remote work and global lockdown
read more