DBA Tasks ( SQL Server 2008 ) - Recommendation - Maintenance plan
It's a good pick to use it? If I was hired on a new company, it's a good pick to use maintenance plan ( for me, looks like too "simple", don't want to look a bad DBA).


Maintenance plans are not bad, but when your environment grows, the limited flexiblity and functionality that maintenance plans provide wont be sufficient.

For e.g Maintenance plans suffer from below drawbacks :


There is no CHECKSUM option when taking backup of databases or there is no option of verifying backups using CHECKSUM.
There is not much logic you can implement when dealing with index fragmentation and once you configure it, they run regardless if you really need a reorg or rebuild on your indexes... and many more :-)


I highly recommend to use Ola's backup solution (and Index maintenance  solution as well).