SQL Server Cost in cloud with simple calculation (Internal SQL Server Vs Cloud based SQL Server)

A quick back-of-the-envelope calculation using a 2-cpu server with 8gb ram, SATA drives, Windows 2008 and 2 CPUs of SQL Server Standard at list price puts me around $15,000.

(Yes, enterprises get dramatically discounted stuff, but enterprises don’t need SQL Azure at rack price either.)

Let’s say I use this server for five years – that’s $416 per month. That does not include:


Connectivity costs (but neither does the Azure $9-$99 price, either. Remember that bandwidth costs extra for Azure.)

Management (but neither does Azure, since you still have to roll some of your own utilities. Remember that Azure doesn’t support things like Profiler.)

Backups (but neither does Azure, and no, Microsoft telling me “it’s backed up” doesn’t count.)

Clustering or geographic high availability. I probably wouldn’t achieve three nines of uptime with this configuration, but if I wanted to go for that, I’d add a second server in another location with SQL Server’s database mirroring.


The tough part of all this is the future:

Will SQL Azure’s costs go down? Hardware prices always go down, so it’s interesting to try to compare long-term pricing between the two.

Will SQL Azure add more features? I can back up a locally hosted database easily, but backing up Azure is going to be a little tricky for now. If I want to add filestream data or TDE, that’s a piece of cake with local databases, but not with Azure.

Will SQL Azure stick? If I had a dollar for every piece of technology built then Microsoft abandoned, I’d be Steve Jobs. The nice thing about developing for SQL Azure is that it’s a subset of SQL Server anyway. Worst case scenario, Microsoft abandons SQL Azure – you just light up your own SQL Server and deploy your app there anyway.


Is Cloud Computing going to change DBA responsibilities?

I feel future DBAs will be more responsible in showing immediate result than long-term plans, so they have to be more pro-active in reducing the billing from Cloud Service provider by reducing usage of CPU cycles and Data Storage.

A No

rmal DBA today is responsible to make sure of the following:

1) Database is up and running 24/7

2) Backups and Disaster Recovery sites are sync

3) Database Security

4) Performance of Database

5) Capacity Planning

6) Backup Strategy

7) Pro-Active Monitoring, Etc……

We wonder what would be DBA tasks in the future when the Cloud Computing Era starts.
Other than the above, there are some responsibilities which will be taken care of Cloud Provider, but the actual DBA task would be more in terms of reducing Service provider’s bill by using Technologies and techniques like – Reducing CPU cycles to Run a query and Reducing data storage costs. That will be more interesting for a DBA to prove cloud service provider’s bill was reduced by 10% after tuning the database.

I am really looking forward to how this computing era will change at the end of the day. Do you think we only have couple of big heads who will provide cloud and all businesses will depend on them? Or these providers will increase like hosting service providers?

How to secure your Database in the cloud

After some researching recent days how we can use Database in the cloud how customers will take on Security when it comes to Cloud Computing combined with Database hosting and Backup solutions in the cloud. The fact is that it is a change inthe way we do business. When the change is playing more control on price and CAPEX any business owner will start looking at alternatives.

Here is an excellent article which every one should if you are interested exploring opportunities or using for your projects in the future. This article is written by Mr. Slavik Markovich founder of Sentrigo databae sercurity Firm.


Ways to use Database services in Cloud Computing

Is it realistic using Cloud for Database Services. Which means can we create applications with out having database server inside an enterprise. If all this can be done . What about security and privacy data.

After started thinking about using Cloud computing for database services I keep getting so many questions in my self.
If this is some thing related to web services i think an enterprise would take a step further and giving a shot because there is not much privacy data stored in Webservices . Because web services will fetch data from database when ever needed.

After thinking about how Cloud Computing can fit with in Database area. I came to conclusion by creating Hybrid Cloud Computing which In fact I was thinking to use some thing like this. Since I have worked in E Commerce Architecture for a long time. I always go back and think in E commerce database as an example when ever i was thinking of a database . Any how lets say we have E commerce Database in SQL Server 2005 how can we send this database to cloud With out compromising any security or privacy related matters.
First of all why should E Commerce platform choose to go for cloud computing .

1) E commerce website traffic pattern and Users on the website changes drastically based on gifting or purchasing sensitive time.
During this time E commerce site may need extra hardware resources which the company should invest upfront for the use of those resources for couple of weeks in an year. So I feel it is good solution to start with cloud since cloud can work as elastic manner it can expand hardware resources on the spot when ever needed. Company is not required to invest on hardware does not incur upfront cost. Rather it will pay for extra usage when ever used in cloud.

based on all these points I strongly feel an E Commerce website can choose to go into cloud.
But now I have another question if we keep the data in the cloud . Do the company have control on its data security and can we guarantee privacy of User data.

May be we can guarantee user data privacy and security as long as the data is in our hands how can we guarantee when the data is sitting in cloud where the owners of the company nor any one knows who has access to it who does not have access to it. I am 100% sure cloud service company IT staff can have access to this data any time they need.
keeping in mind how can we use cloud for Database services with out compromising user privacy and data security. After thinking couple of minutes I feel that we can do this .

In any database there are types of Data 1) Secure and Privacy data 2) Non Secure and Non privacy data what i mean to say Privacy data means it will have customer personal information and other credit card information where as Non privacy data is Company owned data such as Product information ,pricing and availability of products.

any e commerce site if there are 100 users visited the site to buy some thing there only 30 to 40 people end buying maximum.
so 100 times products are queried and showed in the website . This means Non privacy data is queried more and also more hardware required to process the non privacy information .if Non privacy data is kept in cloud and Privacy data kept in company’s control . Cloud computing can be achieved it will cut no of resources required to use will reduce so intern ROI on cloud computer will be achieved in short term.