Thanks

Aug 27, 2012 at 3:14 PM

OMG!! this is the greatest project yet on codeplex for me.

 

Thanks so much to all who developed this.

 

Doug

Coordinator
Aug 27, 2012 at 9:43 PM


Hi Doug,

 

Thank you very much for the wonderful feedback.  It made my day :-)

 

Thanks again,

George

Aug 28, 2012 at 12:43 PM

George,

It was my pleasure, I actually very rarely post thanks when I should, but your project was so incredibly helpful and works so smooth and bug free for my purposes, I couldn’t help but to let you know.

I don’t suppose I could ask a favor? I am trying to convert a vb.net (2010) app which currently uses in house ms sql server 2008, to use sql database in azure instead. And I have looked at the azure guides and sample gallery but there doesn’t seem to be much help for what all I need to change. From what I can gather I all my cross database queries will have to be separated and done apart, which is making me think of combining data into one database just to ease developing with azure.

Any tips/suggestions/links to help in my goals?

Thanks,

Doug

From: ghuey [email removed]
Sent: Monday, August 27, 2012 5:44 PM
To: doug_crowe@hotmail.com
Subject: Re: Thanks [sqlazuremw:393217]

From: ghuey



Hi Doug,

Thank you very much for the wonderful feedback. It made my day :-)

Thanks again,

George

Coordinator
Aug 28, 2012 at 4:29 PM


Hi Doug,

 

You are correct in that you can’t do cross database queries in SQL Database.  You have two basic options:

 

1)      Combine your databases into one database

2)      Leave your multiple databases as they are and move the business logic that requires cross joins and do the merge of data in the middle tier.

 

Option one is the easiest, but you need to make sure that you don’t exceed 150 GB in size.  Also something else that I look out for is the number of transactions that I am doing per database.  If both databases are I/O intensive and now you put them together in one database, then you could have a potential throttling issue due to high I/O.  What you need to remember here is that SQL Database is a shared resource (my database, your database, Bubba’s database …) could be on the same commodity processor under the same instance.  SQL Database has a throttling engine to make sure that nobody takes more than their fair share of resources.  Here are a couple great articles: http://social.technet.microsoft.com/wiki/contents/articles/1541.windows-azure-sql-database-connection-management-en-us.aspx and http://social.technet.microsoft.com/wiki/contents/articles/1695.inside-windows-azure-sql-database.aspx.

 

Of course, the problem with option two is that it will take code rewrite to query one database and then the other(s).  There is also a third option that I did not list above and that is to use SQL Database Federations (a.k.a shard your database).  This will also require some work like in option two except there, you could set up parallel threads to do parallel queries.  Here is a pretty good article on SQL Azure Federation: http://msdn.microsoft.com/en-us/magazine/hh848258.aspx and here is a video that covers pretty much the same thing: https://channel9.msdn.com/Shows/Cloud+Cover/Episode-69-SQL-Azure-Federations-with-George-Huey.

 

I hope this helps.  If you want, contact me offline and maybe we can setup a quick conference to better answer your questions.

 

Regards,

George