From the CTO of RADSense Software

Alin Irimie

Subscribe to Alin Irimie: eMailAlertsEmail Alerts
Get Alin Irimie via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Blog Feed Post

Microsoft SQL Azure FAQ

In case you missed it, Microsoft released SQL Azure FAQ, providing an architectural overview of SQL Azure Database, and describing how you can use SQL Azure to augment your existing on-premises data infrastructure or as your complete database solution. Some of the questions answered in the document:

  • How do I connect to SQL Azure?
  • I am unable to connect to SQL Azure. How can I troubleshoot this problem?
  • Where can I find sample connection strings for SQL Azure?
  • Are there any hands-on labs or demos available for moving data between on-premise SQL Server and SQL Azure?
  • How do I configure SQL Azure Firewall settings?
  • How can I grant my Web Role access to SQL Azure?

(more after the jump)

  • Is my data secure over the wire?
  • Is Linked Server supported in SQL Azure? Can I enable Linked Server between on-premise SQL Server and SQL Azure servers or between two instances of SQL Azure servers?
  • What is the default isolation level supported in SQL Azure?
  • Is Change tracking supported in SQL Azure?
  • Is spatial data types supported in SQL Azure?
  • Is Bulk Copy supported in SQL Azure?
  • If I include DROP Database inside an IF…Else loop, I get an error saying that DROP Database is not supported even though I am connected to Master database?
  • Is SQL Agent supported in SQL Azure?
  • Is SQL Profiler supported in SQL Azure?
  • Is Replication supported in SQL Azure? Can I replicate my data from on-premise SQL to SQL Azure?
  • Is Entity Framework supported in SQL Azure?
  • Is Reporting Services or Analysis Services or SSIS supported in the cloud solution?
  • Does SQL Azure support automatic partitioning mechanism so that I can easily partition my data across multiple databases?
  • Is SQL Server error log available in SQL Azure?
  • Is IPV6 supported?
  • Is connecting to SQL Azure from Excel supported?
  • Is JDBC driver supported with SQL Azure?
  • Are there any session state providers supported with SQL Azure?
  • I have two databases on the same server. Is joining tables across the databases on the same server supported?
  • Does SQL Azure support Auditing feature?
  • Since RowGUID column is not supported in SQL Azure, what is the recommended alternative to customers?
  • What are the supported methods of moving data between on-premise SQL and SQL Azure?
  • How can I generate a SQL Azure compatible script using SQL Server management Studio?
  • How can I migrate MySQL Database to SQL Azure?
  • Is SQL Azure backward compatible? Can I migrate my SQL Server 2000 or SQL Server 2005 databases to SQL Azure?
  • What’s the story regarding the backup of data stored in SQL Azure? How can customers recover from corruption or data loss?
  • Are there any hands-on labs or demos available for moving data between on-premise SQL Server and SQL Azure?
  • What is the limit with the number of databases that can be created in SQL Azure?
  • Is there a limit on the max database size that is supported in the offerings?
  • What will be the behavior of the system when the database size is reached?
  • How can I find the actual size of my database so that I know how much space is left and plan accordingly? Is there a programmatic way I can find the size of my database?
  • Does the database size (1GB or 10GB) include logs?
  • Can you please explain about your pro-rated billing model?
  • Where can I find some metrics for my SQL Azure service?
  • Is my master database charged?
  • When a customer UN-subscribes from Azure, will the SQL Azure database be immediately deleted? How does SQL Azure handle the data that has been marked for deletion?
  • What is SQL Azure data retention and privacy policy once the customer UN-subscribes?
  • Can a customer choose to cancel just SQL Azure or any one Azure service instead of all the services?
  • How can I migrate my database from one subscription to another?
  • How can I swap subscriptions or move a subscription to another Live ID?
  • How can I create more SQL Azure servers?
  • When service updates are rolled out, is everyone on the latest version?
  • What is the procedure for rolling out OS patches and service updates?
  • What are the different conditions under which my workload can get throttled?
  • How will SQL Azure evolve to support larger data sets?
  • Where can I find case studies for SQL Azure?

Related posts:

Read the original blog entry...

More Stories By Alin Irimie

Alin Irimie is a software engineer - architect, designer, and developer with over 10 years experience in various languages and technologies. Currently he is Messaging Security Manager at Sunbelt Software, a security company. He is also the CTO of RADSense Software, a software consulting company. He has expertise in Microsoft technologies such as .NET Framework, ASP.NET, AJAX, SQL Server, C#, C++, Ruby On Rails, Cloud computing (Amazon and Windows Azure),and he also blogs about cloud technologies here.