Video How To: Advanced Business Intelligence with Cloud Data

[This article was contributed by the SQL Azure team.] We’ve created a new readiness video that introduces some of the features of SQL Azure Reporting and demonstrates the use of advanced analytical tools, such as using SQL Azure data with Excel and PowerPivot. Specifically, users will learn how to use SQL Azure data with Excel…


SQL Azure Connection Security

[This article was contributed by the SQL Azure team.] Selcin Turkarslan has written an in-depth TechNet wiki article about connection security considerations when using SQL Azure. The article is primarily concerned with writing secure connection strings for SQL Azure Database. I’d highly recommend reading it, as it details good procedures and best practices when connecting…


Video How To: Business Intelligence with Cloud Data

[This article was contributed by the SQL Azure team.] This walkthrough discusses how businesses can take business intelligence to the cloud with SQL Azure. The video covers the benefits of SQL Azure—including the ability to establish business intelligence without adding hardware costs or IT overhead—and it also introduces SQL Azure Reporting. The ability to embed…


SQL Azure Diagnostics Tool Available

[This article was contributed by the SQL Azure team.] Evan Basalik has written a post which details the arrival of CSS SQL Azure Diagnostics (CSAD), developed by the our support team. The tool has been developed to shorten the data collection process when troubleshooting SQL Azure issues. You can point CSAD to your SQL Azure…


Whitepaper on NoSQL and the Windows Azure Platform

[This article was contributed by the SQL Azure team.] I wanted to bring to your attention a great whitepaper on “NoSQL and the Windows Azure platform” written by Andrew Brust, a frequently quoted technology commentator and consultant. This paper is important because there is a renewed interest in certain non-relational data stores which are sometimes…


MSDN Article: How to Connect to SQL Azure through ASP.NET

[This article was contributed by the SQL Azure team.] MSDN has written an article on how to bind data from Microsoft SQL Azure Database to ASP.Net controls.  The article provides a basic walkthrough and an example on how to do it.  The article also shows how similar it is working with SQL Azure is to SQL Server….


MSDN: Article Guidelines for Connecting to a SQL Azure Database

[This article was contributed by the SQL Azure team.] The flexibility of SQL Azure database allows you to work with a myriad of applications from familiar Microsoft products to other programming languages such including PHP and Java . MSDN has written an article on some of the consideration guidelines that developers should be aware of…


Technet Wiki: Handling Transactions in SQL Azure

[This article was contributed by the SQL Azure team.] Just like SQL Server, SQL Azure fully supports local transactions. TechNet has released an interesting wiki article more about how SQL Azure handles transactions, as well as describing some of the basics. I would suggest taking a look, just to get more up to date on…

1

Migration to SQL Azure–Screencast

[This article was contributed by the SQL Azure team.] Lynn Langit, a Senior Developer Evangelist, has developed a comprehensive video presentation on migration to SQL Azure. This presentation includes demos using the following tools: SQL Azure Migration Wizard Access to SQL Azure Migration Wizard SQL Server Management Studio 2008 R2 – scripting, DACPAC Business Intelligence…


TechNet Wiki- SQL Azure Data Sync Scenario: SQL Server-to-SQL Azure Synchronization

[This article was contributed by the SQL Azure team.] Two weeks ago, we talked about an update to SQL Azure Data Sync. One of the topics surrounding Data Sync that comes up often amongst developers is synchronizing SQL Server to SQL Azure. TechNet has a great wiki article that discusses the considerations around syncing SQL…