SQL Azure – What is missing?

I was reading few articles around Microsoft’s cloud database SQL Azure and found an interesting article Five things in SQL Server not in SQL Azure

Below are those five features,

  1. Data encryption

Physical SQL Server used TDE for data encryption, if your application depends on TDE then you need to find a workaround or implement encryption logic within application, else need to wait for Microsoft to include TDE in Azure in future

  1. Full-text indexing and search

If you rely on data sorting or searching using this feature then you may be unhappy as it is not currently available, hoping to see it in future versions.

  1. Common Language Runtime (CLR)

This one feature may give you setback from using Azure but it depends upon till what level of application code you have written which uses CLR feature, for old applications 2000/2005 not much of CLR integration was present so those can be migrated easily but newer versions may find it challenging.

  1. File groups

This one feature may not impact directly until you have implemented logic to segregate data in filegroups for faster restore or using it for physical partitioning. As data in virtualized in Azure so it’s pretty difficult to implement it.

  1. System tables, views and stored procedures

This missing feature may effect you if application relies on searching system tables to implement some logic or logic which checks system catalogue views to identify column names, etc…

More about missing feature you can read in article link given above by Serdar Yegulalp.

More about What is Cloud Computing can be read at link and about Hybrid Cloud at link

In Brief,
Cloud computing is a general term for anything that involves delivering hosted services over the Internet. These services are broadly divided into three categories: Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS) and Software-as-a-Service (SaaS). The name cloud computing was inspired by the cloud symbol that’s often used to represent the Internet in flowcharts and diagrams. A Cloud can either be Private or Public (when configuring private cloud using public then it is called Virtual Private Cloud), but the main aim or goal of cloud computing is to provide easy, scalable access to computing resources and IT services.

Hope above will give some insights on whether to move to Azure now or wait for some more time 😉

Download PDF

Related Posts

About the Author: Nitin Garg

Indian born, trekker, biker, photographer, lover of monsoons... I love to blog the topics I research and find useful for self or online community to save time and energy :) Everything you read on my blog is my own personal opinion!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 264 other subscribers

Translate this blog!



January 2021
« Nov    

View Post by Categories

%d bloggers like this: