Similar the post earlier today, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month. This was is titled Leveraging Cloud for the Modern SQL Developer. In the session, I discussed how and where SQL developers can look to Microsoft Azure to help in development on data platforms.
The abstract for the sessions is:
In the past, developing a database was a simple affair where you built and deployed the database for a server down the hall in your data center, or in some cases to a server under someone’s desk. While those good ole days were a much more simple time, they were quite limiting in how a database could be deployed and there were much fewer options for ensuring stability and performance. Today, SQL Developers have many more options for deployment including the services provided through Windows Azure. In this session, we’ll dive into what you need to know to start developing databases with Windows Azure and discuss the value that cloud delivery can provide to your database development.
Webcast Recording & Materials
If you missed the webcast, you’ll can watch the recording here. For those that want to download the slide deck, you can click the following link – .
Also, if you just want to flip through the slide deck again, here you go.
Q: Can you also create that BACPAC from within Visual Studio?
Yes, provided I am understanding the questions correctly. You can use SQL Server Data Tools, within VS, to create BACPACs.
Q: If you want to learn SQL Azure, how does the pricing work? I was a little confused with how charges are incurred, I assume that it’s not by each query you execute, etc..
For SQL Database, pricing is based on the size of the database and the network throughput that is incurred. The compute per query isn’t calculated, just the throughput of data after. You can find more information here – http://azure.microsoft.com/en-us/pricing/details/sql-database
As far as getting started goes, if you have an MSDN account, you can actually get lower that then published rates.
Q: How do you troubleshoot problems on the azure db, like querying the DMVs and Extended events, where do you save the file or what other option is there?
Tracing similar to on-premise databases is not available yet. There are DMVs though that can provide a lot of what is needed.
Q: I have SQL Server 2012 on my machine, when i Create a project in Data Tool I am just seeing SQL Server 2005 & SQL Server 2008 under Project Version
You have to download SQL Server Data Tools seperately from the Visual Studio and SQL Server installs. The tools can be found here – http://msdn.microsoft.com/en-us/data/tools.aspx
Q: Wouldn’t you have to migrate from Cloud 2012 to Cloud 2014 to XXX?
No, changes are introduced across the SQL Database SaaS platform on a regular basis. The idea is that as you own and use the service, it is continuously improving.
Q: Have you compared MS vs Google vs Amazon?
Not with enough experience that I can talk too deep on this area.
Thanks for Attending
Thanks to those that attended the webcast. If you have any questions on the webcast or suggestions for improvements, please leave a comment on this post.