You are here

Feed aggregator

UNIT SOUZOU Brings Taiko Theater to Artist and Lecture Series

SPSCC Posts & Announcements - Thu, 05/14/2015 - 12:48

South Puget Sound Community College welcomes Portland-based taiko company UNIT SOUZOU as part of the college’s 2014-15 Artist and Lecture Series. UNIT SOUZOU will be on campus Thursday, May 14 at 7:30 p.m. at the Kenneth J. Minnaert Center for the Arts.

UNIT SOUZOU (pronounced SOH-ZOH), is the brain child of taiko veterans Michelle Fujii and Toru Watanabe. The co-directors share more than 20 years of experience, and have brought a fusion of traditional taiko and Japanese folk dance to UNIT SOUZOU. The performance is sponsored by the college’s Tomodachi club. The group will present their theatrically groundbreaking and imaginative work, “Insatiable.”

The South Puget Sound Community College Artist and Lecture Series brings a diverse group of distinguished scholars, activists and artists under a common theme: “Reflections.” Our presenters are recognized nationally or internationally for their work. Our hope is that they will initiate courageous and purposeful discussion within our community concerning critical and contemporary issues.

Tickets for UNIT SOUZOU are $10 for general admission, (which includes a $3 Washington Center service fee), and the event is free to all SPSCC staff, faculty and students. Tickets are available online at OlyTix.org or by calling The Washington Center for the Performing Arts box office at (360) 753-8586. For more information about the Artist and Lecture Series at South Puget Sound Community College, visit www.spscc.edu/ALSeries.

Posted 2-19-2015

Migrating Test cases in TFS 2013

MSDN Blogs - 2 hours 34 min ago
When you open your test cases in Excel the Actions column appear in a format other than rich text like below. Now when you plan to migrate the test cases using Excel, the Action/steps column remains the same [non - rich text format.] One way to migrate/copy the test cases with the columns intact [text format] for TFS 2013 is to use the Grid view in TWA. The below listed steps will help you with the process. NOTE: This is applicable only to TFS 2013 and above. The lower versions of TFS does not have...(read more)

Support for Multiple Outputs, Job Health Alerts, Improved Query Testing

MSDN Blogs - 3 hours 1 min ago
The Stream Analytics team is pleased to announce the release of several new features today.

 

Multiple outputs per job

As a response to strong feedback from ASA users, we have added support for multiple outputs in a single job.  This enables scenarios like alerting over incoming events while simultaneously archiving logs to long term storage.  You can access this feature by using the SELECT… INTO clause.

Alerting over job metrics

We know that alerting on job health is a critical feature for maintaining production pipelines over time, so we added functionality to create alerts over ASA job metrics.  When the value of a specified metric violates the threshold assigned for the alert rule, an email notification is sent.  Learn more about configuring alerts from How to: Receive Alert Notifications and Manage Alert Rules in Azure.

Improved query testing with actual input events

We have extended the existing in-browser query validation experience to enable query testing over actual job data.  This is exposed via the Sample Data feature, which downloads events from your job's input source in  JSON. The data can be used to test the query defined for the job in the Query Tab.

PartitionKey property for Event Hub output

You can now define an Event Hub PartitionKey field for your output events to determine which Event Hub partition the event will be sent to. 

Updated event ordering policy

In addition to the exiting options for events received by the Stream Analytics job out of order (Out of Order Tolerance Window), you can now specify how to handle events that are delayed in reaching the input source from the client via the Acceptable Input Source Arrival Delay.  Both settings are available on the Configure tab of your ASA job.

 

Thanks!

Thank you for your continued feedback on Stream Analytics. We look forward to hearing from you on the Stream Analytics Forum and Azure Feedback Forum. Stay tuned for more product updates coming soon!

Microsoft Automatic Graph Layout (MSAGL) is now on GitHub

MSDN Blogs - 3 hours 4 min ago

MSAGL is just an amazing piece of work. I’ve been using MSAGL for years in various projects – for example as part of my VisioAutomation work.

And now MSAGL is available to everyone on GitHub! https://github.com/Microsoft/automatic-graph-layout

Start cloning!

The API Economy: Consuming Our Web API from a Single Page App

MSDN Blogs - 4 hours 50 min ago

This post shows how to consume a Web API secured with Azure Active Directory using ADAL.js.

Background

This post is part of a series on building a SharePoint app that communicate with services protected by Azure AD.

As originally proposed in the post An Architecture for SharePoint Apps That Call Other Services, changing our architecture to use a Web API affords new possibilities for our application to enable secure communication from multiple types of clients.  One client for the Web API was our SharePoint app.  Another client can now be a Single Page App written using Angular.  Realizing there’s a ton of geekery that I’ve written on this, I put a big red arrow in the architecture diagram to show “You Are Here”.

 

To achieve this awesomeness, we will leverage the ADAL.js library.  In fact, you’ll see we are now at the point that we don’t have to really write much code at all to make this work.

The code for this post is available at https://github.com/kaevans/spapp-webapi-exchange, including the SPA and Web API projects.

Create the Web Application

I could do this with any platform since I am just using HTML and JavaScript files.  I thought about doing this in Eclipse using a Java application, but decided to just stick with Visual Studio.  In Visual Studio, create a new ASP.NET Web Application project.

On the next page, choose Empty.  This will generate a project with no content.

Change the project’s “SSL Enabled” property to True.  Remember we only exchange OAuth tokens over SSL, let’s be safe out there people.

Register the SPA App with Azure AD

Go to the Azure Management Portal (https://manage.windowsazure.com), go to the Applications tab for your Azure AD tenant, and choose Add to add a new application.

When prompted, choose “Add an application my organization is developing”.

Provide a name for the new application, and set the type to “Web application and/or Web API”.

On the properties page, provide the sign-in URL for the application, which is the SSL URL that you obtained when you created the web application.

The pieces of information you primarily need are (1) the client ID and (2) the APP ID URI.  The reply URL (3) and the sign-in URL (not shown) need to be updated once you deploy your application.

Scroll to the bottom of the page in the permissions section and click Add application.

In the next screen, choose your custom Web API.  Note: See the previous post A Sample SharePoint App That Calls A Custom Web API for details on how the Web API is built and how it is registered with Azure AD.

Once you’ve added the application, choose the permission and click Save.

Applications in Azure AD do not use the OAuth2 implicit flow by default, you have to add that capability by editing the manifest.  Download the manifest.

Change the oauth2AllowImplicitFlow value to true.

Manifest
  1. "oauth2AllowImplicitFlow": true,

You can see where to make the change in this screen shot.

Save the file locally, then upload it to the management portal by choosing the “Upload manifest” button for the application.

Create the SPA

I am going to use the SinglePageApp-WebAPI-AngularJS-DotNet sample from the Azure AD team as a starting point.  If you want more details on creating single page apps with Angular.js, go through that sample as there is some good information to be discovered there.  First, I add an HTML page “index.html” and add the following markup.

index.html
  1. <!DOCTYPE html>
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4.     <title>Mail SPA: a SPA sample demonstrating Azure AD and ADAL JS</title>
  5.     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
  6.     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css">
  7. </head>
  8. <body ng-app="mailApp" ng-controller="homeCtrl" role="document">
  9.  
  10.  
  11.     <div class="navbar navbar-inverse navbar-fixed-top" role="navigation">
  12.         <div class="container">
  13.             <div class="navbar-header">
  14.                 <button type="button" class="navbar-toggle collapsed"
  15.                         data-toggle="collapse"
  16.                         data-target=".navbar-collapse">
  17.  
  18.                     <span class="icon-bar"></span>
  19.                     <span class="icon-bar"></span>
  20.                 </button>
  21.                 <a class="navbar-brand" href="#/Home">ADAL JS Sample</a>
  22.             </div>
  23.             <div class="navbar-collapse collapse">
  24.                 <ul class="nav navbar-nav">
  25.                     <li ng-class="{ active: isActive('/Home') }"><a href="#/Home">Home</a></li>
  26.                     <li ng-class="{ active: isActive('/Mail') }"><a href="#/Mail">My Messages</a></li>
  27.                 </ul>
  28.             </div>
  29.         </div>
  30.     </div>
  31.     <br />
  32.     <div class="container" role="main">
  33.         <div class="row">
  34.             <div class="col-xs-10 col-xs-offset-1" style="background-color:azure">
  35.                 <div class="page-header">
  36.                     <h1>Exchange Demo SPA</h1>
  37.                 </div>
  38.                 <p>This sample demonstrates how to take advantage of ADAL JS for adding Azure AD authentication to your AngularJS apps.</p>
  39.             </div>
  40.         </div>
  41.         <div class="row">
  42.             <div class="col-xs-10 col-xs-offset-1">
  43.                 <div ng-view class="panel-body">
  44.  
  45.                 </div>
  46.             </div>
  47.         </div>
  48.         <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
  49.         <script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.2.25/angular.min.js"></script>
  50.         <script src="https://code.angularjs.org/1.2.25/angular-route.js"></script>
  51.         <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
  52.         <script src="App/Scripts/adal.js"></script>
  53.         <script src="App/Scripts/adal-angular.js"></script>
  54.         <script src="App/Scripts/app.js"></script>
  55.  
  56.         <script src="App/Scripts/homeCtrl.js"></script>
  57.         <script src="App/Scripts/mailCtrl.js"></script>
  58.         <script src="App/Scripts/mailSvc.js"></script>
  59. </body>
  60. </html>

Notice at the bottom of the page, we are referencing scripts in the App/Scripts folder.  I add a folder, “App”, and two subfolders “Scripts” and “Views”.

I copied adal-angular.js and adal.js from the SinglePageApp-WebAPI-AngularJS-DotNet sample into the Scripts folder.  I am not providing a code listing for those assets here. 

Let’s add two HTML pages to the Views folder.  The first, Home.html, is just used to let me know that the Angular routes are working. 

Home.html
  1. <div>
  2.     home sweet home
  3. </div>

The next HTML page will show our email messages.

Mail.html
  1. <div ng-init="populate()">
  2.     <p class="error">{{error}}</p>
  3.     <p>{{loadingMessage}}</p>
  4.             <div class="panel">
  5.         <table class="table table-striped">
  6.             <tbody>
  7.                 <tr data-ng-repeat="item in mailList">
  8.                     <td>
  9.                                                                         <p>{{item.From}}</p>
  10.                     </td>
  11.                     <td>
  12.                                                                         <p>{{item.Subject}}</p>
  13.                     </td>
  14.                 </tr>
  15.             </tbody>
  16.         </table>
  17.     </div>
  18. </div>

I add a JavaScript file called homeCtrl.js that will be the controller when on the home page.

homeCtrl.js
  1. 'use strict';
  2. angular.module('mailApp')
  3. .controller('homeCtrl', ['$scope', 'adalAuthenticationService','$location', function ($scope, adalService, $location) {
  4.     $scope.isActive = function (viewLocation) {        
  5.         return viewLocation === $location.path();
  6.     };
  7. }]);

Next I add an indexCtrl.js to handle any callbacks to the index page.

indexCtrl.js
  1. 'use strict';
  2. angular.module('mailApp')
  3. .controller('indexCtrl', ['$scope', 'adalAuthenticationService', function ($scope, adalService)
  4. {
  5.  
  6. }]);

Next we need a controller to display our email messages from our custom Web API. 

mailCtrl.js
  1. 'use strict';
  2. angular.module('mailApp')
  3. .controller('mailCtrl', ['$scope', '$location', 'mailSvc', 'adalAuthenticationService', function ($scope, $location, mailSvc, adalService)
  4. {
  5.     $scope.error = "";
  6.     $scope.loadingMessage = "Loading...";
  7.     $scope.mailList = null;
  8.  
  9.     $scope.populate = function ()
  10.     {
  11.         mailSvc.getItems().success(function (results)
  12.         {
  13.             $scope.mailList = results;
  14.             $scope.loadingMessage = "";
  15.         }).error(function (err)
  16.         {
  17.             $scope.error = err;
  18.             $scope.loadingMessage = "";
  19.         })
  20.     };
  21.  
  22. }]);

And finally the service that will call our custom API. 

mailSvc.js
  1. 'use strict';
  2. angular.module('mailApp')
  3. .factory('mailSvc', ['$http', function ($http)
  4. {
  5.  
  6.     //var apiEndpoint = "Enter the root location of your Mail API here, e.g. https://contosotogo.azurewebsites.net/";
  7.     var apiEndpoint = "https://localhost:44350/";
  8.  
  9.     $http.defaults.useXDomain = true;
  10.     delete $http.defaults.headers.common['X-Requested-With'];
  11.  
  12.     return {
  13.         getItems: function ()
  14.         {
  15.             return $http.get(apiEndpoint + 'api/mail');
  16.         }
  17.     };
  18. }]);

OK, that’s all our controllers and our one service.  Now we need to add the app.js that initializes everything.  Using the adal.js library and adal-angular.js implementation, we can simply provide the tenant and the clientId for our application.  The endpoints object lets us specify an external endpoints that will be called.  In this case, the Web API runs on a different port than our SPA application.  Additionally, we provide the APP ID URI for the Web API application registration in Azure AD (see the previous post A Sample SharePoint App That Calls A Custom Web API for details on how the Web API is built and how it is registered with Azure AD).

The App.js file uses the “requireADLogin” property on the Angular route provider to ensure that we are first authenticated before accessing the Mail view.

app.js
  1. 'use strict';
  2. angular.module('mailApp', ['ngRoute','AdalAngular'])
  3. .config(['$routeProvider', '$httpProvider', 'adalAuthenticationServiceProvider', function ($routeProvider, $httpProvider, adalProvider) {
  4.  
  5.     $routeProvider.when("/Home", {
  6.         controller: "homeCtrl",
  7.         templateUrl: "/App/Views/Home.html",    
  8.     }).when("/Mail", {
  9.         controller: "mailCtrl",
  10.         templateUrl: "/App/Views/Mail.html",
  11.         requireADLogin: true,    
  12.     }).otherwise({ redirectTo: "/Home" });
  13.  
  14.     var endpoints = {
  15.         
  16.         "https://localhost:44350/":
  17.         "https://kirke3.onmicrosoft.com/ExchangeDemoAPI",
  18.     };
  19.  
  20.     adalProvider.init(
  21.         {
  22.             tenant: 'kirke3.onmicrosoft.com',
  23.             clientId: 'c2b3f3bc-1b6a-4c17-8b89-b5e474dd3949',
  24.             extraQueryParameter: 'nux=1',
  25.             endpoints: endpoints,
  26.             cacheLocation: 'localStorage', // enable this for IE, as sessionStorage does not work for localhost.  
  27.             // Also, token acquisition for the To Go API will fail in IE when running on localhost, due to IE security restrictions.
  28.         },
  29.         $httpProvider
  30.         );
  31.    
  32. }]);

That’s all there is to our SPA application.  A few HTML files and some JavaScript and we are done.

Testing

To test the application, I changed the application startup projects to start just my Web API project and the SPA project.

I run the application, and it opens to the Home controller view.

Click the “My Messages” link in the navigation bar, and you are prompted to log in.  This is because the route provider has the property requireADLogin set to true.

Log in, and then we can see our email message.  This was a SPA application calling a custom Web API using OAuth, which then in turn calls the O365 Exchange Online API on behalf of the current user.

Summary

In case you didn’t see how incredibly cool that was, let me point it out as clearly as I can.  We just created an application that is purely HTML and JavaScript that enables the user to log on using Azure Active Directory, securely calls a custom Web API, and that Web API calls the O365 Exchange Online API on behalf of the current user to retrieve email messages. 

For More Information

Enabling Cross-Origin Requests in ASP.NET Web API 2

ADAL.js library

SinglePageApp-WebAPI-AngularJS-DotNet

OAuth Fiddler Extension – extension for Fiddler that enables you to inspect OAuth tokens.

https://github.com/kaevans/spapp-webapi-exchange – source code for this post, including the SPA and Web API projects

Small Basic Featured Art - Japanese Hina Dolls

MSDN Blogs - 4 hours 51 min ago

Today's art comes from Nonki Takahashi!

 

Over in the March Challenge's Forum thread, Nonki submitted this Community Challenge:

Community Suggestion (By Nonki)

  • Draw a picture of doll[s].

   

And here is Nonki's Submission:

This is my sample for community suggestion by Nonki: PPF232.

March 3 is Doll Festival (Girl's Day) in Japan.

   

What a beautiful drawing! Import the program or click to the Web view (PPF232) to see how Nonki coded it!

His background color is PeachPuff. =^)

 

GraphicsWindow.BackgroundColor = "PeachPuff"

 

Small and Basically yours,

   - Ninja Ed

7 Habits of Highly Motivated People

MSDN Blogs - 4 hours 56 min ago

Motivation is a powerful skill.

It can lift you up from the worst of places, and inspire you to new heights.

After all, nothing is worse than slogging your way through your days, or working your way through a bunch of mundane tasks.

But, like I said, motivation is a skill.

You need to learn it.   For many people it does not come naturally.   And chances are, many of us have had bad models, bad advice, and worse, bad habits for a lifetime.

One of the most important insights I found was said by Stephen Covey long ago – satisfied needs don’t motivate.

It’s why we need to stay hungry.

Here’s how you stay hungry -- find a problem you hate, and focus on creating a solution you love.

But how you light your fire from the inside out in a sustainable way?

That’s where the 7 habits of highly motivated people comes in.

I wanted to put together a very simple set of habits and practices that actually work for building your motivational muscle and finding your inner mojo.

Here are the 7 habits of highly motivated people at a glance:

  1. Find Your WHY
  2. Change Your Beliefs About What’s Possible
  3. Change Your Beliefs That Limit You
  4. Spend More Time In Your Values
  5. Surround Yourself With Catalysts
  6. Build Better Feedback Loops
  7. “Pull” Yourself with Compelling Goals

There is a lot of science behind the habits.  If you’re that motivated, you can research it through bunches of books, bunches of sites, and brilliant TED talks.

But, I’d much rather that you spent the time simply adopting and applying the habits, so you can set your motivation on fire.

It’s time to do more of what you were born to do.

It’s time to live and breathe the things that you want to live and breathe.

It’s time to rise again from whatever ashes might have burned you down, and let your phoenix fly.

If you aren’t sure where to get started, first read 7 habits of highly motivated people, and then adopt habit #1:

Find Your WHY.

You’ll be glad you did.

I can see your pilot light is on already.

Two hackathons—one city: creativity reigns in Austin, Texas

MSDN Blogs - 6 hours 5 min ago

Austin, Texas: capital of the Lone Star State, home to the Texas Longhorns, and host of not one but two Kinect for Windows hackathons in the past few weeks. We were blown away—like Texas tumbleweeds, you know—by the ingenuity and talent on display at these Austin events.

NUI Central Kinect for Windows Hackathon

Developers, UI/UX designers, and enthusiasts gathered in Austin for 24 hours of coding ingenuity using Kinect for Windows v2 on February 21. Austin Mayor Steve Adler kicked off the event, reminding everyone of Austin’s role as a technology hub and challenging the hackers to create their best innovations. Sponsored by Microsoft, the event was held at WeWork, a shared office space for startups; the venue offered a comfortable lounge and private offices for the hardworking devs, who coded through the night.


The WeWork offices in Austin’s Historic District provided an inviting space for all-night hacking.

All of that coding resulted in some truly innovative Kinect for Windows applications (and some bleary-eyed hackers). The output ranged from games to medical applications to productivity enhancers. It was tough to choose the winners, but, steeled in our resolve by some Texas-strength black coffee, our panel of judges selected the top three apps. Each winning team received a cash prize and Kinect for Windows v2 sensors.

First place went to AR Sandbox, an onscreen, augmented-reality playground based on the infrared data collected by the Kinect sensor. When users manipulated a hand-held infrared reflective cube, the cube’s onscreen image transformed into a rubber duck or puppy. The app also created virtual rainstorms of rubber ducks and puppies. The user was able to interact with the ducks and puppies as onscreen objects.

Coming in second was the Advanced Coma Patient Monitoring System, which is intended to keep watch on comatose patients, generating alerts and recording events to a video file.

The third-place winner was I'm Hungry, an app that integrates Kinect and Skype, allowing callers to play a mini-game during a Skype call.

Inspired by the resourcefulness on display at the NUI Central Kinect for Windows Hackathon, we were eager to get back to Austin for the SXSW Music Hackathon. Luckily, we had fewer than four weeks to wait.

SXSW Music Hackathon Championship

Wednesday, March 18, found the Kinect for Windows team back in Austin for the start of the 2015 SXSW Music Hackathon Championship, where world-class hackers, designers, and programmers competed to create innovations for musicians, the music industry, and, of course, the fans. With their programming know-how and a collection of music-tech APIs they could use, competing teams had 24 hours to work on their prototypes and compete for the $10,000 Grand Prize. Among the Microsoft APIs available to the hackers were the Kinect for Windows SDK and the recently released Microsoft Band SDK.

Developers got a chance to learn about the APIs and meet the sponsors before the hackers pitched their ideas to recruit team members. Once the teams were formed, everyone quickly set to work creating music innovations.

The Kinect v2 sensor and the Microsoft Band added a unique flair to the hackathon. Teams tested their apps throughout the night by dancing in front of the Kinect sensor—when they weren’t busy doing laps to check their heart rate with the Band. These Microsoft products brought an interactive element that intensified the energy level throughout the night.


The SXSW Music Hackathon Championship was a beehive of coding activity, as developers raced
the clock to create music apps.

Adding to the excitement of the late-night hackathon was a surprise performance by Boyfriend69, a talented entertainer who drew the developers to the front of the room, where she mingled and danced with them. Her show gave off a high-voltage vibe that kept the devs working through the night in true hackathon spirit.


Entertainer Boyfriend69’s surprise performance got the hackers up and mingling.

As dawn broke on March 19, the developers had fewer than eight hours to finish their projects before presenting them to qualify for the finals. While the last minutes of hacking ticked away, the teams feverishly polished their presentations. Here are the apps that emerged from the hackathon’s 24 hours of frenzied creativity:

App name

Description

Dandelion

This one-man team used Rdio and last.fm to create a QR code that aggregates listening data for display on an Apple Watch. When a user scans the code from another watch, Dandelion surfaces the song being listened to, using Rdio to play full songs or using other services to present 30-second previews.

MusicMap

MusicMap.io, an Austin-based team, is similar to Apple’s Meerkat app, but for music. MusicMap allows anyone to broadcast geo-tagged video and plot it on a map. With this service, users can discover new music from all over the world. MusicMap uses Stream.me as a live streaming service.

KYM

KYM (an acronym for Know Your Music), presented by Vince Davis, goes through the existing library on a user’s phone and gathers relevant information about the music by using APIs from various sources. Users can also hook up the app to Apple TV or the Apple Watch, so when they’re listening to music at home, the app shows relevant tweets from the artist.

SetStory

SetStory aims to solve a problem in festival logistics. Currently, no tool exists that quantitatively evaluates the potential of an event's success based on its artists. By using OpenAura to grab information from various social feeds, SetStory calculates a quantifiable score that gives festival promotors and organizers a reliable gauge of an event's financial viability.

Groupie

Groupie helps users find promising new artists in their local city. Users can also look at data from other cities, in case they want to discover the hot new bands from places near and far. Groupie uses the Rdio API to play the music and the Echonest API to look up the band's locale.

Bandarama

Bandarama is a workout tool that provides video and audio feedback on the user’s exercise performance. If you're running, for example, and your heart rate slows down, the tempo of the music will slow down, too, signaling you to pick up the pace. Team members Boris Polania and Guillermo Zambrano ran in circles around the room to demonstrate that once you start running faster again, the tempo of the music speeds back up and an applause sound effect provides extra motivation.

Divebomb

Divebomb uses the Kinect for Xbox One sensor to bring users into the music through virtual reality. As songs play, notes fly across the screen and the user can move his or her avatar to hit the notes as they race across the screen.

Mashr

Mashr takes two different songs and then mashes them together by using the Gracenote API. It also ties into the Musicnote API, which helps determine if two different songs will work well together.

(List and descriptions from William Gruger, social/streaming charts manager for Billboard)

The judges faced a tough job, as only five of these presenters would advance to the finals on Friday. But the intrepid judges were up to the task, selecting Bandarama, Mashr, MusicMap, KYM, and Dandelion to advance.

On Friday, a celebrity panel of judges, consisting of Ty Roberts (Gracenote), Alex White (Next Big Sound), Jonathan Dworkin (Warner Music Group), Bryan Calhoun (Blueprint), Eric Sheinkop (Music Dealers), Jonathan Hull (Facebook), Todd Hansen (SXSW), and Marc Ruxin (Rdio) reviewed the finalists’ projects and selected the winner.

Dandelion took top honors, winning the 2015 SXSW Music Hackathon and its $10,000 grand prize. But the big winners are music lovers, who will undoubtedly enjoy some of the great innovations created by the event’s hackers, sponsors, and artists.

Microsoft unveiled some exciting new APIs at the SXSW Music Hackathon. These included the Neon Hitch API, which enabled artist-in-residence Neon Hitch to close out herstage show with a Kinect v2-enabled creative visual accompaniment to her song “Sparks.” Meanwhile, artist-in-residence Robert DeLong worked with Ableton and Microsoft, two of the hackathon's major sponsors, to turn his body into an instrument, which he then used on stage during his shows, including his set at the YouTube space. Another novel API was DJ Windows 98, an homage to the long-gone Microsoft operating system. It used a vintage CRT monitor controlled by the audience via Kinect for Windows.

As we left Austin for the second time in less than a month, we carried away memories of the creative energy we witnessed at both the NUI Central Kinect Hackathon and the 2015 SXSW Music Hackathon Championship.

The Kinect for Windows Team

Key links


Five Use Cases for Visual Studio 2013 Community

MSDN Blogs - 6 hours 34 min ago

Visual Studio 2013 Community Edition is a fully featured version of Visual Studio free for small teams and open source development. Compared to the previously available free edition of Visual Studio (Express), the Community edition combines tools for Web, desktop, cloud and mobile development in one product, and adds support of Visual Studio extensions. With Visual Studio Community, developers can access thousands of extensions available in Visual Studio Gallery, such as Web Essentials, Cordova tools, ReSharper and others.

Who can benefit from this new edition of Visual Studio? Here are some scenarios.

Students

Visual Studio Community is free for students and provides all the tools they need to learn software development skills and master modern technologies. For example, Visual Studio can be used together with Microsoft Azure to explore Cloud computing capabilities, host private sites or use machine learning for researches.

Open source project developers

With Python, Node.js and JavaScript support, free Community edition is an excellent development environment for open source projects. The Python Tools for Visual Studio plugin supports editing, IntelliSense, local and remote debugging, profiling.

Indie game developers

Unity is one of the widely used 3D gaming engines, it is available in several editions, including free Personal edition and offers for educational institutes. Visual Studio 2013 Tools for Unity extension provides Unity integration that allows development and debugging of Unity games within Visual Studio.

    Mobile startup

Cross-platform development is a norm in the modern mobile world. With Cordova and Xamarin tools, developers can quickly prototype solutions and reach multiple platforms and wide audience. Cordova and Xamarin use different approaches for cross-platform development but both solutions provide deep integration with Visual Studio and rich development experience, including debugging and emulators support.

Small team of Web developers

Visual Studio Community is not just for individual developers. Small product development teams can use this edition together with Visual Studio Online to coordinate team activities, manage project backlog and run builds and continuous integration.

Your Turn

Do you use Visual Studio 2013 Community in a different scenario? Share your experience with the community!

Performance Tuning MySQL Database on Azure Linux VM’s

MSDN Blogs - 7 hours 12 min ago

 

Please tune these settings in your Test/Staging environments and simulate load to see if it increases performance. These settings should not be applied directly in Production environment.

In addition to the settings mentioned in below article:

http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-linux-optimize-mysql-perf/

You can also tune some of these settings to obtain higher performance if you are using Raid 0 (Following the instructions provided in above article) and are using innodb storage engine.

  1. You can use innodb_flush_method = O_DIRECT to get higher performance when using Raid 0 configuration with Azure Storage disks presented to your linux VM’s. On some flavors of Linux setting innodb_flush_method = O_DSYNC also can give you improved performance.
  2. You can use innodb_io_capacity to match with IOPS settings that Azure offers for Basic/Standard storage. IOPS limits for Basic Storage account is 300 IOPS and for Standard is 500 IOPS. If you are using multiple storage disks to configure your RAID 0, then you can stack your IOPS based on number of storage disks in the RAID group.
    1. For ex: if you have a VM which has 4 storage disks presented which are associated with Basic Tier Storage, you can get iops of 1200. (4 x 300 IOPS).
    2. If you have a VM which has 8 storage disks presented which are associated with Standard Tier Storage, you can iops of 4000. (8 x 500 IOPS).
    3. There is an option for premium storage as well which provides much higher IOPS. Please check this article for information on premium storage: http://azure.microsoft.com/en-us/documentation/articles/storage-premium-storage-preview-portal/#overview
    4. There is a limit to the number of storage disks that can be attached to a VM. Please refer to this document for disk limits: https://msdn.microsoft.com/library/azure/dn197896.aspx

Other settings that can be tuned when using innodb storage engine are below:

  1. You can play with innodb_thread_concurrency settings to get more performance when concurrent user count is high. Please refer to documentation provided here to play with this setting on your VM.
    1. http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_thread_concurrency
  2. You can set innodb_doublewrite = 0 when using a MySQL DB mainly for read heavy operations only. Setting this on a transactional database can lead to data integrity issues.
  3. You can set innodb_flush_log_at_trx_commit = 2, when using MySQL DB mainly for read heavy operations. Setting this on a transactional database can lead to it not being ACID compliant and hence lead to data integrity issues.
  4. Consider using innodb_file_per_table = 1 setting. This will force each table and its indexes into its own data file.

On Linux VM’s thread_concurrency setting has no effect. So you can comment out this setting.

Also consider having your data files and logs files on different file systems which are not on same storage drive. This will avoid IO contention for log writers and data writers on a database which is under heavy usage.

Please tune these settings in your Test/Staging environments and simulate load to see if it increases performance. These settings should not be applied directly in Production environment.

Flaw reported in Windows 95

MSDN Blogs - 8 hours 5 min ago

One of my colleagues ran across this old news clipping from 20 years ago today.

Flaw reported in Windows 95

THE ASSOCIATED PRESS

SAN MATEO, Calif. — Microsoft Corp.'s long-awaited Windows 95 operating system has a flaw that can freeze up computers when running certain applications, InfoWorld magazine said Friday.

The company is aware of the problem but is shipping 450,000 anyway as part of a preview program, the magazine said.

"I fear that unless Microsoft goes back to the drawing board on this operating system, only light users will get anything out of it," said Nicholas Petreley, the magazine's executive editor.

He said the system's inability to handle several types of sophisticated applications at the same time made it questionable for business use.

I can't find a copy of the original InfoWorld article online; all I can find are citations to it, like this one and this one.

The clipping had a handwritten note attached:

Bob, You guys may want to respond to this. Mom

The report was shortly followed by a rebuttal from Windows Magazine, pointing out that this was a beta release, it is not unusual that an unfinished product has bugs, and that a similar bug in an earlier beta was fixed within two weeks.

ZOMG! A beta product has a bug!

I found it cute that my colleague's mother chose to bring this article to her son's attention.

Microsoft and UK government continue to put the cloud first

MSDN Blogs - 8 hours 5 min ago

The UK government is a global leader in promoting public sector use of cloud technology and Microsoft is proud to support this endeavour at every step of the way. The government’s cloud-first policy ensured that government departments would opt for cloud tools as a first solution and Microsoft has long been a leader in the cloud productivity space. The government created the Digital Marketplace to ease the procurement process for buying cloud services. Microsoft was an early supporter of this initiative, and was the only global cloud provider to achieve Pan-Government Accreditation to “Official” for our cloud tools.

Today, the UK government and Microsoft are both working to advance a cloud-first vision of government technology. We’re an industry leader in conforming to the government’s 14 Cloud Security Principles, and the first to meet the ISO/IEC 27018 standard. Government services such as the Parliamentary Information and Communications Technology Service, the Department for Business, Innovation and Skills and more use our services and we continue to listen to feedback and improve our solutions to meet the needs of government. Working with Government Digital Service and other government departments, we are committed to enhancing the capabilities of Office 365 to meet government requirements, including the UK government Open Standards policy.

We’ve worked with GDS to understand the need to be able to create or import a document in another format and export it as ODF 1.2 and will be rolling out this new functionality to Office 365 in May. These changes ensure that Microsoft Office 365 will be compliant with the policy for sharing and collaborating on government documents and available for all public sector organisations.

Today, our UK Country Manager, Michel Van der Bel, met with the Cabinet Office Minister and Paymaster General, Francis Maude, to talk about these changes. 

Using Office Mix to create multi-media flash cards for revision

MSDN Blogs - 8 hours 35 min ago

Earlier today in our blog post covering some revision aids that might be useful to students and teachers over Easter in the run up to end of year exams, we suggested that using Office to add your own audio or video commentary to slides could be a handy way of helping the subject matter sink in.

To make things easier for anyone who is unfamiliar with Office Mix and how it works, we thought it would be worthwhile to point out that we have an eBook all about this fantastic PowerPoint add-on, put together with the help of Ollie Bray, head teacher at Kingussie High School:

Using Office Mix to Improve Learning from Microsoft Education UK

MIXing it up: Using Office Mix to Improve Learning details what Office Mix is all about, what features it includes, and how you can use it to add supplementary content to slides. This can be incredibly useful if you want to take a flash card style approach to your revision, with Office Mix allowing you to quickly prepare slides containing skeleton notes which you can then record audio or video over, for example. Not only will this save you time, but you can even play the audio in the background while you’re doing other things so that your revision notes can really ingrain themselves in your brain without have to be sat down at a desk!

We have a number of other educational eBooks available, just head over to our SlideShare and have a poke around :-)

We hope that Office Mix is a welcome addition to the way you go about studying both in the classroom and in private, and we’d love to hear of any innovative ways in which you are using it!

Using Office Mix to create multi-media flash cards for revision

MSDN Blogs - 8 hours 35 min ago

Earlier today in our blog post covering some revision aids that might be useful to students and teachers over Easter in the run up to end of year exams, we suggested that using Office to add your own audio or video commentary to slides could be a handy way of helping the subject matter sink in.

To make things easier for anyone who is unfamiliar with Office Mix and how it works, we thought it would be worthwhile to point out that we have an eBook all about this fantastic PowerPoint add-on, put together with the help of Ollie Bray, head teacher at Kingussie High School:

Using Office Mix to Improve Learning from Microsoft Education UK

MIXing it up: Using Office Mix to Improve Learning details what Office Mix is all about, what features it includes, and how you can use it to add supplementary content to slides. This can be incredibly useful if you want to take a flash card style approach to your revision, with Office Mix allowing you to quickly prepare slides containing skeleton notes which you can then record audio or video over, for example. Not only will this save you time, but you can even play the audio in the background while you’re doing other things so that your revision notes can really ingrain themselves in your brain without have to be sat down at a desk!

We have a number of other educational eBooks available, just head over to our SlideShare and have a poke around :-)

We hope that Office Mix is a welcome addition to the way you go about studying both in the classroom and in private, and we’d love to hear of any innovative ways in which you are using it!

Using Office Mix to create multi-media flash cards for revision

MSDN Blogs - 8 hours 35 min ago

Earlier today in our blog post covering some revision aids that might be useful to students and teachers over Easter in the run up to end of year exams, we suggested that using Office to add your own audio or video commentary to slides could be a handy way of helping the subject matter sink in.

To make things easier for anyone who is unfamiliar with Office Mix and how it works, we thought it would be worthwhile to point out that we have an eBook all about this fantastic PowerPoint add-on, put together with the help of Ollie Bray, head teacher at Kingussie High School:

Using Office Mix to Improve Learning from Microsoft Education UK

MIXing it up: Using Office Mix to Improve Learning details what Office Mix is all about, what features it includes, and how you can use it to add supplementary content to slides. This can be incredibly useful if you want to take a flash card style approach to your revision, with Office Mix allowing you to quickly prepare slides containing skeleton notes which you can then record audio or video over, for example. Not only will this save you time, but you can even play the audio in the background while you’re doing other things so that your revision notes can really ingrain themselves in your brain without have to be sat down at a desk!

We have a number of other educational eBooks available, just head over to our SlideShare and have a poke around :-)

We hope that Office Mix is a welcome addition to the way you go about studying both in the classroom and in private, and we’d love to hear of any innovative ways in which you are using it!

Columnstore Optimized Flat Cube in SAP BW

MSDN Blogs - 8 hours 41 min ago

With the general availability of SQL Server 2014, a new feature was released in SAP BW: The Columnstore Optimized Flat Cube. The prerequisites for the Flat Cube are described in in SAP Note 2114876 and in the following blog: http://blogs.msdn.com/b/saponsqlserver/archive/2015/01/08/sql-server-column-store-for-sap-bw-status-and-release-planning.aspx. The Columnstore Optimized Flat Cube is an alternative cube design, which is available as of SAP BW 7.4 SP 8 on Microsoft SQL Server. It uses the same simplified database structures as the HANA Optimized Cube.

Cube schemas

Data Warehouse systems typically store data in a Star Schema. A Star Schema consists of dimension tables grouped around a central fact table (resulting in a star):

Classic Star Schema (Non-SAP)

For performance reasons, there is typically a compound index on all dimensions of the fact table. This restricts the maximum number of dimensions of a cube to the maximum number of columns in an index. For rowstore indexes, the SAP Data Dictionary allows a maximum of 16 columns. Therefore SAP was not using this simple star schema in SAP BW.

 

SAP BW Extended Star Schema (rowstore optimized)

A dimension in a data warehouse, is called a characteristic in SAP BW. Since 16 characteristics are typically not sufficient for an SAP BW Cube, an additional layer was introduced: SAP BW Dimensions. By grouping characteristics in dimensions, an SAP BW cube can include hundreds of characteristics. However, the additional dimension layer results in additional joins for SAP BW queries. A dimension having only one characteristic can be defined as a Line Item Dimension in SAP BW. In this case SAP BW directly joins the characteristic with the fact tables (as for characteristic C5 in the example below). For improving query performance in the rowstore, SAP BW contains a second adaption of the Star Schema: two fact tables. While the f-fact table is optimized for data load, the e-fact table is optimized for reporting. The Star Schema adopted in SAP BW is often called SAP BW Extended Star Schema.

Flat Cube (columnstore optimized)

The optimizations of the SAP BW Extended Star Schema were introduced for optimizing the rowstore. When using the columnstore they are no longer necessary. There is no limitation on the number of index columns for a columnstore index. The clustered columnstore index contains all columns of the fact table. Therefore, SAP retired the Extended Star Schema starting with HANA. The resulting schema looks like a typical Star Schema, but SAP found a better name for it: HANA Optimized Flat Cube. For other database platforms the new schema is simply called a Flat Cube. Actually, the Flat Cube still contains a single dimension: the packet dimension. It is used for fast (logical) request deletion. However, all other dimensions are gone with the Flat Cube.

 

Unfortunately there is no consistent naming convention in the SAP community for cube schemas:

  • The newest schema is called Columnstore Optimized Flat Cube, HANA Optimized Cube or simply Flat Cube. Indeed it is identical with the classical Star Schema outside SAP. The only difference is the naming convention: What is called a dimension outside SAP is called a characteristic in SAP BW.
  • Since the SAP BW Extended Star Schema has been used in SAP BW for more than a decade, it is often also called Classical Star Schema or simply Star Schema. To distinguish from a Flat Cube, it is sometimes also called Non-Flat Cube
Using the Flat Cube

Once you have created a Flat Cube, you can use it just as a Non-Flat Cube. There is no need to change existing BW queries or BW process chains. However, there are a few restrictions:

  • Aggregates are not possible for a Flat Cube
  • A BIA index is not possible for a Flat Cube
  • BW partitioning (of the e-fact table) is not possible
  • BW Real-Time Cubes are not supported for Flat Cubes on Microsoft SQL Server

You can decide cube-by-cube which cube type to use. You can convert a Non-Flat Cue to a Flat Cube and vice versa. If you see the need for aggregates on a particular Flat Cube, you can convert this cube back to a Non-Flat Cube.

Although there is no e-fact table any more, you can still use BW cube compression. This also reduces the number of rows for a Flat Cube. The Reference Points of Inventory Cubes are also only available, if you perform BW cube compression.

Benefits

The absence of the dimension tables in a Flat Cube has many advantages:

  • Reduced disk space requirements

    In SAP BW there are several indexes on the dimension tables. On Microsoft SQL Server, the dimension tables always use b-tree indexes, even for columnstore cubes. Therefore the space usage of the dimension tables is significant. When using the Flat Cube you can save the disk space for the dimension tables.

  • Improved query performance

    With the Flat Cube an SAP BW query might still contain some joins (for attributes and hierarchies), but the joins for all dimension tables (except the packet dimension) are gone. Therefore, queries are simpler and faster, compared with Non-Flat columnstore cubes.

  • Improved data load performance

    Since there is no need to create DIMIDs, the data load into a Flat Cube is typically faster compared with a Non-Flat Columnstore Cube. However, this is not always the case. When re-loading the same data into a Non-Flat Cube, there is no need to create DIMIDs. Furthermore, the fact table of a Flat Cube contains more columns: one column per characteristic instead of one column per dimension.

     

The disk space usage of an SAP BW cube depends on may factors: The used cube type, number of dimensions, characteristics, and key figures. The following diagram shows the total disk space usage (fact table and dimension tables) of a sample cube using different cube types:

  1. BW Cube using rowstore with no database compression
  2. BW Cube using rowstore with PAGE compression
  3. BW Cube using read-only columnstore on e-fact table
  4. BW Cube using columnstore on f-fact and e-fact table
  5. Flat Cube

The sample cube contains 100,000,000 rows (with 90% in the e-fact table). The cube has 38 BW Characteristics, 11 BW Dimensions and 10 BW Key Figures

Documentation

The intention of this blog was to briefly introduce the concept of the Flat Cube. A detailed documentation will be published as an attachment of SAP Note 2116639 and in the SAP Community Network soon.

Tech Day 2015

MSDN Blogs - 8 hours 41 min ago
Microsoft Pakistan is committed toward the enablement of local IT Industry to the latest IT echo system. We at Microsoft deliver awareness sessions to the local software economy on latest Microsoft Technologies.

Microsoft Tech Day is one of several events in which we engage with local IT echo system and invite speakers to have detailed discussion on latest and upcoming Microsoft Technologies that results in the technical enablement of local developers and IT professionals.

This year, Tech Day is again planned across Pakistan and international speakers are going to showcase latest technologies.

The agenda for the Tech Day event is as follows.

 

 

 

Project Management and Service Industries Hotfixes Released in February 2015

MSDN Blogs - 9 hours 5 min ago

In this blog series I will be posting the hotfixes released for the Project Management and Accounting, as well as the Service Industries modules for Dynamics AX 2012 R2 and Dynamics AX 2012 R3 each month.

I will break these hotfixes down between the two releases. Keep in mind that a hotfix is released first on the build that the issue or design change is reported for. If you see a hotfix that exists in a different release, search for the hotfix by the KB number in Lifecycle Services to see if it exists for your build. If the hotfix does not exist in Lifecycle Services for your version, there's a strong chance that it is in the works of being developed for your build of AX. In that scenario, the recommendation would be to submit a new support request so we can track the need for the hotfix, and deliver the hotfix for your release of Dynamics AX 2012.

If you see a hotfix that you would like to download and test, please log into Microsoft Dynamics Lifecycle Services (https://lcs.dynamics.com) to review code changes, search for related issues, and download the hotfix for testing. If you are unfamiliar with Lifecycle Services, review the following blog for instructions on using Lifecycle Services to download a hotfix:

http://blogs.msdn.com/b/axsupport/archive/2013/12/13/using-lifecycle-services-to-download-hotfixes.aspx

If you have any questions about these fixes that cannot be answered by Lifecycle Services, please activate a new support request so our Project Engineers can assist you.

Watch for these posts each month, and I look forward to any comments!

Tyler Lewin
Senior Support Engineer
Microsoft Dynamics AX

 

Dynamics AX 2012 R2 

 KB 3040477 - If a vendor invoice with a project is using financial dimensions from the vendor instead of the invoice line when posting definitions are enabled, this will use the dimensions from the invoice line.

 KB 3040102 - This will enable the ability to correct project item requirement packing slips.

 KB 3038625 - If an error stating "Number sequence 0 does not exist" when eliminating and investment project to a fixed asset, this should ensure the number sequence is found.

 KB 3037026 - This will default the project category on supplemental items on a project sales order, resolving the error "The project category for this item is missing".

 KB 3040482 - If you post a credit note for an invoice that has been deducted by payment retention, this will insure the credit note for the invoice has correctly calculated amounts.

 KB 3041137 - If you have an "Opportunity" in sales and marketing that was entered by an employee that is terminated, this will allow you to edit the opportunity.

 KB 3040498 - This one will allow you to post project item transaction adjustments without an infolog stating "The iterator does not designate a valid element"

 KB 3040479 - This will allow hours forecasts to be entered with dates before before the project actual start date, preventing an infolog stating "Start date of project ____ cannot be updated since earlier hour forecasts exist".

 KB 3041167 - On a "Case" in the "Home" module, this will ensure only purchases orders and sales orders related to the association are displayed.

 KB 3038664 - This will exclude vendor invoices with "pay when paid" to be excluded from payment proposals.

 KB 3041637 - If a warehouse is defined as site specific order settings for sales orders, sales prices will be taken from trade agreements on item requirements after this hotfix.

 KB 3037297 - On a new "Party" record, this will allow the grid under the "Relationships" fast-tab to retain information on refresh (F5).

 KB 3042619 - If you personalize the "Posted project transactions" list page to add the field "Line property", this will allow filtering by that field, as well as insure the "Invoice status" on this list page populates for non-chargeable item and expense transactions.

 KB 3040767 - If the "Voucher transactions" form is not showing the entry for project adjustment transactions involving service items, this will correct this.

 KB 3041634 - On item requirements linked to purchase order lines with a receipt date not equal to the current date will ensure the item requirement posting uses the correct date.

 KB 3040101 - If you adjust sales tax by adding a sales tax transaction on a general journal, this will ensure the correct project sales price amount.

 KB 3037295 - This should resolve an error stating "Could not load file or assembly" on various pages in Enterprise Portal. 

 KB 3043003 - If the project timesheet parameter for "Require start/stop time" is checked, this will ensure that "External comments" are retained on the timesheet line's "Line details" fast-tab.

  

Dynamics AX 2012 R3

 KB 3042983 - If a worker is linked to a task in the work breakdown structure, this hotfix will ensure the workers assigned to a project remain on the project validation worker assignment form.

 KB 3042978 - From the "Posted project transactions" list page, if the "View voucher" button on the action pane shows transactions from another project, install this fix.

 KB 3038660 - This allows you to change the project contract ID on a project after item requirements are made, and avoids the error "Cannot create a record in Addresses (LogisticsPostalAddress)."

 KB 3042976 - If you see double tax lines on project budget status form, this should correct the tax postings.

 KB 3040761 - This will prevent the consumed posting method of project production from creating a negative line on project transactions if the "Report as finished" creates more items than started.

   

 

See the previous month's hotfixes here:

Project Management and Service Industries Hotfixes Released in January 2015

 

 

Unable to view Tracking records

MSDN Blogs - 9 hours 36 min ago

When attempting to query tracking data in the BizTalk Services Management Portal, I continually get errors and cannot retrieve the data.
The most common error returned says "An error occurred while retrieving tracking data".

The tracked data (storage and SQL) is not archived by default. Manual interventions is required to clean up the data.

If you are unable to get the tracking records on the Tracking portal, but the runtime environment is working fine, then most likely the tracking data has reached to a limit where it is causing the query performance issues.

The best way is to begin with purging the data as explained in the previous blog section - How to Manage Tracked Records

Even after cleaning the reasonable data, if you still continue to get error on the portal, check if you are able to query the SQL database directly.

You can use SSMS to connect to SQL Azure. To get details of the SQL Azure being used, you will need to go to Azure portal/click BizTalk Services. On the dashboard tab, you will see the SQL Azure Database being used for tracking. If you click the database name, it will take you to the database page. Click Dashboard. On the left you will see ‘Show connection string’. Click this and it will show you the database name and the user ID for the database.

Once connected, try running a simple query like Select * from TrackRecordProperties2. If this query is taking long time or not completing, it indicates you need to clean some more data.

For some of the customers’ the retention policy may add burden to the Tracking database or because of business volume even small number of days may contain a large amount of data. If data sizing guideline don’t go well with retention period, other option is to backup data to some other SQL server before purging from the tracking store till Tracking query performance is optimized.

Other option is to upgrade the SQL Azure server to premium edition which will provide more processing power to handle large tracking environments. The article below helps you understand move the database from Web/Business edition to New Service tiers.

http://azure.microsoft.com/en-us/documentation/articles/sql-database-upgrade-new-service-tiers/

Run the following query on the master database to retrieve the average DTU consumption for a database:

SELECT start_time, end_time
,(SELECT Max(v)
     FROM (VALUES (avg_cpu_percent)
                , (avg_physical_data_read_percent)
                , (avg_log_write_percent)
       ) AS value(v)) AS [avg_DTU_percent]
FROM sys.resource_stats
WHERE database_name = '<your db name>'
ORDER BY end_time DESC;

Here is a table that provides a mapping of the Web/Business resource consumption percentage to equivalent new tier performance levels:

Windows Phone Update Error codes

MSDN Blogs - 9 hours 55 min ago

These errors will be visible on the device in Settings > Phone update

Incorrect Date / Time (error 80072f8f)

If you receive Windows Update error 80072f8f while checking for updates, your device date and time might not be the same as the date and time for the online Windows Update service.

Check that your device date + time is correct. Sometimes it helps to ‘reset’ automatic date + time settings (off>on).

If you do not have a SIM card make sure that the manual selection is correct for your time-zone!

We are currently unable to check for updates (error 801881D3)

Currently we don’t know how to escape from this error except for restarting device and re-trying online check.
Changing Region may help.

Limited connectivity (error 80072ee2)

This error may be caused by Wi-Fi connection (firewall or otherwise limited connection)

    • Try to turn off the Wi-Fi and check for updates via 3G connection. Once updates are available turn the Wi-Fi back on and start the download

This error may also appear if your device Region is set incorrectly

    • Make sure that your device Region is set correctly to match the region you are currently in

Insufficient space for update (error 80188308)

Not enough space in system partition to continue the update

Probable scenarios:

  • Some system update like Cortana, language packs, OEM feature has taken up system partition space leaving less space to complete a phone update
  • Users are blocked until more space is made on the system partition or the update is made extremely tiny to fit the available space

The update could not be downloaded (error 801881d0)

    • Package could not be verified because of corrupt file. Very likely that the file download was stopped and started because of connectivity issues.
    • User should be able to retry by clicking on check for updates or session will auto expire and do another download in 6.2 days

An update was installed but cannot be opened (error 80188306)

    • After taking a backup (see top of this page) please perform a hard reset of the phone (settings>about>reset the phone)
    • Set up the phone again, without skipping any steps and update the phone again using a good Wi-Fi connection

Error "The Program can't start because MSVCR110.dll is missing from your computer"

  • This error appears when you wish to run a software which require the Microsoft Visual C++ Redistributable 2012. The redistributable can easily be downloaded from the Microsoft website as x86 or x64 edition. Depending on the software you wish to install you need to install either the 32 bit or the 64 bit version. Please refer to the following link: http://www.microsoft.com/en-us/download/details.aspx?id=30679#

Pages

Subscribe to Randy Riness @ SPSCC aggregator
Drupal 7 Appliance - Powered by TurnKey Linux