Jamie Thomson

Hi,

Just a few Qs about the hosted services:

  1. How will we know how big the database is i.e. How will we know when we're coming close to exceeding 100MB
  2. Will we have the capability to performance tune the underlying database At the very least I'd like to be able to create covering indexes.
  3. Will we be able to create stored procedures
  4. I'd love to have access to the underlying database via SQL Server Management Studio. If you could work on getting that to us I for one would be very pleased (and impressed).
  5. Will you allow us to have multiple services under 1 Live ID
  6. Is there any way to modify an existing conceptual schema or are we forced to email astoriaf@microsoft.com to get it removed and then create another

More to come I'm sure.

Thanks

Jamie




Re: ADO.NET Data Services (Pre-Release) Questions about hosted services

Pablo Castro - MSFT

Hi,

1. Err, you can't know right now. If you think you ran out of juice let us know Smile. We'll keep this in a list of requests...

2, 3, 4: one thing that may not be immediately obvious is that this thing is not a relational database just put online. What you get is an EDM model that's "somehow" persisted. While we currently use a regular SQL Server database and traditional database schemas, there are other options that provide better partitioning, better scalability, better management, etc. So there isn't much to expose below the EDM model that is not a considered "an implementation detail" that could change over time. The one thing that I think it's interesting is to have a way of indicating "important query patterns" from which we could derive proper indexing strategies for your subset of the data...we do not currently have the infrastructure to do that (again, this is an experimental service), but it's an interesting thought.

5. Not right now, but we could consider it if this is a serious issue

6. Not right now, but we'll add this soon

Thanks for your interest on this. If you have more ideas/suggestions please share them.

Pablo Castro

Technical Lead

Microsoft Corporation

http://blogs.msdn.com/pablo






Re: ADO.NET Data Services (Pre-Release) Questions about hosted services

Jamie Thomson

Pablo Castro - MSFT wrote:

Hi,

1. Err, you can't know right now. If you think you ran out of juice let us know . We'll keep this in a list of requests...

2, 3, 4: one thing that may not be immediately obvious is that this thing is not a relational database just put online. What you get is an EDM model that's "somehow" persisted. While we currently use a regular SQL Server database and traditional database schemas, there are other options that provide better partitioning, better scalability, better management, etc. So there isn't much to expose below the EDM model that is not a considered "an implementation detail" that could change over time. The one thing that I think it's interesting is to have a way of indicating "important query patterns" from which we could derive proper indexing strategies for your subset of the data...we do not currently have the infrastructure to do that (again, this is an experimental service), but it's an interesting thought.

5. Not right now, but we could consider it if this is a serious issue

6. Not right now, but we'll add this soon

Thanks for your interest on this. If you have more ideas/suggestions please share them.

Pablo Castro

Technical Lead

Microsoft Corporation

http://blogs.msdn.com/pablo

Hi Pablo.

Thanks for the replies.

  1. You could take "Provide an administration console for the service" as a high-level request at this time. At the moment I dont know what this would provide other than the size of the DB, but Im sure theres plenty of other stuff.
  2. Interesting answer. Indexing is definitely something that you need to address so Im glad to see you acknowledging that.
  3. ditto
  4. ditto
  5. Well I built a super-experiemental thing today just to "have a go". now I understand it better I want to start fro scratch again. I cant go back and modify so my only resort is to to email you guys (which Ive done) and wait for you to delete the existing. Lets be honest, this is no way to work is it I want to play with this stuff now, not tomorrow. I daresay I wont be the only one facing this problem.
  6. ditto.

cheers

Jamie