Entries tagged with sql server - Channel 9

Set Your Data Free

Zach Skyles Owens — Wed, 25 Nov 2009 18:15:00 GMT

Watch Zach Owns in this introductory video about how a free upgrade to SQL Server Express will give your data, and your business, room to grow. Whether you manage your company's database, build applications for it, or both, the features and benefits of Microsoft SQL Server Express will take the pains out of growing. And unlike other free database software, there are absolutely no hidden or future costs.

Learn more at www.migrateyourdata.com

Building PHP simple database applications for SQL Server, Windows Azure Storage and SQL Azure

Jean-Christophe Cimetiere — Wed, 18 Nov 2009 18:59:00 GMT

The SQL CRUD Wizard for PHP is a wizard type application that can be used to generate a simple "Create, Read, Update, Delete" PHP application from a Microsoft SQL Server, Windows Azure Storage and SQL Azure database table. The generated PHP application supports paging, sorting and simple CSS customization. The generated PHP Application Code, generated by the PHP to SQL CRUD Wizard, includes logic for CRUD functionality between the PHP application and a SQL Server database instance on the web server.

Related links:

Ping 37: SQL Server, WIndows 7, Bing, Google, Bill Gates Birthday

Laura Foy — Mon, 09 Nov 2009 22:55:00 GMT

There actually is a valid reason for Paul to be wearing that shirt! Check out what the 'Softies were all buzzing about this week:

Big news about SQL Server
Happy Birthday Bill Gates!
MSN gets a make-over
Windows 7 heals itself
Bing & Google

Take Comics builds new comic publishing solution with Windows 7 and Touch

John O'Donnell — Thu, 08 Oct 2009 15:45:00 GMT

Larry Gregory talked to the team of Kevin Mann and Tony Williams of http://www.takepublishing.com at a recent Bizspark incubation event hosted by Sanjay Jain.

Their solution called TakeComics finally solves the problem of trying to find that missing issue of your favorite comic as well as new comics and render them digitally on many devices.

In a few days of development the TakeComics team were able to build a solution that could render comics and let you interact them using Windows 7 touch capabilities.

Enjoy the show!

John O'Donnell Microsoft Dynamics ISV Architect Evangelist
Microsoft Corporation
http://blogs.msdn.com/jodonnell
http://blogs.msdn.com/usisvde
http://www.twitter.com/jodonnel

Ping 25: Comedians, SQL server, Photosynth, Facebook, Zune, Bingle

Laura Foy — Mon, 17 Aug 2009 04:57:00 GMT

For entertainment purposes only we decided to invited our friend, established comedian Kirk Fox into the Ping lair...here's how it all went down:

Jonathon Mann wins a BINGLE
Secret Service SQL Server
PhotoSynth and Facebook
What does Zune HD mean for you?
Do viral videos work?

And more...let us know your thoughts!

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

Kirk Evans — Tue, 14 Jul 2009 19:52:00 GMT

In this episode, host Kirk Evans talks with Dr. Michael Ludwich, VP of Consulting at Decentrix, where Dr. Ludwich provides a demonstration of the BIAnalytix solution. This quite an interesting demonstration, helping to show the value of BI in a media organization.

In Part 1 of this interview, we talked with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcasters, cable operators, and telcos in the US. We talk about why BI matters, how BI is not simply providing reports in a transactional application, and we learn more about Decentrix and their BIAnalytix offering.
In part 2 of this interview, we will see a demo of BIAnalytix.

Microsoft Manufacturing Toolkit

Charles — Thu, 21 May 2009 00:43:00 GMT

The Microsoft Manufacturing Toolkit is a set of guidance documentation and working code samples that demonstrate the use of the Microsoft platform to build publish/subscribe (“pub/sub”), services-based architectures utilizing open standards for broad industry implementation. The toolkit focuses on the MIMOSA and OPC/OPC-UA organization specifications, and the working code samples demonstrate scenarios that might be implemented in a manufacturing environment. The design of the toolkit, however, is flexible and built on service oriented architecture (SOA) allowing it to be expanded to cover more standards than the ones covered now in the future; this flexibility will also allow the toolkit to be easily adapted to other non-manufacturing scenarios if needed.

Charles Fichter is a Senior Architect Evangelist in the Global Partner Technical team, within Developer & Platform Evangelism Division at Microsoft. Charles’ core responsibilities include- working with Microsoft’s Global Partners in system architecture design & guidance, helping partners achieve technical readiness on Microsoft’s new and emerging application platform technologies and architecting reference applications. In the following video, Charles walks you through the architecture and various components within the Microsoft® Manufacturing Toolkit.

New Silverlight-based SQL Server Value Calculator

Adam Kinney — Tue, 19 May 2009 10:28:00 GMT

The SQL Server team has released an interactive Silverlight-based Cost Analysis Tool, which allows you to change different values to see your possible savings when setting up your IT department. An addition to handy visuals, its interesting to note that this is a light-weight companion to the Full version.

Northeast Roadshow - Top things developers should know about SQL Server – Leveraging the SQL CLR

Brian Johnson — Fri, 01 May 2009 11:45:00 GMT

It’s rare that a developer doesn’t need some familiarity with the database his or her applications are targeting, so this session (divided in to five parts) provides a bit of insight into features of SQL Server 2008 (and 2005) that they should be aware of when building .NET applications. The series is a “top 5” countdown, and in this first segment, we talk about how to leverage the .NET CLR inside of SQL Server, including an introduction to the new data types in SQL Server 2008 (hierarchyid, geometry, and geography).

Complete slides and a SQL demo script are available at Code Gallery.

The Future of SQL Data Services with Nigel Ellis

Zach Skyles Owens — Mon, 27 Apr 2009 19:49:00 GMT

I had the pleasure of sitting down with one of SQL Server’s brightest, Nigel Ellis, to discuss the future direction of SQL Data Services. Nigel goes deep on the changes of SDS. If you want to learn what’s really going on behind the scenes this is a great place to start.

Check out Nigel's MIX session here.

Follow the SQL Data Services team blog here.

Overview and demonstration of Cast Iron Systems Application Integration and Migration Solution

John O'Donnell — Sun, 08 Mar 2009 17:15:00 GMT

While in Mountain View, CA I had the pleasure of visiting Cast Iron Systems and talking about their hardware and cloud based solution for data migration and integration. Chandar also did a great demonstration of the solution with Dynamics CRM and Dynamics GP.

Overview starts at time index - 4:01
Demonstration starts at time index - 14:23

More information about the solution can be found here -http://www.castiron.com/integration-solutions/ms-dynamics/index.html

Enjoy the show!

John O'Donnell Microsoft Dynamics ISV Architect Evangelist
Microsoft Corporation
http://blogs.msdn.com/jodonnell
http://blogs.msdn.com/usisvde
http://www.twitter.com/jodonnel

CRM Accelerators: Analytics

Girish Raja — Fri, 12 Dec 2008 01:10:00 GMT

Reuben decided to take control of things on this channel9 video as we discuss about the Analytics accelerator. <Alert> we recorded this video really early in the development cycle for this accelerator. There are far more cool capabilities and reports in the final version of this accelerator than what we see in this video. </Alert>

The analytics accelerator provides a set of Performance Dashboards and Key Performance Indicators (KPIs) for analyzing the data residing within the CRM platform. It utilizes SQL Server Analysis Services (SSAS) for creating OLAP cubes. SSAS is also used here for creating predictive analysis with some fully functional samples. The analytics accelerator will work with SQL Server 2005 with some components enhanced to take advantage of SQL Server 2008.

Check out more Channel9 videos on CRM Accelerators here and please visit http://www.codeplex.com/crmaccelerators to download the accelerators.

Happy coding!

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.