Monday, October 27, 2008

SQL Server: Database to Data Platform

This session should give an introduction to how data is handled on the assure platform.







Azure is not hosting. It's a service.





Basically Microsoft recognizes how nice the outlook/mail arch is. Data is on server, desktop, phone, and web ( owa).





Model and policy based management.
Going forward microsoft will refer more and more to services through entity model of entity framework.

Use policy to specify how elements in model are handeled and accessed.









Not sure if data services is supposed to serve as entire data layer.

Want to use this to enable community based libraries and examples.

Www.github.com/sdsteam





Example query.




Looks like SDS has it's own query language. Looks like linq but it isn't.
Add another language to the list of languages to learn.

ADS exposed via REST api.

Demo the sync framework.




Sample of SPF app on sync framework.




We really should move to sync framework.

Need to dig deep into policy based management. Mentioned several times by presenter.





Provided an overview of the new SQL server 2008 features.

SQL server report builder is a new report builder for the simple user.

Trying to separate logical and physical data management. We define the shape of the data. They define how it is managed and kept.

Create database is logical command. Specifying that the log file is on drive E is physical.

Just explained that they have limited functionality so that they can properly handle the physical.
Over time they will enhance the functionality.
Sounds exactly like the salesforce model.
They do plan to house ALL your data if they can.



No comments: