Customer Feedback SQL Server Content Samples

This post shows how to create an Excel task report from a “Data Explorer” query connected to a Windows Azure SQL Database instance provisioned with Access 2013. In Access 2013, you can create an Access web app. When Access 2013 provisions...

Before starting this post, I want to thank all of our customers for commenting about how much they love Data Explorer. Keep on giving us your feedback, we are reading your comments, and plan to create more tutorials based on your comments. In fact, please...

This post is an introduction to table relationship concepts as related to the Data Explorer Expand operation. The Expand operation makes combining data together really easy. One of the goals of efficient data management design is to remove duplicate...

I just published a step by step guide to publish and consume a Windows Azure WCF Data Service connected to an Azure SQL Database using Azure Access Control Service (ACS) claims-based authentication. The content has several lessons about exposing an...

Introduction In this tutorial you will learn the fundamentals of how to upload an Excel worksheet to Azure SQL Database using SQL Server Integration Services (SSIS). This tutorial assumes prior experience with SSIS and Windows Azure SQL Database. Upon...

As a continuation of my previous blog post , the AdventureWorks QueryFeed OData sample now shows how to implement Named Resource Streams to stream AdventureWorks product images. In addition, I added the ability to select Named Resource Streams (product...

I just updated the OData QueryFeed workflow activity sample . My original entity properties TablePartPublisherDesigner had style names hard-coded in the activity designer. This was okay to demonstrate the concept of an activity publisher. However,...

As a continuation of my previous blog post , I created an OData QueryFeed workflow activity sample. The sample represents an end to end data movement application utilizing a number of technologies including Using LINQ to project OData entity XML...

Overview As a continuation of my previous blog post , we created a live AdventureWorks OData feed at http://services.odata.org/AdventureWorksV3/AdventureWorks.svc . The AdventureWorks OData service exposes resources based on specific SQL views. The SQL...

This post introduces the AdventureWorks2012 OData service sample. This is our second sample that uses an agile approach to develop and deliver samples. During our first agile samples project , I learned how to write more concise user stories as follows...

Back in April, Susan Joly and I discussed applying agile principles to samples development and delivery. This first project in the overarching Agile Samples Development pilot project was designed to learn how to apply agile principles to samples development...

Iteration 3 shows how to sync a SQL Express LocalDB database containing Outlook contacts to a SQL Server instance using the Microsoft Sync Framework 2.1. OutlookSyncSQL Iteration 2 used a SQL Server Express 2012 instance; however, I decided to change...

The source code for the OutlookSyncSQL Iteration 2 sample is at http://msftdbprodsamples.codeplex.com/releases/view/87615 . First, I want to mention that sample iterations will have functional code; however, the sample will not be fully baked until...

Welcome to the SQL Server and SQL Azure samples blog. I’m a Technical Writer on the SQL Server Customer Experience team. Recently, I accepted the position at Microsoft because one of my passion is connecting with the customer. Hopefully, this blog...