You’ve just spent 2 weeks optimising a database for a new application, ensuring all the items on SQL Server Install Checklist are met. There’s a plan in place to scale for growth , a maintenance plan and an agreement to commit a health check once a month. Everything is looking good. Then the owner requests if they add a new database , for a new third party application. As it’s there server – and are paying for it – they want to make it as cost effective as possible. As a DBA you have a responsibility to complete some capacity... Read more →