Welcome to MSDN Blogs Sign in | Join | Help

The Data Programmability XML Tools team is conducting a survey focused on XML technology and tools usage over the coming weeks.  The survey takes about 15 minutes to complete and we’d appreciate it if you would take the time to respond to it.  We plan to use the survey results to help drive prioritization of features over the coming releases of Visual Studio and SQL Server.

The survey can be found here:  https://mscuillume.smdisp.net/Collector/Survey.ashx?Name=XMLTools

Thanks,
Tim Laverty
PM, XML Tools

The advances in processors, memory, storage, and connectivity have paved the way for next-generation applications that are data-driven, whose data could reside anywhere (i.e. on the desktops, mobile devices, servers, and in the cloud) and that require access from anywhere (i.e. local, remote, over the network, from mobile devices, in connected and disconnected mode). This trend has led to the development of distributed, multi-tiered, and composite application architectures for the web and for the enterprise. A typical enterprise application accesses data from multiple data sources, integrates that data, re-shapes (or transforms) that data into a form most suitable for the application (typically into object form like C# or Java object), and writes application logic. The same is true of web applications – consider social networking apps or mashups – they access data from multiple web sources, over the internet, aggregate it, execute application logic, and generate pages for web interaction. As these styles of multi-tiered web and enterprise application are becoming main stream, the demand for application performance and scale is increasing. End users become less tolerant and more frustrated when a web application cannot respond in milliseconds; web applications that cannot scale, as the number of concurrent accesses increase, lose traffic and thereby business. Fundamentally, we have all begun to expect high performance and scale from every application. And let’s not forget application availability. For similar reasons to those I describe above, an application cannot be down. We cannot imagine the MSN portal or the Amazon web site, or the corporate SAP financial application being down when we need it. We expect to access our personal information on MSN at any time; consumers do business with Amazon at any time and from anywhere. Fundamentally, applications need to be available all the time to support access at any time, and from anywhere. Another major expectation, especially from application developers and from application hosters is that of scalable and available applications at a low cost. A decade ago, only mission-critical businesses could afford to invest in large and expensive infrastructure (both hardware and software) to support scale and availability of their applications. But, now with web hosting, everyone expects and demands high scale and availability at low cost. Extending this even further, not only developers want cheap scalable and available applications, they want the ability to develop (and deploy) such applications very rapidly.

To cope with competitive pressure, both from an innovation and a deployment perspective, rapid development and deployment of these applications is critical for application vendors.  In turn, application developers are looking for application infrastructure that enables them to build highly performant, scalable, and available applications using commodity hardware and software, at a rapid pace. Traditional application platforms like the .NET and Java platforms, which are known for rapid multi-tier application development and deployment, are required to provide the scalability and availability infrastructure. 

Distributed cache is becoming the key application platform component for providing scalability and high availability. In-memory caching has been traditionally used primarily for meeting the high performance requirements of applications. By fusing caches on multiple nodes into a single unified cache however, the distributed caches offer not only high performance, but also scale. By maintaining copies of data on multiple cache nodes (in a mutually consistent manner), the distributed cache can also offer high availability to applications. Distributed caches are especially ideal for applications with the following characteristics:

  • There is a considerable number of data requests that are mostly read (e.g. product catalogs)
    • Large concurrent access to such data can be provided by replicating the catalog data on multiple cache nodes. Since updates are infrequent to such data, maintaining consistency (synchronously or asynchronously) is not very expensive
  • Applications that can tolerate some staleness of data
    • Such applications can provide better performance and scale by not requiring immediate updates ore refreshing of caches
  • Applications that can work with highly partitioned data (e.g. session data, shopping cart)
    • High scale and performance can be supported by partitioning and distributing data across multiple cache nodes, and thereby distributing data processing across the cache nodes
  • Applications that can work well with eventual consistency
    • Consider a flight inventory application, which must satisfy a large number of concurrent read/writes to the inventory of seats. To support large scale, the distributed cache may replicate the inventory value on multiple nodes; however, the inventory values on different nodes have to be made consistent in some fashion.  Requiring immediate (also known as strong) consistency will require updates to be synchronously propagated to all the copies. Such action would impact the overall performance and scale of the application. However, instead of immediately making the copies consistent, allowing them to eventually (in an asynchronous manner) become consistent will provide low latency, high performance access to inventory.

As distributed caches become more widely deployed, I believe over the next few years, distributed cache will be used as the first tier of all data access. Multi-tier application architecture will include the cache tier as a data access tier between the application server tier and the backend data tier.

Today, Microsoft is announcing the first CTP of a distributed caching product to provide the .NET application platform support for developing highly performant, scalable, and highly available applications. The project code named “Velocity” is a distributed cache that allows any type of data (CLR object, XML document, or binary data) to be cached. “Velocity” fuses large numbers of cache nodes in a cluster into a single unified cache and provides transparent access to cache items from any client connected to the cluster. The Data Platform Developer Center at http://msdn.microsoft.com/data and the Velocity Team Blog at http://blogs.msdn.com/velocity provides additional information about project code named “Velocity” as well as links to download our first CTP.

Distributed caches are not new – during the last couple of years several caching products have emerged to address the performance and scalability needs of applications. Most of these products are point products, primarily supporting key-based access. Other than memcached, which is an open source technology, most others target enterprises and enterprise workloads and scale. I think the web workloads require considerably large scale, with 1000s of cache nodes in a cluster. The web scale distributed caches not only require mechanisms that can scale and provide availability in very large clusters, they must be easy to manage or self-managed. In the Future, “Velocity” envisions being an integral part of the .NET application stack targeting both enterprise and web workloads (and scale). As applications start using the caches for data access, I also believe, they will demand richer data services like query, transactions, analytics, synchronization etc. For example, we believe .NET applications will require LINQ queries on the distributed cache, the same way they query the backend SQL Server database. We envision “Velocity” becoming such a comprehensive distributed caching platform. The performance, scale, and availability functionality of “Velocity” along with its rich data services will allow for rich web and enterprise applications development and deployment.

Anil Nori
Microsoft Distinguished Engineer

The SQL Server JDBC team is running at full speed working on the next JDBC driver for SQL Server.  We are looking for people to share in our excitement about the future of data access for SQL Server and to manage the quality of our next deliverables. 

 

Are you passionate about working with data, the powerful query capabilities of T-SQL, the power of Object Oriented programming languages like Java, C#, C++? Are you interested in designing the next set of API’s for data and want to work for a team that’s focused on shipping technologies and having fun?  

 

We are interested in hearing from you.  Drop us a line through the team blog or directly to me and we’ll get back to you.

 

Uwa Agbonile

SQL Server JDBC/SNAC/PHP Teams

Uwa.Agbonile@microsoft.com

Do you want to work on the next generation of data access APIs for the web?  If so, the Astoria and XML teams are hiring.  If you want to get a feel for the types of problems our team thinks about the solutions we build, check out the earlier posts on this blog as well as

http://msdn.microsoft.com/data and http://msdn.microsoft.com/xml

We have a range of job openings across disciplines (Development, Developer in Test and Program Management) available on the Astoria and XML teams.  If you are interested in any of these positions, please send myself (mike.flasko@microsoft.com) and Andy Conrad (aconrad@microsoft.com) email.

For more details on each of the open positions, please see:

ADO.NET Data Services PM

XML PM

XML PM

ADO.NET Data Services SDE

ADO.NET Data Services SDE

XML SDE

ADO.NET Data Services SDE/T

ADO.NET Data Services SDE/T

XML SDE/T

We look forward to talking with you...

Thanks,

Mike Flasko : ADO.NET Data Services ("Astoria"), Program Manager

We are very excited about .NET 3.5 SP1 and Visual Studio 2008  SP1 and what this update means for developers who use ADO.NET for data development.  This beta marks the entry of the ADO.NET Entity Framework and ADO.NET Data Services (aka project Astoria) as part of the overall .NET/Visual Studio beta install. This public release is also the final beta before the RTM of these two technologies. In addition, we have a revision of LINQ to SQL  that introduces the new date time functions for SQL Server 2008.

 

In the space of a few short months developers have been able to experience a wave of innovation in the .NET data programming space. We began with the introduction of LINQ in .NET Framework 3.5 for providing a compile time query experience over in-memory objects, XML and relational data, and now we’re adding the Entity Framework runtime and graphical entity designer into the mix.  The Entity Framework extends the reach of ADO.NET, providing a new data model that will be the foundation for a range of data services moving forward. We’ve also enhanced the common ADO.NET provider model enabling a LINQ programming experience against 3rd party databases.  The Entity Framework designer in Visual Studio works with 3rd party databases as well and enables developers to visualize the data model being used by the application.

 

Over the last year or so we’ve seen a growing trend in the way people build services.  They tend to either be operation-centric with a focus on actions occurring on either side or they are resource-centric, where the focus is on working with the data or resource on either side.  For operation-centric services the Windows Communication Foundation (WCF) and Windows Workflow (WF) teams have done a bunch of work in .NET 3.5 to make it easier to build these action oriented service interfaces as a workflow.  On the data-centric side, the Data Programmability team has been working with the WCF team to deliver ADO.NET Data Services.  This is one of the most exciting new additions to the platform in some time, providing the foundation for building the next generation of data-driven applications and services today. These data services build on the WCF classes to provide an end-to-end experience for building data-centric REST based services in .NET.  They have a REST based query model, a means of exchanging metadata (in terms of the Entity Data Model) and client and mid-tier API’s that let people build rich data services and clients in a way that is easier than ever before. Developers can start with the Entity Framework and expose relational data via the Data Services Framework, they can expose non-relational data using a custom provider, or they can use some of the existing services that already expose these protocols.

 

·         Live App Storage

·         Live Spaces Photos


In summary, it is an exciting time to be working with data on the .NET platform.  The team is looking forward to your feedback.  We invite you all to download this beta and start using these technologies today.

 

 

Sam Druker

General Manager, Data Programmability

We’re gearing up for the next release of the SQL Server, and we are looking for people that have a passion for building great data access technologies and frameworks to help with the effort.  We have been very busy recently releasing:

·         Microsoft .NET Framework 3.5 (includes .NET Framework Data Provider for SQL Server aka SqlClient)

·         Microsoft SQL Server 2008 Feature Pack CTP, February 2008 (includes Microsoft SQL Server 2008 Native Client)

·         SQL Server 2005 Driver for PHP Community Technology Preview (February 2008)

·         Microsoft SQL Server 2005 JDBC Driver 1.2

If you are interested in designing the next set of API’s and tackling challenging technical subjects across all our SQL Server data access stacks and want to work for a team who is focused on shipping great technologies, we’re interested in hearing from you. Drop me a line directly at ddove@microsoft.com.

Debra Dove
Lead Program Manager

Since posting on the topic of design-time and runtime connectivity to pre-release versions of SQL Server 2008 on the Data blog in November, the set of affected clients (applications, runtimes, and operating systems) have been officially released: Microsoft Visual Studio 2008, Microsoft .NET Framework v3.5, Microsoft Vista Service Pack 1, and Microsoft Windows 2008. Runtime connectivity from a client system configured with any of these released products to SQL Server 2008 November CTP or later provides full runtime access to the following features (for design-time functionality, see below):

·         Table-Valued Parameters

·         New date/time data types

·         Large user-defined types

·         Support for very large FILESTREAM-attributed column data

Design-Time Connectivity Between Visual Studio and SQL Server 2008

Developers using Visual Studio 2005 or Visual Studio 2008 design tools will receive an error when trying to open a database on any pre-release instance of SQL Server 2008 without installing a Visual Studio patch. Pre-release patches for Visual Studio 2008 and Visual Studio 2005 enable the following Visual Studio functionality for SQL Server 2008:

·         Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited.

o   Note that table schemas still cannot be viewed or edited in this release.

·         SQL CLR projects that target SQL Server 2008 can be created and deployed to the server.

·         T-SQL and SQL CLR debugging are now enabled for SQL Server 2008.

·         Data binding features in Client and Web Projects are enabled.

 

Pre-release versions of the design-time patches are currently available: the Visual Studio 2008 CTP patch is available for download here and the Visual Studio 2005 CTP patch is available for download here. Final versions of the patches will be available in the near future. For more information please see the "Connecting to Microsoft SQL Server 2008 from Microsoft Visual Studio 2005 and 2008" whitepaper on MSDN.

 

 

Debra Dove

Program Manager Lead, Data Programmability

We’re pleased to announce that 64-bit MSDASQL for Windows Server 2003 is now available for download at  http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b. This update will also be available through “Windows Update” soon.

 

What is MSDASQL?

MSDASQL is an OLEDB/ODBC ‘bridge’ that allows applications built on OLEDB and ADO (which uses OLEDB internally) to access data sources through ODBC drivers. MSDASQL ships with the Windows Operating System, and Windows Server 2008 and Windows Vista SP1 are the first Windows releases to include a 64-bit version of MSDASQL.

 

Isn’t MSDASQL Deprecated?

Previous messaging on MSDN indicated that a 64-bit version of MSDASQL would not be available. However, we have received numerous requests from customers for this technology and we are making it available on the following Windows operating systems:  Windows Server 2003, Windows Vista SP1 and Windows Server 2008. Microsoft has no plan yet to deprecate this technology currently.

 

Mo Lin

Program Manager, Data Programmability

We’re gearing up for the next release of the .NET Framework, and we are looking for people that have a passion for building great frameworks to help with the effort.  Since we’ve shipped the .NET Framework 3.5 we’ve been working on projects like the ADO.NET Data Services Framework (aka Astoria) and LINQ to XML support in Silverlight.  If you’re interested in designing the next set of API’s for data and want to work for a team that’s focused on shipping technologies and having fun, we’re interested in hearing from you.  Drop us a line through the team blog or directly to me and we’ll get back to you.

Carl Perry
Lead Program Manager

cperry@microsoft.com

I just got back from the h^3 launch event in LA and found a few nifty-cool things waiting for me in my aggregator. First, the ever practical (and prolific) Julie Lerman is writing a book on the ADO.NET Entity Framework for our friends at O'Reilly. Very cool indeed.

Also waiting for me was the news that Ruurd Boeke has started the EFContrib project over on Codeplex. He's got a couple projects going on up there already. Using a postcompiler here is a pretty cool idea, and Ruurd's definitely making the EF sing and dance here.

  1. PostSharp4EF: Automatically implement IPoco This project uses PostSharp to post-compile your assemblies. When it encounters a simple attribute, it will implement everything needed to use it in EF: Typelevel attributes, EDMscalar attributes, changetracking and default values. This means there are no runtime performance penalties. See Introducing EF Contrib post for more detailed information about this project.
  2. Plug-in Edmx Code Generator: easily add assemblies that will hook into the codegeneration part of Entity Framework. Check this blog post out for more info!

Finally, our friends in the SQL Server Compact team have released an EF provider for their 3.5 Beta 1 release. This is wicked cool.

Yesterday Microsoft announced a new student software program that will provide no-cost access to the most recent Microsoft Developer technologies and tools, including Visual Studio and the associated .NET Data technologies and tools, to College students around the world.

Currently the program is available to 11 countries including: Belgium, Canada, China, Finland, Germany, Spain, Sweden, Switzerland, the United Kingdom, and the United States.

From the Data Programmability Team

The December CTP of ADO.NET Data Services (also known as Project Astoria) has been Released! You can download the CTP here as part of the ASP.NET 3.5 Extensions preview release.

 For more information on ADO.NET Data Services check out http://blogs.msdn.com/astoriateam/default.aspx .

Elisa Flasko
Program Manager, Data Programmability

Announcing the release of the ADO.NET Entity Framework Beta 3!

 

The  ADO.NET Entity Framework Beta 3 release enables users to visually design models and mappings using Visual Studio 2008 RTM and the .NET Framework 3.5 RTM. This release also incorporates fixes to bugs, performance improvements and includes many features requested by customers.

 

Elisa Flasko

Program Manager, Data Programmability 

The gang at Channel 9 gave me a soapbox for talking about the Entity Data Model, the ADO.NET Entity Framework, SQL Server, a strong architectural factoring and a bunch of related rambling about how to build composite applications that handle massive quantities of data. Enjoy! (or not, sound off in the thread either way ;)

SamDruk

More Posts Next page »
 
Page view tracker