I can recommend the following links as study aids, as well as of course the Windows Azure Training Kit -

Designing Data Storage Architecture

http://msdn.microsoft.com/en-us/library/ee691964.aspx

http://msdn.microsoft.com/en-us/library/ee924681.aspx

http://social.technet.microsoft.com/wiki/contents/articles/1674.data-storage-offerings-on-the-windows-azure-platform.aspx

http://blogs.msdn.com/b/windowsazurestorage/archive/2010/05/10/windows-azure-storage-abstractions-and-their-scalability-targets.aspx

http://blogs.msdn.com/b/windowsazure/archive/2009/11/05/introducing-the-windows-azure-content-delivery-network.aspx

http://sqlblog.com/blogs/john_paul_cook/archive/2010/09/12/sql-azure-differences.aspx

http://blogs.msdn.com/b/sqlazure/archive/2010/11/18/10093245.aspx

http://en.wikipedia.org/wiki/Microsoft_Sync_Framework

http://blogs.msdn.com/b/sync/archive/2010/09/24/how-to-sync-large-sql-server-databases-to-sql-azure.aspx

Optimizing Data Access and Messaging

http://msdn.microsoft.com/en-us/library/dd179353.aspx

http://www.wintellect.com/CS/blogs/pmehner/archive/2010/02/28/idempotency-for-windows-azure-message-queues.aspx

http://social.technet.microsoft.com/wiki/contents/articles/1541.windows-azure-sql-database-connection-management-en-us.aspx

http://channel9.msdn.com/learn/courses/Azure/SQLAzure/SQLAzureTipsAndTricks/Exercise-3-Managing-Connections--Throttling-latency-and-transactions

http://msdn.microsoft.com/en-us/library/dd894038.aspx

http://blogical.se/blogs/jahlen/archive/2010/11/23/sql-azure-why-use-it-and-what-makes-it-different-from-sql-server.aspx

Designing the Application Architecture

http://technet.microsoft.com/en-us/magazine/gg213848.aspx

http://social.msdn.microsoft.com/Forums/en-SG/windowsazuredevelopment/thread/0183e4c1-70a5-4098-9fb9-752da43f970e

http://msdn.microsoft.com/en-us/library/ee336250.aspx

http://www.microsoftpdc.com/2009/SVC08

http://blogs.msdn.com/b/morebits/archive/2010/12/20/walkthrough-windows-azure-service-part1-introduction.aspx

http://blogs.msdn.com/b/jnak/archive/2010/01/22/windows-azure-instances-storage-limits.aspx

Preparing for Application and Service Deployment

http://azure.snagy.name/blog/?tag=configuration

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/COS311

http://blogs.msdn.com/b/jnak/archive/2010/01/22/windows-azure-instances-storage-limits.aspx

http://blogs.msdn.com/b/jnak/archive/2009/05/12/https-endpoint-on-windows-azure.aspx

http://msdn.microsoft.com/en-us/library/ff803362.aspx

http://msdn.microsoft.com/en-us/library/ff966484.aspx

http://kindohm.com/blog/2009/11/06/azurelessons/

http://msdn.microsoft.com/en-us/library/gg433135.aspx

http://msdn.microsoft.com/en-us/library/dd582704.aspx

http://social.msdn.microsoft.com/Forums/en-US/windowsazuredata/thread/d804c832-d06e-4171-99dc-8c7020b7ec15

Investigating and Analyzing Applications

http://msdn.microsoft.com/en-us/library/gg433048.aspx

http://msdn.microsoft.com/en-us/library/ee336238.aspx#edmv

http://blogs.msdn.com/b/jnak/archive/2010/06/07/using-intellitrace-to-debug-windows-azure-cloud-services.aspx

Designing Integrated Solutions

http://msdn.microsoft.com/en-us/library/ee794877.aspx

http://msdn.microsoft.com/en-us/library/gg602420.aspx#SB_FAQ

http://zamd.net/2011/02/08/using-simple-web-token-swt-with-wif/

http://channel9.msdn.com/Events/TechEd/Europe/2010/ARC303

http://msdn.microsoft.com/en-us/library/ff359102.aspx

You can also use the following learning plan, however some of the video content is out of date now -
70-583 Learning Plan
I hope this helps.

Windows Azure Interview Questions

1. What is Windows Azure?
Ans. (First Answer)Windows Azure is Microsoft Cloud Computing Operating System. Someone needs to worry about the hardware requirement, network requirement and the correct Operating System and much other stuff when he starts designing an application. Windows Azure will help the developer to get rid of these things and let him concentrate on main area which is nothing but automation and business needs.
(Second Answer)Windows Azure is a cloud services operating system that serves as the development, service hosting and service management environment for the Windows Azure platform. Windows Azure provides developers with on-demand compute and storage to host, scale, and manage web applications on the internet through Microsoft datacenters.
2. What is Windows Azure Platform? Ans. A collective name of Microsoft’s Platform as a Service (PaaS) offering which provides a programming platform, a deployment vehicle, and a runtime environment of cloud computing hosted in Microsoft datacenters.
3. What is difference between Windows Azure Platform and Windows Azure? Ans. The former is Microsoft’s PaaS offering including Windows Azure, SQL Azure, and Appfabric; while the latter is part of the offering and the Microsoft’s cloud OS.
4. What is fabric? Ans. In the Windows Azure cloud fabric is nothing but a combination of many virtualized instances which run client application.
5. What are the three core components of Windows Azure? Ans. Windows Azure has three core components: Compute, Storage and Fabric.
Compute: It provides a computation environment with Web Role, Worker Role, and VM Role.
Storage: It focuses on providing scalable storage (Blobs, non-relational Tables, and Queues) for large-scale needs. Relational Database functionality is offered through SQL Azure, which is a scalable version of SQL Server that runs on the Azure platform.
Fabric: Fabric (Windows Azure Fabric) makes up the physical underpinnings of the Windows Azure platform as the network of interconnected nodes consisting of servers, high-speed connections, and switches. Conceptually, the repetitive pattern of nodes and connections suggests a woven or fabric-like nature. Compute and Storage components are part of the Fabric.
6. What is the downtime for applications in case of any patching?
Ans. Windows Azure will have replicas for each and every application and provide zero downtime in case of any security patching.
7. How many copies of data are maintained in Windows Azure?
Ans. Windows Azure provides you with three copies of data. This makes your application running on very reliable data.
8. What is queue storage in the Windows Azure?
Ans. Queue storage gives you capability of sending the small data just as messages. Queue storage basically helps informing the task to the worker threads.
9. What is Windows Azure AppFabric? What are the services it provides?
Ans. Windows Azure AppFabric is a part of the Microsoft Windows Azure Platform. Positioned by Microsoft as middleware, it provides several cloud computing services:
Access Control Service: Provides an easy way for web applications and web services to identify users, and grant access control to the applications and services.
AppFabric Applications: Provides tools and APIs for developing and hosting a composite application expressly for deployment through the service.
Service Bus: Provides secure connections between distributed and disconnected applications in the cloud.
Caching: Provides a distributed, in-memory, application cache service for Windows Azure and SQL Azure applications.
Integration: Leverages several capabilities of Microsoft BizTalk Server such as transforming messages from one format to another, or providing a queue for message passing.
10. What are the main uses of Windows Azure?
Ans. 1. Run enterprise workloads in the cloud
2. Build, modify, and distribute scalable applications with minimal on-premises resources
3. Perform large-volume storage, batch processing, intense or large-volume computations
4. Create, test, debug, and distribute Web services quickly and inexpensively
11. What are benefits of Windows Azure?
Ans. 1. Bring your ideas to market faster and pay as you go
2. Reduce costs of building and extending on-premises resources
3. Reduce the effort and costs of IT management
4. Respond quickly to changes in your business and customer needs
5. Choose an on-premises or off-premises deployment model that best suits your needs.
6. Scale your IT resources up and down based on your needs.
7. Consume computing resources ONLY when the needs arise.
8. Focus less energy on managing operational resources and constraints.
9. Remove the need to manage hardware
10. Use your existing development skills to build cloud applications
11. Consistent development and management experience across on-premises and the cloud.
12. What is worker role?
Ans. A role that provides a general-purpose environment for running application workloads. Typically, background processing for web applications running on web roles can be offloaded to instances of the worker role.
13. What is web role?
Ans. A role that provides an environment for running web sites or applications as supported by Internet Information Services (IIS) 7.0.
14. What do you mean by VM role?
Ans. A role that provides a customer-customizable virtual machine in which to run the customer’s hosted service.
15. What is Virtual IP(VIP)?
Ans. An IP address that is not connected to a specific computer or network interface card. Service deployments are assigned a VIP for receiving network traffic which is redirected to a physical device in the Windows Azure fabric.
16. What is use of activation token?
Ans. A unique identifier that activates a Windows Azure Connect endpoint and is linked to the customer’s subscription. The token can be reset by the customer.
17. What do you mean by affinity group?
Ans. A geographical grouping of a customer’s hosted service deployments and storage accounts within Windows Azure. An affinity group can improve service performance by locating compute and data storage workloads in the same data center or near the target user audience.
18. What is cloud?
Ans. A collection of servers, networks, and gateways that provide a computing environment that is delivered over the Internet as a service on a pay-per-use basis.
19. What do you mean by Compute Emulator and Compute hours?
Ans.
Compute Emulator: The software emulation of the Windows Azure Compute service that runs in the developer’s local environment for application testing and debugging.
Compute Hours: The amount of time charged to a subscription for hosted services deployed and running in the Windows Azure compute environment. Customers are charged different rates for different sized compute instances.
20. What is a container?
Ans. It is a user-defined set of blobs within a storage account. A container resource has no associated content, only properties and metadata.
21. What is cspack?
Ans. It is a command-line tool that generates a service package file (.cspkg) and prepares an application for deployment, either to Windows Azure or to the compute emulator.
22. What is csrun?
Ans. It is a command-line tool that deploys a packaged application to the Windows Azure compute emulator and manages the running service.
23. What is guest OS?
Ans. It is the operating system that runs on the virtual machine that hosts an instance of a role.
24. What is input endpoint?
Ans. It is the IP and port on which a role instance receives inbound traffic. Each type of role has restrictions on the number and type of input endpoints that can be defined. A web role can have no more than one HTTP endpoint and one HTTPS endpoint. A work role can have no more than five HTTP, HTTPS, or TCP endpoints (any combination). A VM role can have only one HTTP, HTTPS, or TCP endpoint.
25. What do you mean by page blob?
Ans. It is a collection of pages in a blob. A page is a range of data that is identified by its offset from the start of the blob.
26. What is reimage?
Ans. It is process to reset the VM to the initial state. The initial state is defined by the settings configured on the VHD that was uploaded to the VM.
27. What is a Fabric Agent?
Ans. A self-initialized application deployed with the root partition of a Windows Azure Compute node to form the fabric.
28. What is Content Delivery Network(CDN)?
Ans. An add-on feature to Windows Azure subscription to cache Windows Azure BLOBs and the static content output of Compute instances at Microsoft’s caching servers near what the content is most frequently accessed.
29. What is SQL Azure?
Ans. A cloud-based relational database service with SQL Azure Reporting.
30. What is the use of Window Azure SDK?
Ans. With Windows Azure SDK, a Visual Studio programmer can employ Cloud project template, develop Windows Azure applications, and securely publish an application to cloud using certificate.

Export Websites in IIS 7 to XML sheet by Command Line Argument Command....


%windir%\system32\inetsrv\appcmd list site /config /xml > e:\websites.xml

For More :

http://www.dotneter.com/exporting-and-importing-sites-in-iis-7

SQL SERVER – Difference Between DATETIME and DATETIME2

DIFFRENCE BETWEEN :-

To know about Difference between DATETIME and DATETIME2 Please read following article..Very informative and well explained.

http://blog.sqlauthority.com/2010/06/11/sql-server-difference-between-datetime-and-datetime2/