Mike Wood - Azure Elastic Database Jobs: Dealing with Database Sprawl in Azure
Details
"Move your database to the cloud they said! Shard your databases for scale they said! Now how do I deal with all these databases when it's time to update them? How can I run queries again each of them? And where's my SQL Agent?!"
These statements aren't uncommon when databases are moved to the cloud. Come hear about how Azure Elastic Database Jobs can help alleviate some of the pains of managing and updating multiple databases in Azure SQL DB deployments. Don't let the name fool you: you don't need to be using Elastic Database Pools to use this tool. You can use this tool to roll out schema changes across databases, execute TSQL across them or even use it as a SQL Agent replacement. Best of all, learn about how this tool is hosted as a service from Microsoft and see how you can start using it now!