Do We Need Transactions? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Do We Need Transactions?

I was talking to a colleague today over lunch who was intrigued by the replay that he watched of the presentation Steve Ballmer made in Sydney yesterday. The presentation targeted a developer audience; hence, it showcased Visual Studio 2010 and Azure. Although the presentations were developer focused there was mention of the platforms that will support Azure including SQL Server Data Services. One of the points made was that SQL Server Data Services will not support Transactions. Now I am not sure if this is true or not as I have not listened to the presentation, so perhaps the persons I was having lunch with had a few too many red wines with dinner.
It got me thinking though: what good is a database without transactions? Earlier versions of the MySQL database engine did not support transactions, which I think is why MySQL is often the first choice when designing Web sites. As many Web sites are read-only, they do not require transactions. When you think about it though, the revenue that Microsoft makes is through the sale of licences. If all of a sudden you can access SQL Server in the cloud for only a few dollars a day, why would you buy a SQL Server licence? By making a scalable version of SQL Server available at a very low price point it allows Microsoft to upsize from the cloud version to Standard and Enterprise editions. Where do you think SQL Server in the cloud fits in based on the existing SQL Server revenue models?
– Peter Ward


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |