Skip to main content

Cloud

Windows Azure SQL Database what’s missing?

Being primarily a developer, I would prefer not having to manage infrastructure. With SQL Database I don’t have too. SQL Database provides most of the features I need when working with a relational database. If SQL Database doesn’t suit your needs, you can have SQL Server running in a VM within Windows Azure. Though again I don’t want to deal with infrastructure as a developer. If all you need is a relational database what features is SQL Database missing.

I understand everyone has different opinions, below are a few features I would like to see in SQL Database. I understand there is different considerations (performance, security, etc.) to make these features available.

  1. SQL Agent or Job Scheduler of some sort. I know there is workarounds for this.
  2. Additional Common Language Runtime (CLR) support. I know the CLR functionality exists to some extent already, with spatial data-type support in SQL Database. Why can’t we get additional CLR functionality for other things? Bring us some of the .NET libraries Regex, Math, Date, String to use in SQL Database.
  3. JSON support. JSON appears to be the preferred standard for sending data to the client in today’s applications. SQL Database already supports XML why not JSON in a similar fashion.
  4. Having a feature similar to FILESTREAM, that would allow you to persist blobs to a storage account.

I invite you to add your suggestions/needs to the list.
By the way, if you need a Windows Azure subscription, here is the link for a free trial.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Ryan Duclos

Ryan Duclos is a Lead Technical Consultant and CSM for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Microsoft Azure technologies. Ryan was a 2014 Microsoft MVP for Microsoft Azure. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a Community Influencer for Microsoft. Ryan also a passion for Disc Golf and CrossFit! Ryan is a board member for the Lower Alabama .NET User Group and is also involved with the Pensacola SQL Server User Group, as well as other technical communities in his region. In addition, Ryan is a frequent speaker at numerous Code Camps, SQL Saturday & User Group events.

More from this Author

Follow Us
TwitterLinkedinFacebookYoutubeInstagram