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…

0

Securing Your Connection String in Windows Azure: Part 4

[This article was contributed by the SQL Azure team.] This is the fourth part in a multi-part blog series about securing your connection string in Windows Azure. In the first blog post (found here) a technique was discussed for creating a public/private key pair, using the Windows Azure Certificate Store to store and decrypt the…

0

Securing Your Connection String in Windows Azure: Part 3

[This article was contributed by the SQL Azure team.] This is the third part in a multi-part blog series about securing your connection string in Windows Azure. In the first blog post (found here) a technique was discussed for creating a public/private key pair, using the Windows Azure Certificate Store to store and decrypt the…

0

Securing Your Connection String in Windows Azure: Part 2

[This article was contributed by the SQL Azure team.] This is the second part in a multi-part blog series about securing your connection string in Windows Azure. In the first blog post (found here) a technique was discussed for creating a public/private key pair, using the Windows Azure Certificate Store to store and decrypt the…

0

Securing Your Connection String in Windows Azure: Part 1

[This article was contributed by the SQL Azure team.] One of the challenges you face in running a highly secure SQL Azure environment is too keep your connection string to SQL Azure secure. If you are running Windows Azure you need to provide this connection string to your Windows Azure code, however you might not…

0

Transferring a SQL Azure Database

[This article was contributed by the SQL Azure team.] The original blog post doesn’t work as written, since the destination user executing the CREATE DATABASE must have exactly the same name as SQL Azure Portal Administrator name on the source database; i.e. you can only copy from a database where you know the SQL Azure…

0

Security Resources for the Windows Azure Platform

[This article was contributed by the SQL Azure team.] If you’ve been looking for information on SQL Azure security, check out Security Resources for the Windows Azure Platform. This new topic in the MSDN Library provides links to many of the articles, blogs, videos, and webcasts on Windows Azure Platform security authored by and presented…

0

I Miss You SQL Server Agent: Part 1

[This article was contributed by the SQL Azure team.] Currently, SQL Azure doesn’t support running SQL Server Agent in the cloud. If you need SQL Server Agent type functionality for SQL Azure, you can use a Windows Azure worker role and some custom code, I will show you how in this blog post series. “Secret…

0

Introduction to Open Data Protocol (OData) and SQL Azure

[This article was contributed by the SQL Azure team.] The Open Data Protocol (OData) is an emerging standard for querying and updating data over the Web. OData is a REST-based protocol whose core focus is to maximize the interoperability between data services and clients that wish to access that data. It is being used to…

0

Security Considerations with SQL Azure and PowerPivot

[This article was contributed by the SQL Azure team.] In this former blog post I discussed how to enable access to SQL Azure from PowerPivot. Now that access is enabled and the data is available to you, let’s examine how PowerPivot and SQL Azure work from a security perspective. Accessing the Data In order to…

0