How to publish Excel worksheets to Azure SQL Database using SSIS

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 completing this tutorial, you will have a sample database on Windows Azure published from an Excel…

0

AdventureWorks OData sample with Named Resource Streams

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 images) within a business workflow to the QueryFeed activity, and render a stream in a Word document. The AdventureWorks…

1

OData QueryFeed workflow activity (Refresh)

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, I wanted a way for the client hosting the workflow designer to supply style names for any TablePartPublisherDesigner.  After some research,…

0

Introducing the OData QueryFeed workflow activity

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 to entity classes. Creating custom workflow activities. Creating custom workflow designers containing OData schema aware expression…

0

Announcing the AdventureWorks OData Feed sample

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 views are a limited subset of the AdventureWorks database that results in several consuming scenarios: CompanySales Documents ManufacturingInstructions ProductCatalog TerritorySalesDrilldown WorkOrderRouting We will be…

1

AdventureWorks2012 OData service sample – Introduction

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: As a (persona) I want to (feature) so that (benefit) This sample will follow this…

0

Outlook Contact Data Sync Iteration 4

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 while hopefully delivering something of value to you, the customer. After identifying OutlookSyncSQL as our first…

0

Outlook Contact Data Sync with Microsoft Synchronization Framework – Iteration 3

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 code in iteration 3 to use SQL Express LocalDB. LocalDB provides for a smaller…

0

Outlook Contact Data Sync – Iteration 2

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 the final release. Therefore, the expectation is that iterations might not contain the same fit and finish as a final release. As a…

0

Introducing Agile Samples Development – Iteration 1

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 will help you apply SQL Server and SQL Azure samples to achieve results in…

2