Since more than a decade you can see databases migrating to DBaaS. Being a DBA today doesn’t mean being an expert in configuring SQL Server or dealing with maintenance plans. Having performance tuning and troubleshooting skills is more valuable for you and your company. Yes, choosing the right CPU chip, the amount of memory or the disk subsystem is important. Adjusting the VM configuration to get the best performance also. But it’s less than 1% of your time, correct?
Let’s spend just 1 more minute to configure SQL Server to be confident over backups, integrity checks, index maintenance and some xEvents to help in performance issue diagnostic.