SQL Server Performance Counter Data collection using TypePerf utility

  • February 7, 2018
  • 0 Comments

http://dbamantra.com/wp-content/uploads/2018/02/TypePerf-1.jpgSQL Server performance tuning and Optimizing SQL Server is part of the day to day job of a Database administrator. One of the key aspects of Performance tuning is to gather performance counters data on the Database server for CPU utilization, Memory and Disk usages along with SQL Server related Metrics. The benefit of performance […]

Top 5 Cloud Computing Certifications of 2018

  • February 6, 2018
  • 0 Comments

Usage of Data has led to companies plan, strategize and execute even more efficiently than before. With an increase in the trend of getting businesses online and moving towards economies of scale, the need of data has increased on the parallel trend.As there is an increase in need of data, it has been compensated with […]

How to Perform database restore with Database Encryption

Database encryption is the process of changing the information inside database into some ciphertext using encryption keys and appropriate algorithm. This process makes sure even if the hackers get through the firewall and bypass the security, they would require encryption keys to decrypt the information. Database encryption guarantees information security while embeddings or recovering information […]