We are planning to migrate a SQL 2008 R2 server to SQL 2014 server. How do we estimate memory requirements for new SQL 2014? What are the specifics which need be considered to estimate the future memory usage? Is there any guidelines available to estimate future usage from existing server usage?
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
Sometimes drives fill up and we don't know why. If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left! Here's how you can find out...
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed