Archive for category Windows Azure
I just found out that I passed the Windows Azure beta exam! I took it back in November and have been waiting for such a long time to find out the results. I did hear that this exam will require re-certification every 2 years due to the constant rate of change of Azure.
For other people that have been waiting on their results, I checked the Prometric Candidate History and it changed from “Tested” to “Passed”. I had not yet gotten a “Congratulations on your new certification” email that usually comes. Apparently the results have been delayed for some reason.
— Update 2/18/2011 —
The exam is now showing on my Microsoft Transcript so the scoring process should be back to normal now.
After making the post earlier today about how to interact with the CRM 2011 Online Discovery Service I remembered this was only part of the story. After getting the security information back from the discovery service it is necessary to call the organization service to work with the entities. Some of the organization service functionality is actually new to CRM 2011.
In CRM 4 the Discovery Service existed already but some aspects of the Organization Service are different. I found that the generation of the schemas for the organization service to also be more difficult.
The service URI for the organization service is https://organization.crm.dynamics.com/XRMServices/2011/Organization.svc but this only gives you part of the WSDL. If you take the WSDL from this address into Visual Studio it will not generate the BizTalk schemas successfully. In fact if you try to add a service reference using the WSDL from this address you will get an error and in the app.config will see comments mentioning that svcutil did not understand the policy assertions.
I looked at the WSDL generated from the above service reference and noticed there was a referenced WSDL file. So if you then try https://organization.crm.dynamics.com/XRMServices/2011/Organization.svc?wsdl=wsdl0, this will give you the full body of the WSDL you actually need to generate the schemas. I copied the much longer WSDL file to my Sky Drive so you can generate your schemas based off of this: http://7wsmza.bay.livefilestore.com/y1pTIOWFbPSpk8WAcLftCF5h8WDa20KbBQ2HXgATcW_iHovw3UEeT74hLQ5HyfXXLcKfAODZDV_Qbc2QqwwkqyOI9uPtvaAMb1l/CrmOrganizationServiceWsdl0.wsdl?download&psid=1. Here is the updated download with my generated artifacts: http://7wsmza.bay.livefilestore.com/y1psUis8O6hlmLvyslbbSrRU38tbauTd7zsnVexj1zVfoDkWtijWO60RoNR-2RSTrMyiSJScK7JpwpGN-s0zU4p28vuseU-4LbC/CrmDiscAndOrgSvc.zip?download&psid=1. The organization service will generate quite a few port types.
When I tried compiling after generating the schemas for the organization service, I received a large number of errors. This also occurs when adding a service reference to the organization service. I have a feeling that you may need to reference a CRM assembly to reuse the types appropriately when generating the schemas, but I do not really know how this works at this point.
So now you have the schemas for how to call the Discovery and the Organization Services from BizTalk. It looks like all that is left is just an orchestration and a few ports once you can get the organization service schemas to compile. Thanks!
I have been playing with the Azure toolset lately in preparation for taking beta exam 71-583, which is the MCPD (Pro) exam on Windows Azure technologies. I had worked with these technologies on and off over the past 2 years during the early releases. One thing I have heard from many people is that they will see a bill come in somewhat unexpectedly. During the early pre-production releases everything was free so I did not worry about the charges. I signed up with the cover of my MVP MSDN subscription but I did need to enter my credit card information in case of overages. It is like a hotel – you still have to give your credit card for the mini-bar, long-distance room calls and the movies on the tv.
One thing that seems to be relatively poorly documented is how to check your bill or tab. I gave this feedback on a recent MPRP study but apparently it has not gotten through about how many in the community seem to be stunned by the charges. So I thought it would be good to do a quick post on how to check your bill in the current Azure product. While some of the screenshots seem relatively self-explanatory, you do need to choose 5 links to drill down deep enough into the account details to actually get the meaningful charges information. This really should be easier.
- First, go to one of the Azure configuration portals, either at http://sql.azure.com, http://windows.azure.com, or http://appfabric.azure.com. If you have used the service, you should see a screen similar to the one for me below:
- Click on the “Billing” link in the upper right hand portion of the screen under your Windows Live Id.
- The next page displayed will be https://mocp.microsoftonline.com/site/default.aspx, which you could alternately go to directly. You will then need to authenticate again. After authenticating with your Windows Live ID the site will be shown similar to the picture below:
- So the next thing to do is to click on “View My Bills”. Again, this seems obvious but this is the only entry point I have found into this important report. A pop up window will open. The popup will load a list of your bills as shown for me below:
- Next you click on View Online Bill/Invoice. This will bring back an itemized list of your current charges. You can see my bill below. I have been using some of the Azure services but it is covered up to a point by my MSDN benefits:
- Finally you have to click on the links like AppFabrc Usage Charges, Data Transfer Usage Charges, or SQL Azure Usage Charges to get the real statistical information about how much you owe. For MSDN subscribers, this is where you check how many minutes you have left in your plan :). Below I show my charges for the data transfer:
- I tried taking the URL for this report and copying it out to a different browser session but was unsuccessful. I wish it were easier to see the expected charges or maybe get a text if I were about to be charged actual money. I wonder if there is a cloudapp for that.
Good luck managing your cloud accounts! Thanks,
- Windows Azure SDK: http://go.microsoft.com/fwlink/?LinkID=130232
- Windows Azure Tools for Visual Studio: http://go.microsoft.com/fwlink/?LinkId=128752
There is a rainbow in the cloud! 🙂
- Install Vista
- Add Windows components – all IIS features
- Turn off Windows update so it doesn’t interfere with the SQL 2008 install
- Install Vista SP1 – (Required for Azure SDK install)
- SQL 2008 Full
- Visual Studio 2008 minus SQL Express
- Visual Studio 2008 SP1 (includes .Net Framework 3.5 SP1)
- Turn on Windows update
- Install Windows Azure SDK (http://www.microsoft.com/downloads/details.aspx?FamilyID=bb893fb0-ad04-4fe8-bb04-0c5e4278d3e9&DisplayLang=en)
- Install Visual Studio 2008 extensions for Windows Azure (http://www.microsoft.com/downloads/details.aspx?familyid=63D0D248-1B08-4F7D-ABDE-62EB75CB1E69&displaylang=en)
- Install Microsoft .NET Services (Dec 2008 CTP) SDK (http://www.microsoft.com/downloads/details.aspx?familyid=83E1E30F-BD9A-4284-80A6-388BA2E768FD&displaylang=en)
- Install SQL Data Services SDK (http://www.microsoft.com/downloads/details.aspx?familyid=0B1FA5C6-EC9D-440B-939E-481DD05F2627&displaylang=en)
- Install Azure MMC (http://code.msdn.microsoft.com/AzureManagementTools)
Then there is some additional configuration to do to get the Azure SDK to use your SQL Server instance other than SQL Express which is the default. A few posters had mentioned this technique but there were a few missing steps. Follow these steps to get the Azure SDK to use your local SQL 2008 instance (or a different one):
- Open Windows Explorer to c:Program FilesWindows Azure SDKv1.0bin and find the DevelopmentStorage.exe.config file.
- Modify this file so that it refers to your local SQL 2008 instance such as:
<add name=“DevelopmentStorageDbConnectionString” connectionString=“Data Source=benc-vistabase;Initial Catalog=DevelopmentStorageDb;Integrated Security=True” providerName=“System.Data.SqlClient“ />
<add key=“ClientSettingsProvider.ServiceUri“ value=“” />
<service name=“Blob” url=“http://127.0.0.1:10000/“/>
<service name=“Queue” url=“http://127.0.0.1:10001/“/>
<service name=“Table” url=“http://127.0.0.1:10002/” dbServer=“localhost“ dbName=“developmentstoragedb“/>
- Then open the Development Storage by going to Start Menu -> All Programs -> Windows Azure SDK -> Development Storage. This will start running the storage services and you will see an gray box icon in the tray. Right-click on this and click to open the Storage UI. The first time you do this it will ask to run some administrative tasks to create the database specified in the config file above.
- This will get the Blob and Queue services running but the Table will start and then stop. You will need to specify a different database for the Table storage. One that works is the ReportServer database installed with SQL 2008. In the Development Storage you can click Tools -> Table service properties and then choose the ReportServer database. This can be changed later, but to get the Table service running this is a temporary workaround.
- Then check the Table service and stop and restart the service and it will then no longer stop after a few seconds.