Benko Blog vNext

Originally posted on: http://geekswithblogs.net/benko/archive/2013/10/08/string-formatting-expressions.aspx

One of the things that it seems like I am often looking up is how to use String.Format to display values in my applications. I’ve found that while Visual Studio in some situations such as WPF XAML editing has features built in, in other cases it is lacking. For that reason I wanted to post a table with some of the more common expressions.  I found this useful, hopefully you will too.

Basic numeric formatting 

Custom formatting

Date formats 

Custom Date formatting 

Originally posted on: http://geekswithblogs.net/benko/archive/2013/08/26/how-to-restrict-a-cloud-service-to-a-set-of.aspx

An interesting question today about securing Cloud Services in Windows Azure. Basically how do we restrict who has access to our service? The confusion comes from a couple types of endpoints available in the Service Definition. InputEndpoints are publically visible and may be load balanced. InternalEndpoints are hosted on the 10.x.x.x subnet and are visible to other roles in our service definition.

To restrict by IP address requires that we add a Startup section to the Service definition file to unlock the ipSecurity section of the Web.config file and then add the address we want to restrict or allow. When the service deploys and starts up it will run the cmd file. Inside the cmd file (startup.cmd) we’d add script with 2 commands like this:

UPDATE: added the PowerShell command to add the feature to IIS

    PowerShell Install-WindowsFeature –Name Web-IP-Security
    %windir%\system32\inetsrv\AppCmd.exe unlock config /section:system.webServer/security/ipSecurity

Add it to our project and mark the file to copy always during deployments (in the properties of the file). Then in the service definition file for the Cloud Service add a Startup Task to run the cmd file in an elevated mode:

<Startup>
   <Task commandLine=”startup\startup.cmd” executionContext=”elevated” />
</Startup>

Then in the web.config file add a section to the system.webServer that opens up the IP’s we want to allow.

<system.webServer>
    <security>
    <!—Unlisted IP addresses are denied access–>
        <ipSecurity allowUnlisted=”false”>
            <!—The following IP addresses are granted access–>
            <add allowed=”true” ipAddress=”192.168.100.1” subnetMask=”255.255.0.0″ />
            <add allowed=”true” ipAddress=”192.168.100.2″ subnetMask=”255.255.0.0″ />
        </ipSecurity>
    </security>
</system.webServer>

Alternately we could use InternalEndpoints if the communications will be only between roles in our service.

Enjoy!

Originally posted on: http://geekswithblogs.net/benko/archive/2013/07/23/a-starting-point-for-use-cases-and-user-stories.aspx

Software is a challenging business and is rife with opportunities to go wrong. Over the years a number of methodologies have evolved to help make sure that things go right. In an effort to contribute to this I’ve created a list of user stories that I think should be included and sometimes are just assumed. Note this is a work in progress, so I’m looking for your feedback. I’m curious what you would add or change in my list.

· As a DBA I am working with a Normalized data model that reflects an agreed upon logical model for the system

· As a DBA I am using consistent names for my fields which match the naming standards of my organization

· As a DBA my model supports simple CRUD operations against all the entities

· As an Application Architect the UI has been validated against the Business requirements and a complete set of user story’s have been created

· As an Application Architect the database model has been validated against the UI

· As an Application Architect we have a logical business model that describes all the known and/or expected usage of the system during the software’s expected lifecycle

· As an Application Architect we have a Deployment diagram that describes how the application components will be deployed

· As an Application Architect we have a navigation diagram that describes the typical application flow

· As an Application Architect we have identified points of interaction which describes how the UI interacts with the services and the data storage

· As an Application Architect we have identified external systems which may now or in the future use the data of this application and have adapted the logical model to include these interactions

· As an Application Architect we have identified existing systems and tools that can be extended and/or reused to help this application achieve it’s business goals

· As a Project Manager all team members understand the goals of each release and iteration as they are planned

· As a Project Manager all team members understand their role and the roles of others

· As a Project Manager we have support of the business to do the right thing even if it is not the expedient thing

· As a Test/QA Analyst we have created a simulation environment for testing the system which does not use sensitive data and accurately reflects the scenarios of all the data that will be supported by the system

· As a Test/QA Analyst we have identified the matrix of supported clients used to access the system including the likely browsers, mobile devices and other interfaces to work with the application

· As a Test/QA Analyst we have created exit criteria for each user story that match the requirements of the business story that was used to create them

· As a Test/QA Analyst we have access to a Test environment that is isolated from production and staging environments

· As a Test/QA Analyst there we have a way to reset the environment so we can rerun tests when a new version of the software becomes available

· As a Test/QA Analyst I am able to automate portions of the test process

Thoughts?
-mike

Originally posted on: http://geekswithblogs.net/benko/archive/2013/02/18/azure-office-hours-are-backhellip.aspx

We’re back! Scott Klein (http://www.scottlklein.com) and I are kicking off a new series of weekly Office Hours to help developers find answers to tough questions. Similar to what we did over the last couple years when I was at Microsoft we will have guests each week who can help us dive into a technology. The link to put in your questions and to register for the live show (as well as see recordings from past ones) is www.benkotips.com/OfficeHrs.

This week we’ve got Josh Twist, who introduced the world to Windows Azure Mobile Services at Build 2012 last fall.

Josh is a Program Manager on the Windows Azure team and was the first full-time member of the Mobile Services project. He has worked at Microsoft for 6 years, the first 4 years as a consultant in the UK, before moving to the mothership in Redmond, WA - with the goal of building awesome products and a focus on experience. Josh is passionate about Mobile and enjoys all the fruits of the computing garden, with a house laden with computers and gadgets running everything from iOS and Mac OSX, Android, Linux and Windows.

Join the call, ask the questions and find out more every Friday at 9 am PST.

Originally posted on: http://geekswithblogs.net/benko/archive/2013/02/06/how-to-get-the-current-build-version-in-a-windows.aspx

Sometimes you spend a lot of time searching online for an answer, but the truth is that it’s a lot easier just to open up the debugger, spend a few minutes, and find it yourself. In the context of today’s lesson I am working on a Windows 8 application that needs to display the product build number in the About page in the application settings.

I was able to find several documents online that worked for WPF and WinForms application but not much for Windows 8 Store apps which have the limitation of the sandbox they run in. System.Reflection is available, but there doesn’t appear to be an easy way to get to the currently executing assembly to pull the version information from, but I found it in the ApplicationModel.

The code I used to pull out the build version is this:

  string myBuild = Windows.ApplicationModel.Package.Current.Id.Version.Build.ToString()
      + "." + Windows.ApplicationModel.Package.Current.Id.Version.Major.ToString()
      + "." + Windows.ApplicationModel.Package.Current.Id.Version.Minor.ToString()
      + "." + Windows.ApplicationModel.Package.Current.Id.Version.Revision.ToString();

  txtVersion.Text = "Version: " + myBuild;

Simple. Happy coding!

Originally posted on: http://geekswithblogs.net/benko/archive/2013/01/27/getting-wiredhellip.aspx

The idea is to take the bag of parts, follow the instructions and you get a guitar amp in a cigar box. Now I’ve been building boxes for a while from various kinds of hardwood and I thought it would be fun to give it a whirl.

Starting with the circuitry
Not being an electrical engineer, but more on either the mechanical side and/or the computer code side of things I’ve been more hands off on diving into circuits and resistors type of things. This seemed like a good project to learn it, so I ordered a soldering iron from Amazon – '>'>'>Hakko FX-888. This is a decent soldering iron with a temperature control thing that John recommended. At the same time I stopped at Radio Shack to pick up some kits to try out my soldering skills. These were simple circuits, but cheap enough that I could use them for practice.

After putting that together it was time to start with the real deal. The Stella Amp consists of a bag with 15-20 resistors, a couple diodes, about a dozen capacitors and a couple chips. I’m not deep on understanding why the parts work the way they do, but I spent an evening soldering the kit together and was able to get it to work in the end. One piece of advise is to take your time, invest in a multimeter to be able to check your progress.

After working with it I plugged in the battery and got a 1/4” cable to my guitar and tried it out. It took a little jiggering of the rheostat’s and I had a loose connection to the battery, but I got it to work. Next I need something to put it in.

The Box
I chose to make the box from Cherry and Paduka (a wood with a deep red color), and follow a cigar box style design that includes a sliding lid. To make this you need something that can resaw the lumber to 1/4” stock, then a table saw to cut the finger joints, and some patience. I have a 12” planer that I use to cut down the stock after resawing it to about 3/8”. To get the red line I glue up the board with a 1/4” Paduka strip before resawing.

The fingerjoints are cut with a jig I put together which has a notch on the crosscut that is 1/4” off from the blade on the tablesaw. I also used the table saw to cut the lids so that there’s a 1/8” lip on the lid that fits into a corresponding slot on the box.

Putting it together
To mount the circuitry into the box took a little bit of work. One limitation was the depth of the threads on the rheostats and the input jack of 1/4” meant I needed to sand down the thickness of the front of the box enough to be able to put the washer and nut on. Fortunately it was something that just took some time to get it to fit. The end result is pretty nice.

Conclusion
This was a project that was outside what I’ve done before. The woodworking is nothing I haven’t done before, but getting circuitry to come together and actually work when I plugged it in still makes me smile. It goes to show that sometimes you have to take a leap of faith when you want to try out something new. The result is pretty cool…maybe a presentation at a code camp sometime or a talk at TechMasters. We’ll see...what do you think?

Enjoy!
-mike

Originally posted on: http://geekswithblogs.net/benko/archive/2013/01/12/codemash-2013-fun.aspx

This week was my 2nd visit to CodeMash in Sandusky OH, where I spoke on Building with the Microsoft Data Stack. We covered a lot of ground and had a great conversation about the various choices a developer faces regarding which technologies and formats make sense, including LINQ, Entity Framework, OData, Web API’s and more. We built a session explorer and then worked with EF 5 in Model first and in Code First modes with Database Migrations.

I’ve posted the code and deck to http://bit.ly/bqtCodeMash13 in case you’re interested.

Enjoy!

Originally posted on: http://geekswithblogs.net/benko/archive/2012/12/13/need-windows-azure-support-check-out-the-brilliant-new-addition.aspx

Today I ran into an issue provisioning web sites on Azure, an issue I had with one of the subscriptions that I work with when I’m recording webcasts and training sessions. In the past I would send an email to one of my evangelist friends to see if they knew someone who maybe knew who to talk to in order to get results, but this time I figured I’d check out what I could do online.

I went to www.windowsazure.com/support and clicked on the link to get support

The next thing you know I am brought to the portal where I can create a support ticket! WOOT :) That means it will be something I can track and ensure that my issue gets resolved.

I can even see the status of existing tickets!

Sounds like more fun that you should be allowed to have, but if you need support it appears that Microsoft has hit this one out of the park. Let’s see if experience lives up to the expectations.

-mike

Originally posted on: http://geekswithblogs.net/benko/archive/2012/12/12/working-with-the-ajax-control-toolkit-slideshow.aspx

I had a request yesterday to put together a slideshow on a website we’re working on. That reminded me that there is a great collection of controls and tools available (for free) on Codeplex in the http://ajaxcontroltoolkit.codeplex.com/ site. I had used it a few years ago to build a slideshow for a site for my parent’s class reunion and it worked well then, I was curious how it’d work with .NET 4.5 and the new frameworks.

First thing was that instead of downloading the project and creating a tab in the toolbox, adding items, you can now add the latest toolkit as a NuGet package. In VS 2010 and in 2012 you can right click on the project file in the solution explorer and select “Manage NuGet Packages”. It opens a window where you can find and install the packages you’re interested in.

Once you’ve installed it open the page you want to play the slide show on and add the Toolkit Script Manager and an ASP.NET Image control. When you add a control to a page that has the script manager a smart tag is displayed that will let you add extension behaviors to it. In our case I added the Slideshow Extender.

This will add a tag to the source that includes the slideshow extender with the core properties set. We still need to set up a few more properties and create a method to retrieve the set of images we want to display.

    <form id="form1" runat="server">
        <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"></asp:ToolkitScriptManager>
        <h1>My Slideshow</h1>

        <asp:Image ID="Image1" runat="server" Height="250" />
        <asp:SlideShowExtender ID="Image1_SlideShowExtender" runat="server" 
            Enabled="True" ImageDescriptionLabelID="txtDesc"
            SlideShowServiceMethod="GetSlides" AutoPlay="true" 
            NextButtonID="btnNext" PreviousButtonID="btnPrev"
            TargetControlID="Image1">
        </asp:SlideShowExtender>
        <br />
        <asp:Button ID="btnPrev" runat="server" Text="<" />
        <asp:Button ID="btnNext" runat="server" Text=">" />
        <asp:Label ID="txtDesc" runat="server" Text="Label" />
    </form>

In this example I’m specifying the height of the images for the slideshow to be 250px and I’ve included buttons for previous and next and a label to hold the slide name. The method for the “SlideShowServiceMethod” will be defined in the code behind to pull from a directory with images that I want to include called “slides”. This is implemented in the code behind file.

namespace myWebApp
{
    public partial class _default : System.Web.UI.Page
    {
        [System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
        public static AjaxControlToolkit.Slide[] GetSlides()
        {
            string mySlideDir = AppDomain.CurrentDomain.BaseDirectory + "Slides";
            DirectoryInfo di = new DirectoryInfo(mySlideDir);

            var mySlides = from f in di.GetFiles("*.jpg", SearchOption.TopDirectoryOnly)
                           orderby f.Name
                           select new AjaxControlToolkit.Slide
                           {
                               Name = f.Name,
                               ImagePath = "Slides/" + f.Name,
                               Description = f.Name.TrimEnd(".jpeg".ToCharArray())
                           };
            return mySlides.ToArray();
        }
    }
}

Finally we run the application and enjoy the Ajax Slideshow goodness!

Enjoy!

Originally posted on: http://geekswithblogs.net/benko/archive/2012/12/10/hello-geeks-with-blogs.aspx

There is nothing so certain as Change, and this is the vNext of the BenkoBlog…Over the next few weeks and months I will be sharing my plans and hopes for the next chapter, but at the same time I want to make sure you can still get to the code and content that I’ve been building for the last several years. That’s where www.BenkoTips.com will continue to be the central place to find me. I’ve been updating the site to the latest .NET framework and will do my best to make sure that the content remains available and accurate.

So today I want to say welcome to my new Blog on www.GeeksWithBlogs.com and start having some fun.

Enjoy!

Benko Blog

Yesterday in Dallas we had Scott Guthrie (@ScottGu) and the Azure team put on a great event at the Irving Convention Center to show off what’s new in the Microsoft Cloud story and to dive into getting started with the tools and services that make it work. Chris Koenig did a great job of coordinating the event and Adam Hoffman, Clint Edmonson and Brian Prince all pitched in with sessions about Virtual Machines, Web Sites and how to work with the services.

My talk was on Building Connected Windows 8 Metro applications with Windows Azure, and we showed how to use the Camera UI to upload images to Blob Storage, Geolocation to add a point of interest to a SQL Azure database and then add a pin to a Bing Map, and finally add Notification Services to update the Live Tile. It was a lot of code and I promised to share it here, so if you’re looking for the link to download it is http://aka.ms/dfwWin8Az.

Here are some notes to be able to build out & deploy locally and then migrate the services to Azure…

- This project is designed to run locally against the Azure Storage Emulator and SQL Express. It can easily be modified to run as a cloud service, see steps below.
- Do a CTRL+SHIFT+F to search for "TODO" to find all the places where you need to personalize settings
- I've included the script MsdnDB.sql which should be run against a local instance of SQL server, or against a cloud instance.
- You should download the Bing Map VSIX installer to add functionality for Metro. Download the latest from Visual Studio Gallery here
    http://visualstudiogallery.msdn.microsoft.com/0c341dfb-4584-4738-949c-daf55b82df58

- I used several packages to enable notifications. These included
    For MyApp  --> PM> Install-Package Windows8.Notifications

    For MySite --> PM> Install-Package WindowsAzure.Notifications

                   PM> Install-Package wnsrecipe

- To deploy to the Cloud
  1. Create an Azure Web Site from the Management console, then download the publish settings from the web site dashbaord
  2. Create a storage account and update the web.config of MySite with appropriate storage credentials
  3. Create a SQL Azure database
  4. Run the create script MsdnDB.SQL (included) against database
  5. Update credentials in web.config of MySite
  6. Change MyApp MainPage.xaml.cs URI's to point to your site instead of localhost:19480
  7. Run the NuGet Packages from Package Manager console
  8. Register your app for notifications on https://manage.dev.live.com/Build
     - update the Package Name reference in Package.appxmanifest
     - Add the SID and Client secret to the SendNotification method in LocationController.cs

Enjoy!
-mike

It’s been a busy week by anyone’s estimation. We announced new capabilities in Windows Azure, a new Windows 8 Tablet called Surface, and now Windows Phone comes to the front.   Some great stuff has been announced around the future of Windows Phone yesterday. Here’s a summary of the core 8 features which include:

Multi-core processor support: As reviewers have noted, Windows Phone runs buttery smooth on phones with a single processor. But piggybacking on the Windows core provides support for multiple cores—so we’re ready for whatever hardware makers dream up.

Bigger, sharper screens: Windows Phone 8 supports two new screen resolutions—1280x768 and 1280x720, opening the door to amazing new handsets with high-definition 720p displays.

More flexible storage: Windows Phone 8 supports removable MicroSD cards, so you can stuff your phone with extra photos, music, and whatever else is important to you, and then easily move it all onto your PC.

NFC wireless sharing: If you haven’t heard the term “NFC” yet, I’m betting you soon will. This emerging wireless technology lets phones share things over short distances. In Windows Phone 8, it helps make sharing photos, Office docs, and contact info easier—just tap your phone another NFC-equipped device. How cool is that?

Internet Explorer 10: The next version of Windows Phone comes with the same web browsing engine that’s headed for Window 8 PCs and tablets. IE10 is faster and more secure, with advanced anti-phishing features like SmartScreen Filter to block dangerous websites and malware.

Wallet: Windows Phone 8’s new digital Wallet feature does two great things. It can keep debit and credit cards, coupons, boarding passes, and other important info right at your fingertips. And when paired with a secure SIM from your carrier, you can also pay for things with a tap of your phone at compatible checkout counters.

Better maps and directions: Windows Phone 8 builds in Nokia mapping as part of the platform. Our partnership will provide more detailed maps and turn-by-turn directions in many countries, plus the ability to store maps offline on your phone so you can work with maps without a data connection.

Cooler apps and games: Basing Windows Phone 8 on the Windows core will unleash a new wave of amazing apps and especially games, for reasons

For a more detailed write up check out the blog post here:

http://windowsteamblog.com/windows_phone/b/windowsphone/

You can also check out a recording of the summit here:

http://channel9.msdn.com/Events/Windows-Phone/Summit

Great stuff coming, stay tuned!

-mike

Windows Azure has seen a number of upgrades. The latest announced today, along with a series of events to showcase and explore the features and capabilities of the Microsoft cloud platform (http://aka.ms/MeetAzMB), clearly shows the move towards simplicity, ease of use, and the speed to which you can get started with Azure. While I can’t cover it all in a single post, this is meant as an introduction to the new portal and in future posts I will explore various aspects and features that you can use for building scalable, durable and performant information solutions. A number of things were announced on the Azure blog (blog url) including some key ones around IaaS, Virtual Machines, Web Sites, and the Application Galleries.

HTML and AJAX Based Interface

The new portal runs on HTML and JavaScript, which means it can render on any browser that supports the core HTML functionality. This is great if you need to access it from a mobile device or tablet that doesn’t support plugins like Silverlight. The next thing you notice is that you get an at-a-glance view of all your running services, storage and networks.

Easily Create New Services

Adding a new service is as easy as clicking “NEW” on the bottom left corner of the screen and then making a selection of what you want to create. In addition to Cloud Services (formerly called Hosted Services) and storage, you can also create Virtual Machines, Web Sites, and Networks. These generally include a quick creation option which provisions the service with minimal configuraiton, but both Web Sit4es and Virtual machines include a “From Gallery” option which allows you to select a starting point to build from. 

This includes content management applications like Umbraco, DotNetNuke, Joomla, Das Blog, mojoPortal, and WordPress, or a Virtual Machines that already have SQL 2012 Eval, Windows Server 8 Beta, SUSE Linux, or Ubuntu installed and ready for your deployments. You can also save your own machines as starting points or upload your own VHD.

Yes, I did just say Linux. Running on Azure. In the Microsoft Cloud. Notice that the list of available images includes these as well as images I created!

The new dialogs walk you thru all the steps collecting the needed information in an easy to follow logical order to get the selected services up and running. Quick and easy, but where can you see the status and updates on these configuration tasks? That’s where the notification area at the bottom of the screen comes to bat. It provides a comprehensive spot for seeing summary and optionally more detailed information about your changes as they happen.

Monitoring and Diagnostics

Beyond the provisioning of new services and configuration tasks you also can get great monitoring information about resources used by your cloud instances. By selecting a provisioned instance, clicking the name takes you to a details page where you can get deployment and configuration settings including database connection strings and more. You can quickly see how much usage you’ve used out of the available allocation that is part of the subscription.

You can easily get started today, just go out to http://windowsazure.com and try out the 90 Free Trial, or if you have an MSDN Subscription you can get compute time, storage and a lot more as part of your subscription benefits.

Enjoy!

-mike

They just announced that Windows 8 Release Preview and Visual Studio 2012 Beta is available for download (see http://aka.ms/Win8ToolsMB) . If you’re wondering how you can create a bootable USD stick to install it on your machine here’s some instructions to get you started…

The easiest way to convert an ISO file to a DVD in Windows 7 is to use Windows Disc Image Burner. On a PC running Windows XP or Windows Vista, a third-party program is required to convert an ISO file into installable media—and DVD burning software often includes this capability. One option is the USB/DVD download tool provided by the Microsoft Store. You can also download Windows 8 Release Preview Setup, which includes tools that allow you to create a DVD or USB flash drive from an ISO file (Windows Vista or Windows 7 required).

Also from the download page is a link to download the tools, which includes the Express SKU. Check out details on http://www.microsoft.com/visualstudio/11/en-us/downloads.

I’ve covered it before, but in case you want to install with Boot from VHD there are some commands worth looking at. The first is where you press SHIFT-F10 during the install when it asks where you want to install to in order to create an expandable VHD on the fly.

c:\Windows\System32> diskpart

Microsoft DiskPart version 6.1.7601 
Copyright (C) 1999-2008 Microsoft Corporation. 

DISKPART> create vdisk file=c:\vhd\win7.vhd type=expandable maximum=50000

100 percent completed

DiskPart successfully created the virtual disk file.

DISKPART> select vdisk file=c:\vhd\win7.vhd

DiskPart successfully selected the virtual disk file.

DISKPART> attach vdisk

100 percent completed

DiskPart successfully attached the virtual disk file.

DISKPART> create partition primary

DiskPart succeeded in creating the specified partition.
  

At this point you can ALT-TAB back to the installation process and you should see your new partition Then in the installation process you will see your new disk in the list of installation target options. Depending on the OS you may need to go back and run BCDEDIT to configure the boot loader to know about and offer the option of booting to your new VHD.

c:\> bcdedit /copy {current} /d “myVHD”

Copy the CSLID that is displayed and then run…

c:\> bcdedit /set {CLSID} device vhd=[C:]\vhds\vhdname.vhd

c:\> bcdedit /set {CLSID} osdevice vhd=[C:]\vhds\vhdname.vhd

c:\> bcdedit /set {CLSID} detecthal on
  

Enjoy!

The Cloud comes in many flavors, types and shapes and the terminology can be daunting. You’ve got Public vs. Private. vs. Home grown. You’ve got compute, storage and database not to mention identity, caching, service bus and many more. Then there are the several players including Microsoft, Amazon, Rackspace, Force, and too many others to list them all.

That’s a lot to learn, but if you’re curious to see what’s been happening with the Microsoft Cloud and get a feel for the direction things are heading then you want to check out the recently announced Microsoft event “Meet Windows Azure” live in San Francisco on June 7, where the people who are in the drivers seat will take time to share their space.

While the details are sparse so far you can get more information on http://MeetWindowsAzure.com , as well as follow the happenings on twitter. It looks like an interesting event you won’t want to miss. With people like Scott Guthrie it’s sure to be full of great examples of what and how you can get started with Windows Azure and learn more about what you need to know to get started today.

Check it out today!

-mike

Your application is running slow. You need to find out what’s going on. If you’ve used SQL Profiler on a local database you might be familiar with how you can capture a trace of database activity and use it to figure out where your resources are going. The visibility makes it MUCH easier to tune a database than sorting thru a bunch of code. The question is, what do you do when you’re moving an app to the cloud?

If you’ve wondered how you can get Profile information from SQL Azure, the new online management portal for SQL Azure has been updated with design, deployment, administration and tuning features built in. The Overview screen provides quick links to the different areas of the portal, as well as easy links to help information from msdn online. You can get to the portal either by going to the Windows Azure management portal on http://windows.azure.com and after signing in going to the database section and clicking Manage, or simply browsing to your database name – https://<myserver>.database.windows.net where you substitute your database server’s name for <myserver>.

When I log in I can see my databases and get information about size, usage as well as the ability dive into specific usage. From there I can go into designing the schema, functions and code around my database. If I swap over to the admin page though, I have visibility into not just database size and usage, but also a link to query performance. Clicking this takes me to where I can see profile data from queries.

I can sort and see which calls to the database are most frequent as well as most expensive in terms of resource usage. Further I can select one and dive even deeper to see the execution plan and statistics around the calls. This information is key to making decisions on indexes and design of a well performing database.

In the query plan I can look for table scans or other expensive operations and if it make sense determine whether additional indexes would be useful.

Nice!

There are many ways to learn a new technology. Some of us prefer to read books, others like videos or screencasts, still others will choose to go to a training style event. In any case you need to have a reason to want to learn, whether it's a new project, something to put on the resume or just the challenge because it sounds cool. For me I learn best when I've got a real project that will stretch my knowledge to apply it in a new way. It also helps to have a deadline.

I've been working for a while now for Microsoft in a role that allows me to help people explore what's new and possible with the new releases of technology coming out at a rapid pace from client and web technologies like ASP.NET and Phone to user interface techniques like Silverlight and Ajax, to server and cloud platforms like SQL Server and Azure. The job has forced me to be abreast of how the technologies work, what you can do with them, and understanding how to explain the reasons for why and how they might fit into a project.

In this post I'd like to provide a quick tour of where you can find content and events on Cloud Computing that should help you get started and find answers along the way.

Part 1 - Get Started with Cloud Computing and Windows Azure.
You've heard the buzz, your boss might even have talked about it. In this first webcast of the Soup to Nuts series we'll get started with Windows Azure and Cloud Computing. In it we will explore what Azure is and isn't and get started by building our first Cloud application. Fasten your seatbelts, we're ready to get started with Cloud Computing and Windows Azure.
Video; WMVMP4 Audio; WMA Slides: PPTX

Part 2 - Windows Azure Compute Services
The Cloud provides us with a number of services including storage, compute, networking and more. In this second session we take a look at how roles define what a service is. Beyond the different flavors of roles we show the RoleEntryPoint interface, and how we can plug code in the startup operations to make it easy to scale up instances. We will show how the Service Definition defines the role and provides hooks for customizing it to run the way we need it to.
Video; WMVMP4 Audio; WMA Slides: PPTX

Part 3 - Windows Azure Storage Options
The Cloud provides a scalable environment for compute but it needs somewhere common to store data. In this webcast we look at Windows Azure Storage and explore how to use the various types available to us including Blobs, Tables and Queues. We look at how it is durable, highly available and secured so that we can build applications that are able to leverage its strengths.
Video; WMVMP4 Audio; WMA Slides: PPTX

Part 4 - Intro to SQL Azure
While Windows Azure Storage provides basic storage often we need to work with Relational Data. In this weeks webcast we dive into SQL Azure and see how it is similar and different from on-premise SQL Server. From connecting from rich client as well as web apps to the management tools available for creating schema and moving data between instances in the cloud and on site we show you how it's done.
Video; WMVMP4 Audio; WMA Slides: PPTX

Part 5 - Access Control Services and Cloud Identity
Who are you? How do we know? Can you prove it? Identity in the cloud presents us with the same and different challenges from identity in person. Access Control Services is a modern identity selector service that makes it easy to work with existing islands of identity such as Facebook, Yahoo and Google. It is based on standards and works with claims to provide your application with the information it needs to make informed authorization decisions. Join this webcast to see ACS in action and learn how to put it to work in your application today.
Slides: PPTX

Part 6 - Diagnostics & Troubleshootingx
So you've built your Cloud application and now something goes wrong. What now? This weeks webcast is focused on looking at the options available for gaining insight to be able to find and solve problems. From working with Intellitrace to capture a run history to profiling options to configuring the diagnostics agent we will show you how to diagnose and troubleshoot your application.

Part 7 - Get Started with Windows Azure Caching Services with Brian Hitney (http://bit.ly/btlod-77)
How can you get the most performance and scalability from platform as a service? In this webcast, we take a look at caching and how you can integrate it in your application. Caching provides a distributed, in-memory application cache service for Windows Azure that provides performance by reducing the work needed to return a requested page.

Part 8 - Get Started with SQL Azure Reporting Services with Mike Benkovich (http://bit.ly/btlod-78)
Microsoft SQL Azure Reporting lets you easily build reporting capabilities into your Windows Azure application. The reports can be accessed easily from the Windows Azure portal, through a web browser, or directly from applications. With the cloud at your service, there's no need to manage or maintain your own reporting infrastructure. Join us as we dive into SQL Azure Reporting and the tools that are available to design connected reports that operate against disparate data sources. We look at what's provided from Windows Azure to support reporting and the available deployment options. We also see how to use this technology to build scalable reporting applications

Part 9 - Get Started working with Service Bus with Jim O'Neil (http://bit.ly/btlod-79)
No man is an island, and no cloud application stands alone! Now that you've conquered the core services of web roles, worker roles, storage, and Microsoft SQL Azure, it's time to learn how to bridge applications within the cloud and between the cloud and on premises. This is where the Service Bus comes in-providing connectivity for Windows Communication Foundation and other endpoints even behind firewalls. With both relay and brokered messaging capabilities, you can provide application-to-application communication as well as durable, asynchronous publication/subscription semantics. Come to this webcast ready to participate from your own computer to see how this technology all comes together in real time.

Enjoy!

-mike

Want to win some easy money? We have a sweepstakes, where we are giving away seven $50 gift certificate each week until June 14th. Just enter once, and you are in each drawing until the end.

To enter, you must do all of the following:

• Make sure you have a valid Windows Azure Account. Don't have one? Get your FREE trial here https://www.windowsazure.com/en-us/pricing/free-trial/ or activate your MSDN Subscription benefit that includes Windows Azure access at http://www.microsoft.com/windowsazure/msdn-benefits/.
• Create and deploy a new Windows Azure web application according to the content/technical guidelines listed below and deploy to Windows Azure no later than the end date listed above. The web site http://walearningpath.cloudapp.net/ provides guidance and instructions for how to accomplish this.
• Once your Windows Azure web application is deployed send an email to msnextde@microsoft.com with the URL to your deployed web application.

If you are selected as a winner we will need your Azure subscription ID to verify your Windows Azure subscription. Limit one (1) entry per Windows Azure subscription overall.

The official rules are posted on here.

Recently, the Windows Store blog announced that in the next significant Windows 8 preview release they will be expanding their global coverage with 33 additional app submission locales for developers.

Our store services are ramping up as planned--and of course the plan includes ramping up developer registrations to enable app submissions to the Windows store. Today, you need an invite “token” to register. This begs the question - How can YOU get a token?

It’s easy! If your app is ready and you want to be among those developers who get to submit to the store early, simply attend one of the 100s of free Application Excellence Labs that DPE and Windows are holding around the world.

Follow these steps to get invited to an App Excellence lab:

1. Contact me (mike.benkovich@microsoft.com) for instructions on how I can nominate your app for an excellence lab.

2. Create a really great Windows 8 Metro style app (or game) immediately. Get it as ready as if you were submitting to the store.

Hopefully, there will be a lab near you. Right now, we have labs in 40+ countries and we may be adding more.

Of course, coming to the lab is not all you have to do. I have to go back to step #1: You need to have a compelling, functional app that follows our UX guidelines, our performance best practices, and our store certification requirements²

The lab is a 4-hour engagement with a trained Microsoft Services Engineer. This person will run your app through a series of tests based on a quality checklist to ensure your app is (or will be) in top-notch shape when you submit. You will also get a chance discuss ways to make your app even better and you will get answers to any questions you might have.

If your app meets the criteria, then booyah! You get a token to register your developer account and (once you have been verified and all that) you will be able to submit your app to the Windows store.

If your app does not meet the criteria, nothing is lost. You will still end up with a much better app³ and you will be able to submit it when registration opens for all developers.

Good luck. We are looking forward to seeing your apps and helping you to make them great!

Prepare For the Windows Store

ü  Get your app into the Windows Store! - Register and create your app profile found here http://aka.ms/CRReg. 

ü  Download and install the Windows 8 Consumer Preview 

ü  Download and install the Visual Studio 11 Express Beta for Windows 8

Additional Resources

ü  Stay connected with our Windows 8 Evangelists? Visit their blogs to keep informed about all the latest news, updated information and local events you can attend.

·         Jennifer Marsman

·         Jeff Brand

·         Clark Sell

·         Jared Bienz

• ü  Windows Developer Center for Metro apps
• ü  Design guidance for Windows 8 apps
• ü  Windows 8 Code Samples
• ü  Developer Forums for asking questions and getting unblocked

Test your app before submitting with the Windows App Certification Kit (WACK)