“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 going to be a hosted service from Microsoft and see how you can get in on the preview!
Mike Wood is a Product Manager for SentryOne where he works on cloud related products and services. He describes himself as a problem solving, outdoorsy, user group founding, dog-loving, blog writing, solution creating, event planning, married, technology speaking, father of one kind of guy. When he’s not living up to that title he’s an avid reader, (horrible) violinist and gamer. Michael is one of the Founding Directors of the Cincinnati .NET User Group as well as the founder of the Cincinnati Software Architecture Special Interest Group. He is also a Microsoft MVP in Windows Azure. You can catch up with Mike on his blog at http://mvwood.com/blog and on twitter under the handle @mikewo.