Entries tagged with sql server - Channel 9

Microsoft Visual Studio Team System Database Edition: Overview

System — Wed, 29 Oct 2008 16:38:59 GMT

Visual Studio Team System (VSTS) Database Edition enables developers to apply agile practices to the database tier. VSTS takes "One Version of the Truth" for database objects and moves it into source control. See how it interoperates with external data sources like MySQL, Oracle, IBM DB2, and Microsoft SQL Server 2008.

Gert Drapers
Gert Drapers is the Group Engineering Manager for the Visual Studio Team System Database Edition product as known as the “Data Dude”. After 3 years of Ashton-Tate where he was first introduced to SQL Server in 1988, Gert joined Microsoft in 1991. Prior to his current position he was a member of the SQL Server development team where he held various positions varying from development to management. He contributed to SQL Server 7.0, 2000 and 2005; some SQL Server artifacts he worked on are: BULK INSERT, SQL-DMO, SQL Query Analyzer, SQL Profiler, DTS, SQL Agent and SMO. After SQL 2000 he joined the Indigo team where he designed the System.Transactions API and worked on MS-DTC and the web services (WS-AT) transaction specification. In September of 2003 he joined the SQL Server Customer Advisory Team where he focused on helping customers design and implement the largest SQL Server implementations in the world. In July 2005 he started the DataDude project, which goal in life is to provide an offline schema development and deployment environment for SQL Server and other data stores. Right now the team is finishing up the 3rd release of the product! When Gert is not working, he is spending time with his wife and three lovely daughters; loves to cook and make music. Besides that he is serving the SQL Server community by writing tools and articles which are published on http://SQLDev.Net and various magazines.

Microsoft SQL Server 2008: Powering MSDN

System — Wed, 29 Oct 2008 16:38:53 GMT

Hear how the MSDN team created the multi-terabyte system (over 12 million documents) that serves as the core of the web platform and provides integration of content from MSDN and TechNet into Microsoft Visual Studio, Microsoft Exchange Server, and Windows Server. Learn about advanced features like: designs around Blob and associated content from other stores, MERGE delta-processing, Index Filtering, Table Value Parameters, and Data Compression. Everything is demonstrated in the MSDN production system with real-world scenarios.

Mark Johnston

Entity Framework Futures

System — Wed, 29 Oct 2008 16:38:10 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

Project "Velocity": A First Look

System — Wed, 29 Oct 2008 16:38:00 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
I am a principal architect of Velocity - the distributed caching platform. Before Microsoft I worked in the Oracle database engine building the object-relational support, XMLDB, XQuery and secure enterprise search product.

Offline-Enabled Data Services and Desktop Applications

System — Wed, 29 Oct 2008 16:37:47 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.

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).

Developing Applications Using Data Services

System — Wed, 29 Oct 2008 16:37:45 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.

Mike Flasko

SQL Server Compact: Embedding in Desktop and Device Applications

System — Wed, 29 Oct 2008 16:35:57 GMT

Learn how SQL Server Compact can be used to create data files for your applications, run applications directly from DVD, capture user activity, and sync "back home." Learn the different deployment options, including the newly released 64-bit support and best practices for performance.

Steve Lasker
Steve is Program Manager at Microsoft on the SQL Server Copmact team, working to empower developers to enable their occasionally connected users. For Visual Studio and SQL Server 2008, Steve focused on the design for Sync Services 1.0. For VS 2005, Steve worked on many of the data design time features including the Typed DataSet designer, TableAdapters, Object Binding and the Data Sources Window. Prior to joining Microsoft, Steve was a technical architect with an early internet eCommerce company moving to a consulting firm building web, client and device applications for corporate customers. With an engineering background in the remote broadcasting industry Steve lived the life of the mobile workforce where he gained his passion for the occasionally connected user.

SQL Services: Tips and Tricks for High-Throughput Data-Driven Applications

System — Wed, 29 Oct 2008 16:33:18 GMT

Learn how to use the Authority-Container-Entity (ACE) concepts to build large scale, high-throughput applications using SQL Services and other cloud-based services.

David Robinson
David Robinson is a Senior Program Manager on the SQL Server Data Services (SSDS) team. David is responsible for a multitude of things including driving product features, code samples, and most importantly demonstrating to customers the value that SSDS and cloud computing provides. David enjoys getting out in the community, presenting on SSDS, gathering feedback, and helping to ensure SSDS meets whatever demands you throw at it. David has also written for MSDN magazine on developing solutions against SSDS. Before joining the SSDS team, David was a Solutions Architect on Microsoft's Health and Life Sciences team. Before joining Microsoft, David held various senior positions with a variety of software and consulting companies. David got his start as a developer at Computer Associates in the early 90's. When not working, David enjoys spending time with his wife and helping her corral their 4 young daughters.

Sync Framework: Enterprise Data in the Cloud and on Devices

System — Wed, 29 Oct 2008 16:33:05 GMT

See how synchronization plays a pivotal role in transitioning to a managed cloud environment by creating a central hub of information in the cloud. Using synchronization, organizations can enable more efficient mobile and enterprise-to-enterprise scenarios.

Liam Cavanagh

SQL Server 2008: Developing Secure Applications

System — Wed, 29 Oct 2008 16:32:59 GMT

Learn what application developers and DBAs should consider to help secure data. Topics discussed include authentication, authorization, execution contexts, and encryption with focus given to the new security features introduced in SQL Server 2008.

Il-Sung Lee
Il-Sung Lee is a Program Manager for the Engine team in the SQL Server product group and is the PM owner for SQL Server Engine Security. Il-Sung has over ten years of experience in the database industry as a developer and a program manager focusing on database security and database communications. His current focus is to advance the capabilities of SQL Server in areas such as authentication, authorization, encryption, audit, and intrusion detection. He has presented at numerous SQL Server and DB2 conferences over the past several years. Il-Sung graduated with an M.Eng degree from McGill University and subsequently worked seven and a half years for IBM in their Information Management group before joining Microsoft in 2005.

SQL Server 2008: Business Intelligence and Data Visualization

System — Wed, 29 Oct 2008 16:32:44 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
I am lead program manager in the SQL Server Reporting Services team. Prior to becoming a program manager, I graduated from Harvard in 1997 with a Ph.D. degree in theoretical physics and joined Microsoft shortly afterwards. My past projects include mainly development of business intelligence applications and data mining algorithms.

SQL Server 2008: New and Future T-SQL Programmability

System — Wed, 29 Oct 2008 16:32:43 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
My name is Michael Wang, and I’m currently a senior program manager lead in the SQL Server engine application platform product team of Microsoft. My team is primarily responsible for driving & delivering product features and improvements for sever side programmability that covers SQL data types, libraries/functions, SQL relational accessibility, T-SQL procedure programming & logic, SQLCLR, T-SQL supportability,globalization and etc.

SQL Server 2008: Deep Dive into Spatial Data

System — Wed, 29 Oct 2008 16:32:42 GMT

Look at some interesting and unexpected aspects of spatial data, where intuitive expectations collide with the hard realities of geometry and computation. Explore problems such as the ambiguity in spatial constructs, the certainty and precision of spatial calculations, and how types interact with indexes. Beyond understanding, see a demonstration of techniques for dealing with these issues in SQL Server 2008 using both built-in spatial functionality and server extensions.

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.

SQL Server 2008: Beyond Relational

System — Wed, 29 Oct 2008 16:32:35 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

SQL Server: Database to Data Platform - Road from Server to Devices to the Cloud

System — Wed, 29 Oct 2008 16:32:33 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.
Zach Skyles Owens
Zach Owens is a Technical Evangelist focused on SQL Server and Business Intelligence. He has a background in competitor technologies developing web-based solutions spanning Oracle data warehouses to LAMP e-government applications, and is a recent Seattle transplant from Maui where he was developing medical logistics and intelligence applications.

SQL Server 2008: Developing Large Scale Web Applications and Services

System — Wed, 29 Oct 2008 16:32:20 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 Microsoft 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.

Hala Al-Adwan
Jose Blakeley
José Blakeley is Partner Architect in the SQL Server Engine at Microsoft where he works on server programmability, database engine extensibility, query processing, object-relational functionality, large scale query processing, and scientific database applications. He joined Microsoft in 1994. Some of his contributions include the development of the OLE DB data access interfaces, the integration of the .NET runtime inside the SQL Server 2005, the extensibility features in SQL Server, and the creation of the ADO.NET Entity Framework in Visual Studio 2008. José has authored many conference papers, book chapters and journal articles on design aspects of relational and object database management systems, and data access. Before joining Microsoft, José was a member of the technical staff with Texas Instruments where he was co-principal investigator of the DARPA Open-OODB system. He received a B. Eng from ITESM, Monterrey, Mexico, and a Ph.D. in computer science from University of Waterloo, Canada.

JamBase.com - Go See Live Music

Synergist — Tue, 14 Oct 2008 05:30:00 GMT

Last week I visited JamBase.com, a San Francisco-based website that is all about finding and going to live music performances. I met Andy and his colleauges at the Bandwidth Conference this summer and after hearing about their new API, I just had to try doing a mashup with it using Popfly - I wrote about it on my blog here. Because their site runs on ASP.net with SQL Server, I wanted to sit down with Andy Gadiel, the founder to have a chat.

Griffsoft: ügyviteli rendszer áttervezés

zsolt.batorfi — Mon, 29 Sep 2008 12:17:00 GMT

Az utóbbi időben egyre érdekesebbé válik a kérdés, hogy mi lesz azzal a számtalan, hazánkban kifejlesztett ügyviteli rendszerrel? Hogyan lesznek képesek modernizálni magukat? Mit jelent mindez a gyakorlatban?

Felnyergeltem hát, s leutaztam Szegedre, a Griffsoft Kft. architekjeihez, akikkel megvitattuk, hogyan írják át teljesen új alapokra a Forrás SQL nevű, profi ERP rendszerüket.

A következőkről volt szó:

07:00 - Forrás SQL kezdetek

12:00 - Miért tervezték át?

14:50 - Az egész a UI layernél kezdődött...

18:00 - Milyen belépni a Winforms világba?

22:00 - Mit jelent átállni komponens, elosztott szemléletre?

25:50 - WPF vs. Windorms?

27:50 - SQL Server tapasztalatok

34:00 - Mit gondoltok a Linq/Entity FW-ről?

Слава Красовский про SQL Server Agent

mikcher — Tue, 09 Sep 2008 11:48:00 GMT

Слава Красовский рассказывает про SQL Server Agent - менеджер выполнения заданий по расписанию в Microsoft SQL Server

MultiTenant Data Access (MTDA) S+S Blueprint Released

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

Important Note: The new Microsoft Blueprints Manager (BPM) is replacing the S+S Blueprints Manager and will be available Friday, October 31st. This Blueprint will be upgraded to work with the new BPM shortly.

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 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.