SQL Database Premium Edition


Recently Microsoft announced Premium Edition of SQL Database. In simple words, it allows you to reserve the capacity so that it is not shared with other tenants! Similar to having your dedicated SQL infrastructure minus the maintenance overhead that comes with it.

Caution – This could be a double-edge sword though. I believe that auto-throttling in cloud environments helps promote good architecture and coding practices, hence having a dedicated environment with elevated limits may be seen by some as a solution to bad architecture and coding problems; instead of fixing the code, they might be inclined to throw more capacity at it. Be careful!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s