Entries tagged with sql server - Channel 9

Project "Velocity": A First Look

System — Mon, 01 Sep 2008 23:34:58 GMT

It is predicted that all large applications will use a distributed data cache as the initial tier for all data access. This session presents an overview of "Velocity," Microsoft's distributed in-memory cache, and shows how it works with IIS, ASP.NET, ADO.NET and SQL Server Data Services.

Murali Krishnaprasad

Offline-Enabled Data Services and Desktop Applications

System — Mon, 01 Sep 2008 23:34:57 GMT

The ADO.NET Data Services Framework (a.k.a. Project "Astoria") introduced a way of creating and consuming flexible, data-centric REST services. By combining data services with the Microsoft Sync Framework, learn how to create offline-capable applications that have a local replica of their data, how to synchronize that replica with an online data service when a network connection becomes available, and how replicas can be used with the ADO.NET Entity Framework. Also, hear us talk about our plans, see the tools that help client- and server-side setup, and discuss the runtime components and APIs.

Mike Flasko

Developing Applications Using Data Services

System — Mon, 01 Sep 2008 23:34:57 GMT

In the near future, applications will be developed using a combination of custom application code and online building block services, including data-centric services. In this session we discuss advancements in the Microsoft development platform and online service interfaces to enable seamless interaction with data services both on-premises (e.g., ADO.NET Data Services Framework over on-premises SQL Server) and in the cloud (e.g., SQL Server Data Services). Learn how you can leverage existing know-how related to LINQ (Language Integrated Query), data access APIs, data-binding, and more when building applications using online data.

Pablo Castro
Pablo is a Software Architect in the SQL Server group at Microsoft. He has worked in various areas of SQL Server and he's currently focused on making data and the web work well together with technologies such as Data Services (Project Astoria).

"Oslo": Repository and Schemas

System — Mon, 01 Sep 2008 23:34:57 GMT

"Oslo" uses schematized data stored in the "Oslo" repository to drive the development and execution of applications and services. Tour the schemas and see how user-defined content can be created and related to them. Learn how to utilize platform schemas, such as worflow, services, and hosting. Also, learn how to extend the repository and how to use repository-extended SQL database services to support critical lifecycle capabilities such as versioning, security, and deployment.

Chris Sells
Martin Gudgin

"Oslo": The Language

System — Mon, 01 Sep 2008 23:34:57 GMT

"Oslo" provides a language for creating schemas, queries, views, and values. Learn the key features of the language, including its type system, instance construction, and query. Understand supporting runtime features such as dynamic construction and compilation, SQL generation, and deployment. Learn to author content for the "Oslo" repository and understand how to programmatically construct and process the content.

Don Box
David Langworthy

Entity Framework Futures

System — Mon, 01 Sep 2008 23:34:57 GMT

The next version of the Entity Framework adds scenarios in the areas of model driven development, domain driven development, simplicity, and integration. See a preview of production and prototype code for the next version of the Entity Framework as well as a candid discussion with members of the development team.

Tim Mallalieu

Microsoft SQL Server 2008: Business Intelligence and Data Visualization

System — Mon, 01 Sep 2008 23:34:55 GMT

Learn how to create an entity data model and bind it to data visualization and ReportViewer controls. Dive into new Reporting Services features like: Tablix, new Data Visualization controls, and the new Report Creation experience. Also, preview the future AJAX ReportViewer control and the new RDLC designer.

Stella Chan

Microsoft SQL Server 2008: New and Future T-SQL Programmability

System — Mon, 01 Sep 2008 23:34:55 GMT

This session covers new 2008 T-SQL programmability features and enhancements for SQL data types, SQL language, T-SQL procedure programming, CLR integration, T-SQL dependency management, globalization, and more. Learn to develop using the new date and time datatypes, table-valued parameters and MERGE that are new in SQL Server 2008.

Michael Wang

Microsoft SQL Server 2008: Deep Dive into Spatial Data

System — Mon, 01 Sep 2008 23:34:55 GMT

Spatial data is increasingly more central to data processing. We present a deep dive into how developers can work with spatial data using SQL Server 2008.

Isaac Kunen
Isaac Kunen is a senior program manager on the SQL Server engine programmability team. Isaac has recently been concentrating on spatial database support, in addition to working on the SQL Server type system, SQL CLR integration, and database extensibility. Prior to joining Microsoft in 2005, Isaac was a developer at BEA Systems.

Microsoft SQL Server 2008: Developing for Semi-Structured Data

System — Mon, 01 Sep 2008 23:34:55 GMT

In scenarios like product catalogs, property management, and digital asset management, information is often sparse and semi-structured. Learn how the new technologies in Microsoft SQL Server 2008 enable you to store, update, and query semi-structured data, including: sparse columns, filtered indexes, hierarchyID, and XML.

Michael Rys

Microsoft SQL Server: Data-Driven Applications from Device to Cloud

System — Mon, 01 Sep 2008 23:34:54 GMT

Cloud-based data services will change the way you develop and deploy applications, and SQL Server technologies are evolving to help you build data-driven solutions that span devices, desktops, servers, and the cloud. Learn how to use ADO.NET Data Services Framework (code name "Astoria"), SQL Server Data Services (SSDS), and the Microsoft Sync Framework. Hear how to build applications that can be deployed using SSDS in the cloud or SQL Server on-premises, and learn how to gain insights using the BI capabilities of Microsoft SQL Server.

David Campbell
David Campbell is a Microsoft Technical Fellow working on Cloud Data Platform technologies. Campbell has been with Microsoft for 14 years working on SQL Server and a number of other database and storage related technologies.

Microsoft SQL Server 2008: Developing Large Scale Web Applications and Services

System — Mon, 01 Sep 2008 23:34:54 GMT

As a developer of mission critical, large-scale web applications and services, do you worry about supporting large numbers of users with lightning fast response times, scaling to terabytes of data, designing multi-tenant services, as well as the cost of building these applications? If you answered yes, come to this session and learn how SQL Server 2008 and other data platform services will help you architect and develop your applications to be high throughput, low latency, and highly available-and yet provide predictability of performance and total cost. We describe proven data architectures, design patterns and practices being used by our highest scale customers who service millions of users every day. We also share our next release plans that will help you understand our roadmap on how we will continue to address the needs of the most demanding large-scale applications.

Jose Blakeley

MultiTenant Data Access (MTDA) S+S Blueprint Released

Michael Lehman — Mon, 25 Aug 2008 20:47:00 GMT

In this video, Michael Lehman talks with Eugenio Pace about the new Multi-tenant Data Access Software + Services Blueprint.

The Multi Tenant Data Access (MTDA) Blueprint, part of the Software-plus-Services Blueprint program, provides guidance on writing a SQL Server based, single instance, multi-tenant data access layer similar to that used in LitwareHR sample application (SQL Server version).

If you have the S+S Blueprints Manager installed you can get this Blueprint by updating from the RSS feed.

If you want more information, you can visit the MTDA codeplex site: http://www.codeplex.com/mtda

The Dynamics Duo talk about Dynamics CRM Customization

benriga — Tue, 12 Aug 2008 00:18:00 GMT

Girish on my team has been working on a demo that demonstrates the capabilities of the Dynamics CRM platform. We figured it would be a lot more interesting to get some of that on video in the form of a conversation (as opposed to a screencast) so I get to play the role of interviewer and Girish is the "talent" :). In this episode, we started off thinking we'd talk about Dynamics CRM and SharePoint integration but got so deep into the underlying capabilities of CRM that we ran out of time. We'll show you the SharePoint stuff in the next episode. I promise!

The demo that Girish has been working on uses the scenario of a fictitious graphics design firm (i.e. a professional services organization). Clearly CRM works great for automating sales, service and marketing functions. What we think about is the stuff under the covers that can be used by developers and ISVs to build new applications that may or may not be related to CRM. That’s what we mean by the CRM platform.

This includes the basic metadata required to store the data related to a line-of-business application. CRM uses the concept of entities and attributes to store data whether your online or offline (all stored in SQL Server). It also makes the building of relationships among those pretty simple. Once you've got your metadata defined then building forms for the UI (ASP.NET) and workflow (Workflow Foundation) for process are next.

We’ll get into a lot more of the platform (and in particular the extensibility options) in the next few episodes.

Reporting and Analytics in Dynamics AX 2009

benriga — Mon, 11 Aug 2008 19:14:00 GMT

I spent some time with Manoj Nuthakki on the Dynamics team chatting about how we take full advantage of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) in the recently released Dynamics AX 2009. AX 2009 ships with 10 SSAS cubes out of the box so includes tons of prebuilt KPIs and reports all built on the SQL Server BI platform.

Manoj walks us through how reports and charts are built in Visual Studio including conditional formating or custom business logic in C# while pulling metadata and data directly out of AX. The reports are easily put into the AX 2009 rich desktop client and the enterprise portal web client (built on SharePoint). With the role center integration a developer can build reports, charts and KPIs that appear only for the appropriate roles. Since AX is an international product, localization is built right in.

SQL 2008 & Occasionally Connected Client Support in Visual Studio SP1

funkyonex — Sat, 09 Aug 2008 00:07:00 GMT

In this interview, Milind Lele, a PM on the Visual Studio Pro Tools team shows us the improvements made to the tooling in Visual Studio SP1 for occasionally connected clients as well as the new data type support for SQL Server 2008. Using SQL 2008 built-in change tracking, you don't need to make modifications to your table schemas like you have to do with SQL 2005. Additionally he shows off a "smarter" DataSet designer where you can have tables coming from server and client data stores all contained within one model.

Enjoy,
-Beth Massi, VS Community

Silverlight 2 Codeclip: Ein Mini CRM-System

TheOliver — Tue, 15 Jul 2008 10:58:00 GMT

Dieses Video zeigt wie man in wenigen Minuten eine kleine Silverlight-basierte Verwaltung von Geburtstagen erstellt. Dabei werden diverse Technologien verwendet wie z.B. SQL Server, Webservices, Linq und natürlich Silverlight.

TSQL Merge Statement - SQL Server 2008

ashishjaiman — Mon, 30 Jun 2008 21:07:00 GMT

In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement.

The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target object based on the results of that join.

Angry Hacker: 10 Reasons why SQL 2008 is Going to Rock

Dan — Mon, 23 Jun 2008 21:37:00 GMT

AngryHacker has a great post on 10 new features coming in SQL 2008 that will make it rock and/or roll.

My favorites from his list that I didn't know about: SQL Management Studio Add-ins and new features for processing delimited strings.

Microsoft Dynamics CRM 4.0 : Multi-Tenancy with John O'Donnell

jodonnell — Sat, 21 Jun 2008 05:52:00 GMT

Hello and welcome to another Microsoft Dynamics CRM 4.0 screencast.

In this presentation I talk about the multi-tenancy feature in Microsoft Dynamics CRM 4.0.

Enjoy the show!