Episode 209: Azure SQL Data Warehouse with Matt Usher | Microsoft Azure Cloud Cover Show

In this episode Chris Risner and Haishi Bai are joined by Matt Usher, Sr. Program Manager working on Azure SQL Data Warehouse.  Matt starts by talking through what SQL Data Warehouse is and how it differs from a SQL Database.  He then goes into some of the analytics and intelligence you can use with a Data Warehouse.  Matt demonstrates how to create a new Azure SQL Data Warehouse, connect to it, and then how to insert data, query against it, and change data routing and partitioning.  He also walks through connecting a SQL Data Warehouse to Power BI.  Finally, Matt reviews a few different security options you have when you using Azure SQL Data WarehouseLinks from the show:[00:52] - DataWarehouse vs Database[03:00] - Creating an Azure SQL Data Warehouse[05:17] - Connecting to SQL Data Warehouse with SQL Server Management Studio[07:22] - Distributed queries[11:50] - Creating views[14:20] - Using Power BI[19:00] - Data SecurityAzure SQL Data Warehouse landing pageLike Cloud Cover on Facebook!Follow @CloudCoverShowFollow @chrisrisnerFollow @haishibai2010 Follow @two_under 

Posted by on 1 July 2016 | 8:30 am

UWP App and the Azure IoT Hub

Want to play with the Azure IoT Hub but don't have an IoT device? Jon Gallant shows off a way you can do so with a simple UWP App, making it look pretty darn easy...How to Get Started with Azure IoT Hub and a UWP AppHere’s a quick post on how to get setup with Azure IoT Hub with a UWP App.  These steps and code taken from Olivier Bloch’s Build Talk:1. Create a new Azure IoT Hub – Free Tier – in Azure Portal http://portal.azure.com...2. Install the Azure IoT Hub Device Explorer Windows app – you’ll use this to view and send messages that come and go through the IoT Hub....3. In VS2015, create a new UWP app...4. Add a connection to your IoT Hub via References –> Add Connected Service...Open MainPage.xml.cs and add this code – receive and send messages to the IoT Hub vai the AzureIoTHub helper....Compile and Run the VS Project....Open the Data tab in Device Explorer and click the Monitor buttonWhen you want to send a message to the device, go to the Device Explorer, Messages To Devices tab, enter your message and click Send.That should get you going with a very basic connection between a UWP and IoT Hub.[Click through to read the whole thing]Follow @CH9 Follow @coding4fun Follow @gduncan411

Posted by on 1 July 2016 | 8:00 am

Kinect to Coordinate Mapping with help from Vitruvius

The one and only Vangos Pterneas is back (I'm telling you, he makes this job easy for me ;) with a new project, one that I see asked about all the time... Coordinate MappingKinect Coordinate Mapping – The Easy WayA few months ago, I had published a detailed guide about converting between Kinect’s 3D and 2D coordinates. Today, I’m going to show you how to accomplish Coordinate Mapping with minimum effort and only one line of C# code!BackgroundKinect understands the 3D space using an infrared sensor and a depth processor. The depth processor can measure the distance between the physical points and the device. Kinect SDK uses a structure named CameraSpacePoint to represent a point in the physical 3D space. A CameraSpacePoint is a set of three properties [X, Y, Z]. X is the distance in the horizontal axis, Y is the distance in the vertical axis, and Z is the distance (depth) between the point and the plane of the sensor.The values are measured in meters. So, the CameraSpacePoint [1.5, 2.0, 4.7] is located 1.5 meters from the left, 2.0 meters from the top, and 4.7 meters from the sensor.1 meter = 3.28 feet1 meter = 39.37 inchesThis concept is illustrated in the figure below:However, when we develop a Kinect app, we use computer monitors. Somehow, we have to project the 3D points on the 2D screen space. There are 2 screen-spaces:Color Space: 1920×1080 pixelsDepth/Infrared Space: 512×424 pixelsObviously, points in the 2D space only have X and Y values, measured in pixels.So, we have to convert meters to pixels! How’s that possible? I have thoroughly explained this process in my blog post Understanding Kinect Coordinate Mapping.Coordinate Mapping is the native process of converting between the 3D and the 2D space.3D spaceUsing Vitruvius, Coordinate Mapping is as simple as typing one line of C# code. Let’s have a look at an example:var position = body.Joints[JointType.Head].Position;This is how we find the position of the Head joint using the official Microsoft SDK. The point3D variable is a [X, Y, Z] combination. It indicates where the head of the person is located.Projecting the 3D point to the 2D space is accomplished using Vitruvius’ ToPoint method. That method takes a Visualization enumeration as a parameter. To use the ToPoint method, you first need to import Vitruvius in your project:2D Color Space (1920×1080)This is how to convert the 3D point to a 2D point in the 1920×1080 Color Space:...2D Depth Space (512×424)Similarly, you can convert the 3D point to a 2D point in the 512×424 Depth Space:...Using a different Coordinate MapperIn case you are using multiple Kinect sensors, you can still work with Vitruvius! You simply have to specify which sensor the method should use:...You can access it by downloading Vitruvius.Download Vitruvius ‘Till the next time, keep Kinecting!Project Information URL: http://pterneas.com/2016/06/23/kinect-coordinate-mapping-vitruvius/Project Download URL: http://vitruviuskinect.com/Contact Information:Blog: http://pterneas.comFollow pterneasFollow @CH9Follow @Coding4FunFollow @KinectWindowsFollow @gduncan411

Posted by on 30 June 2016 | 8:00 am

Video Spotlight - Sage X3 App on Windows 10 for SMBs

Interested in seeing how Microsoft technologies such as Windows 10, Microsoft Azure and Office 365 are transforming commercial industry solutions in Retail, Hospitality, Financial Services, Healthcare, Manufacturing, Public Sector and more?  Check out the LaunchPad Series on Channel 9 where you will find creative and powerful line of business (LOB) apps built by Microsoft's ISV partners from around the world.In this episode, Baldwin Ng, WW Windows Apps Lead from Microsoft was joined by Laura Fraser (Vice President of Strategic Alliances) and Zach Bellhy (Solution Engineer), where they shared how the Sage X3 app on Windows 10 is transforming how Small and Midsize Businesses (SMB's) conduct their daily businesses - from customer relationship management to business expense tracking - powered by the Windows 10 OS and Surface Pro 4 devices.Don't forget to view the full video to catch the special trial offer for X3 and win a chance to bring home 1 of the 3 Surface Pro devices today!* Learn more about Sage X3:                        http://SageX3.com* Join us at Sage Summit in Chicago:           http://www.sage.com/Sage-Summit* View other LaunchPad ISV app videos       http://aka.ms/LaunchPad

Posted by on 29 June 2016 | 11:32 pm

Getting Started with Xamarin | Visual Studio Toolbox

In this episode, Robert welcomes James Montemagno back to the show to talk about how you can get started developing with Xamarin. James shows exactly what you need to get started building mobile apps with Xamarin including the hardware required and software you need to install. He then shows how to leverage your existing .NET and C# skills to create iOS, Android and Windows mobile apps in Visual Studio with Xamarin. He also shows how to reuse existing .NET libraries and share business logic across apps.Resources:Get StartedVisual Studio Dev EssentialsJames on TwitterJames on GitHubJames's Surface Book Setup Guide 

Posted by on 29 June 2016 | 10:39 am

Developing for the Microsoft Band with Charles Stacy Harris III

Jennifer Marsman speaks with Charles Stacy Harris III about developing for the Microsoft Band.  They discuss the capabilities of the Band: the sensors it contains, tiles, notifications, Bluetooth, haptics, and the Microsoft Health app for management.  Learn how to get started with the Microsoft Band and several compelling use cases for making it shine. 

Posted by on 28 June 2016 | 11:05 pm

How to Apply Deep Learning to Real-World Problems

Deep Learning is a new area of Machine Learning research, which has been introduced with the objective of moving Machine Learning closer to one of its original goals: Artificial Intelligence.Join Jennifer Marsman as she welcomes Sonja Knoll to the show as they take a deep dive into Deep Learning as well as apply some real-world scenarios for you to try out on your own.Looking for more information? Check out the following links below:Deep Learning – give it a try! Try the app http://CaptionBot.ai – works for any browser/phoneCall the Microsoft Cognitive Services API https://www.microsoft.com/cognitive-servicesBuild you own cool deep model on CNTK https://github.com/Microsoft/CNTKDeep Learninghttp://www.deeplearningbook.orgCNNGeneralization and Network Design Strategies by Lecun, Y., Technical Report CRG-TR-89-4, University of Toronto, 1989RNNLearning representations by back-propagating errors by Rumelhart, D., Hinton, G., and Williams, R., Nature 323, 533–536, 1986Blog: The Unreasonable Effectiveness of Recurrent Neural Networks by Andrej KarpathyLSTMLong Short-Term Memory  by Hochreite, S., and Schmidhuber J., Neural Computation 9(8): 1735-1780, 1997Blog: Understanding LSTM Networks by Christopher Olah____________________________________________________If you're interested in learning more about the products or solutions discussed in this episode, click on any of the below links for free, in-depth information:Websites & Blogs:Jennifer Marsman’s BlogLearn more about Microsoft Cognitive Services Follow the conversation @MS_ITPro Become a Fan @ facebook.com/MicrosoftITPro Subscribe to our podcast via iTunes, Stitcher, or RSS

Posted by on 28 June 2016 | 3:00 pm

Tuesdays with Corey: A chat with Erica Brescia - COO of Bitnami | Tuesdays With Corey

Corey Sanders, Director of Program Management on the Microsoft Azure Compute team sits down to chat with Bitnami Chief Operating Officer Erica Brescia. They talk about how Azure has partnered with Bitnami to support hundreds of images migrated from VMDepot over to Azure Marketplace AND how Bitnami is eliminating the complexity of configuring your own software stack by providing updated / ready made images for anyone to use in the cloud. Don't forget - we're always looking for Suggestions and Questions here in the comments section OR via twitter #AzureTwC. You never know - you might make it to an upcoming episode and be a virtual star of the show - like THIS one!Post any questions, topic ideas or general conversation here in the comments OR online on via Twitter.Follow @EricaBresciaFollow @CoreySandersWAFollow @RicksterCDN 

Posted by on 28 June 2016 | 11:07 am

Business Glossary in Azure Data Catalog | Data Exposed

This week's episode of Data Exposed welcomes Sandhya Vankamamidi, a Senior Program Manager in the Cortana Intelligence and IML group. Today Sandhya follows up on the Azure Data Catalog Data Discovery video with Matthew Roche earlier this month to talk about Business Glossary in Azure Data Catalog. Sandhya first provides a background into the need for the glossary and the challenges businesses have when working with data sources and naming conventions across departments and organizations. To solve this, Sandhya provides insight into Business Glossary in Azure Data Catalog, which is the capability to define a taxonomy for your business for standardized naming conventions across terms. Sandhya reminds us of the primary object of the Data Catalog and then provides valuable insight into how Business Catalog provides a hierarchy of terms to make working with different datasets much easier. At the 8:35 mark Sandhya jumps right into an awesome demo and spends the rest of the show getting us familiar with how Business Glossary works. She first walks us through the user experience, how to enable Business Glossary by moving to the paid sku, how to create and configure a Glossary, how the different users work with the Glossary, and how we can apply that Glossary to available Data Catalog data sources through the use of tags. Sandhya shows us how easy and fluid the user experience is and how easy it is to work with a glossary! Great stuff! https://azure.microsoft.com/en-us/documentation/services/data-catalog/ http://azure.microsoft.com/

Posted by on 28 June 2016 | 10:00 am

Pen and Ink | Context

They said it couldn't be done ;) but we're back with another episode of 'Context' where this time we're looking at digital ink and digitised pens.Inking has long been a focus of Microsoft and the modern platform built around DirectInk and the InkCanvas control provides a great experience for the user while being the most performant, most capable inking platform we've built and yet it also has a low barrier to entry for the developer.In this show, we spend time on InkCanvas and what it can do for you having spent a little time reviewing how we used to do things and why InkCanvas is better. We'll also look at a couple of things coming in inking for the Windows 10 Anniversary Update.Here's a breakdown of the show;[00:48] Welcome to the show - Pen and Ink.[05:00] Vox Pops[06:03] Show Me The Code[36:58] CTRL-Z[41:45] Readme.txtShow Notes;Windows 10 and UWPMSDN on Pen and StylusDirectInk at Build 2015DirectInk at Build 2016Win2D Sample on Custom Ink DryingThe Code  

Posted by on 27 June 2016 | 2:34 pm

Christos Matskas on Open Source and Community | NDC London 2016

In this video I had the chance to speak with Christos Matskas a long time developer turned Azure Developer Engineer helping teams to get the best out of the cloud. Christos speaks about his upcoming NDC talk Open Source, why OSS is now the hot new subject in the developer community and why you should care about it.

Posted by on 24 June 2016 | 5:01 pm

(Part 5) Microsoft Azure for Amazon AWS Cloud Professionals: Migrating to Azure | TechNet Radio

Concluding our Microsoft Azure for Amazon AWS Cloud Professionals series, Keith Mayer and Gerald Tiu shows us three ways to migrate to Microsoft Azure.[1:24] Do you have control over code deployment? If not, how do you go about migrating Linux workloads to Azure?[27:30] DEMO: Using Azure Site Recovery to migrate Windows VMsAdditional ResourcesStep-by-Step: Migrate Linux VMs from Amazon AWS to Microsoft AzureStep-by-Step: Migrate Windows VMs from Amazon AWS to Microsoft AzureMigrate Windows VMs from Amazon AWS to Microsoft Azure using Azure Site RecoveryTransfer data with the AzCopy Command-Line UtilityIntroducing the Azure Storage Data Movement LibraryPlanning for Costs with Microsoft Azure Pricing CalculatorCreate your FREE Azure Account with $200 in Cloud CreditLearn and Explore the Microsoft Cloud with a FREE IT Pro Cloud Essentials SubscriptionIf you're interested in learning more about the products or solutions discussed in this episode, click on any of the below links for free, in-depth information:Websites & Blogs:Keith Mayer's BlogCloud Solutions HubBuilding Clouds blogIT Pro Cloud Essentials Follow the conversation @MS_ITPro Become a Fan @ facebook.com/MicrosoftITPro Subscribe to our podcast via iTunes, Stitcher, or RSS

Posted by on 24 June 2016 | 11:35 am

Add Windows Containers behind Docker Swarm Cluster - Part 2

In the second part of the Docker Swarm series, Dongluo Chen continues his demonstration and shows us how to provision containers on both Windows and Linux using Swarm.Find a topic:[00:19] How to add Windows node to a swarm cluster?[01:31] Demo - How to add Windows Server 2016 as worker node behind swarm cluster?[03:50] How to create a windows server container instance through the swarm cluster?[04:58] Demo - How to create a new container instance on Windows Server 2016 through the swarm cluster?[06:19] How to get started?Get started:Watch the Running Docker Swarm on Microsoft Azure - Part 1 videoLearn more about Docker Swarm Take the next steps:Create clusters using the Azure Swarm templateDeploy Azure ACS + Swarm templateWhat do you think? Send us an email, comment below in the comments area on Channel 9, or tweet us at @TheOpsTeam Follow @TheOpsTeamFollow @DTzarFollow @dongluochen

Posted by on 23 June 2016 | 7:26 pm

.NET Fringe 2016, the OSS event you don't want to miss | .NET Fringe 2016

In this video I had the privilege of talking to Glenn Block, Troy Howard and Adron Hall about the upcoming .NET Fringe event in Portland. They discussed the spirit of the event, why it is different, why you should be there, and how it will be run..NET Fringe (@dotnetfringe)Glenn BlockTroy HowardAdron Hall 

Posted by on 16 June 2016 | 6:21 pm

//build/London Session: Azure IoT | Build Tour London 2016

//build/London Session: Azure IoT

Posted by on 12 June 2016 | 10:09 am

The Future of the Web | //build Canada: LIVE from Toronto

Wes Bos, developer of the extremely popular React for Beginner's video series, Alex Blom, partner at the IsleOfCode Ember shop in Toronto, Steve Fisher, designer and UX fanatic at the Republic of Quality, and Stacey Mulcahy, JavaScript and Node hacker extraordinaire, get together for a live, opinionated discussion on the future of front-end web frameworks and dev tools. Moderated by Rami Sayar, these experts will explore the future of web dev tools in addition to npm, Grunt, Gulp and Webpack; the future of cross-platform app frameworks now that React Native supports UWP, iOS, Android; and will compare and contrast building complex apps with tools such as Visual Studio Code with Electron and React Native.

Posted by on 7 June 2016 | 10:41 pm

.NET Conf Day 2 Keynote - Miguel de Icaza | dotnetConf 2016

Kick off Day 2 with Miguel de Icaza as he sets the stage for the day and walks us through .NET innovations for mobile and desktop developers including Xamarin and the Universal Windows Platform.

Posted by on 24 May 2016 | 2:38 pm

Bart De Smet at Techorama 2016 | Techorama 2016

Bart De Smet is a Principal Software Development Engineer working on large scale stream processing systems in the Applications and Services Division at Microsoft Corporation, a course and book author, and a popular speaker on various international conferences. In his current role at Microsoft, he's overseeing the architecture, design, and implementation of event processing systems that run at massive scale in data centers, as well as on cloud-connected devices. One of the publicly visible technologies powered by this infrastructure is Cortana. Prior to joining the Applications and Services Division, Bart was involved with the design and implementation of Reactive Extensions for .NET (Rx) and on an extended "LINQ to Anything" mission back in the SQL organization. Going even further, you could have found Bart in the Developer Division hacking away on the Application Model feature area in the Windows Presentation Foundation (WPF) in the .NET 3.5 and 4.0 days. His main interests include programming languages, runtimes, functional programming, and all sorts of theoretical foundations. Before joining the company, Bart was a C# MVP for four years, while completing his Master of Civil Engineering and Computer Science studies at Ghent University, Belgium. Bart is also the author of the C# 5.0 Unleashed book (and its predecessor) by SAMS, and an author of online courses at Pluralsight for topics such as C# language internals.

Posted by on 23 May 2016 | 9:30 am