SQLEspresso
Archives: September 2018
Cycle SQL Server Error Logs
I saw this again recently and see it too often in environments so wanted to take a second to remind everyone to cycle their error logs on a regular basis. SQL Server keeps error logs and when you reboot or restart SQL Server services the logs are cycled and a… Read more
3 comments, 1,954 reads
Posted in SQLEspresso on 26 September 2018
Careful with your SQL Server Max Memory settings
Quite often I see database administrators set SQL Server max server memory thinking everything related to SQL Server uses this shared memory pool. This is a mistake. There are many things that rely on memory that are not part of SQL Server. Best practices state that you should leave memory… Read more
4 comments, 382 reads
Posted in SQLEspresso on 19 September 2018
Back up Encryption
Nowadays security breaches happen way to frequently. As DBA’s we should all take extra care with sensitive data and ensure we are encrypting correctly. But some of us forget to take it a step farther and don’t encrypt our backups. For those working in an ultra data sensitive environment I… Read more
1 comments, 2,013 reads
Posted in SQLEspresso on 5 September 2018