You can go for custom sharding as they provide better scalability and performance, also there is an option for self-sharding. Or, you can rewrite your application to PostgreSQL and try it with Amazon RDS.
I hope this will help.
Want to become an Azure expert?