Geeks With Blogs
James Rogers BI from the trenches...

 

I am currently sitting in a seminar on BI in the Cloud by John Welch at the PASS Summit 2009.  SQL Server Azure looks promising for a variety of applications.  Currently it only supports SQL Server relational database services but future plans to include the BI stack of SQL Server. 
           I have yet to see how loading of data is handled and security is handled but it seems to have a lot of potential for small data sets (< 10 GB). 
 
Couple of points:
  1. Apparently data manipulation is slower than normal SQL Server. 
  2. Queries are limited to 5 minutes
  3. Max database size is 10GB
  4. Bulk Insert not available yet but available in an upcoming CTP
  5. No control over physical database implementation (files,filegroups,partitions, etc…)
  6. No Windows auth supported
Posted on Wednesday, November 4, 2009 12:49 PM SQLServer | Back to top


Comments on this post: SQL Azure shows promise for small data applications - not there for BI yet.

No comments posted yet.
Your comment:
 (will show your gravatar)
 


Copyright © James Rogers | Powered by: GeeksWithBlogs.net | Join free