Browse by Tags - SQL Azure Team Blog - Site Home - MSDN Blogs

Browse by Tags

Tagged Content List
  • Blog Post: SQL Azure Connection Security

    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...
  • Blog Post: Securing Your Connection String in Windows Azure: Part 4

    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 secure connection string...
  • Blog Post: Securing Your Connection String in Windows Azure: Part 3

    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 secure connection string...
  • Blog Post: Securing Your Connection String in Windows Azure: Part 2

    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 secure connection string...
  • Blog Post: Securing Your Connection String in Windows Azure: Part 1

    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 want to provide the production database...
  • Blog Post: Transferring a SQL Azure Database

    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 Portal administrator name and password...
  • Blog Post: Security Resources for the Windows Azure Platform

    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 by Microsoft...
  • Blog Post: I Miss You SQL Server Agent: Part 1

    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 agent man, secret agent man They've given you...
  • Blog Post: Introduction to Open Data Protocol (OData) and SQL Azure

    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 expose data from a variety of sources...
  • Blog Post: Security Considerations with SQL Azure and PowerPivot

    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 use PowerPivot against your SQL Azure data you...
  • Blog Post: Getting Started With PowerPivot and SQL Azure

    PowerPivot is a powerful, downloadable extension to Microsoft Excel 2010 that allows you to perform business intelligence and analytics against known data sources. One excellent data source you can use is your SQL Azure database. This article will talk about getting started with SQL Azure as a data source...
  • Blog Post: Video: How Do I: Configure SQL Azure Security?

    In this video, Max Adams introduces security within SQL Azure. The creation of Logins, Databases and Users is discussed and demonstrated. The views sys.sql_logins and sys.databases which allow the display of logins and databases from the master database are also discussed. View the video here .
  • Blog Post: Adding Users to Your SQL Azure Database

    When you generate a SQL Azure server via the SQL Azure portal , you generate a user name and password at the same time. This is your administrative account it has access to all databases on that server. However, you might want to give other people access to some or all of your databases on that server...
  • Blog Post: Remember to Encrypt Your Connection

    SQL Azure doesn’t support unencrypted connections. If you try to request a connection via SQL Server Management Studio that is unencrypted, SQL Azure signals SQL Server Management Studio to establish an encrypted connection. Likewise, you need to specify in your connection strings that you want to encrypt...
Page 1 of 1 (14 items)