Monday, March 16, 2009

Microsoft SDS Change Eerily Reminiscent of WinFS Fate

Last week Microsoft announced that they would be abandoning the ACE and dynamic entity (“property bag”) model for the SQL Server Data Services cloud data storage system. They would also switch from their REST data API (used in ADO.Net Data Services) to the old-school “Tabular Data Stream” wire protocol.

While Microsoft’s promise of more relational support was always a distinguishing feature of their cloud DB service, and while they tried to spin the news in that direction, it feels a lot more like when they abandoned WinFS and announced that, really, everything you could do with WinFS would work fine using NTFS and a whole heck of a lot of indexing. Maybe sorta true … but feels like a big step back.

Of course, big customers – large enterprises with SQL Server databases and lots of SQL code – would not want to see a change in their data layer and would prefer this move. But accommodating them is assuming that they are ready to become first-version customers of the data cloud at all. And I doubt this for two reasons.

First, any move to the cloud involves a trade-off of control which some companies are loath to make even if they are confident the system will work. Which is problematic because:

Second, anyone who has dealt with big databases knows that there is no magic. Despite the quest for automagic autoscaling self-tuning databases, no one, so far as I know, has made one that does all of this for really large enterprise applications. There are just too many application specific variables, not to mention poorly written app code that can cause trouble in proportion to the amount of resources you give it access to.

I do believe Microsoft has the engineering brainpower to try the problem, and are as likely as anyone to succeed. It’s just that I haven’t seen any evidence of a specific strategy or technology. Maybe if I were a bigger customer … but seriously, if Redmond had this problem solved (and it’s one of the biggest out there), they would either patent it or publish lots of white papers. Either way, it would be publicized and reviewed. A trade secret? maybe, but which Fortune 500 CIO is going to jump on that bandwagon and the cloud and the outsourced data stuff all at the same time?

To the extent that these large database apps could be made to behave without human intervention, there is likely to be a tradeoff in resources, and when you’re paying per GB or per compute-cycle, that equals a side order of more cost to go along with the entree of new greater risk.

The point is that the ACE/dynamic entity/REST model is well understood, performs, utilizes resources in a known manner. Not appropriate for every app. Not relational in the formal sense if at all. Not easy to migrate to. But it goes like the devil. So you’re getting something concrete in exchange for your risk and your dollars. Unlike a magical SQL Server instance in the sky.

Maybe there is magic in there, and I’ll be proven wrong. Or maybe 99% of the customers’ database needs are so small that it’s a non-issue, and Microsoft is really just competing with the thousands of hosting providers that will host actual individual SQL Server instances for you on a large server. But this change still seems to raise more questions than it answers.

24 comments:

Unknown said...

The holidays are a time ed hardy of getting together with friends ed hardy shoes and family, attending elaborate ed hardy clothing parties, and other exciting events ed hardy clothes that involves dressing up in stunning ed hardy store wardrobes. If you ed hardy Bikini are pregnant during ed hardy swimsuits the holidays, it does not ed hardy Caps mean that you are unable buy ed hardy to look fabulous and ed hardy swimwear stylish. Now, an expectant ed hardy sale mother has many styles of chic ed hardy glasses maternity clothing that allows cheap ed hardy her to show off her baby bump Christian audigier while looking spectacular.

Runescape Gold said...

Great! Frequently We by no means understand whole content articles nevertheless the means people composed this post is purely wonderful this also retained this involvement in reading through i loved that.


http://buyteraonline.com/
http://rsgoldfsbest.com/

Dog said...

It's continually a good idea to dog collar invest in resilient educational baby toys at a bargain price in place of just spending multiple times relating to less than tough models. Finally, there is not any lack connected with range when it comes to pet toy characters for dog carrier sale the two traditional and online, it depends with you to choose the suitable for your canine more effective sections.

The article author i have told has a dog products online e-store the fact that stocks exciting puppy gifts. When using the writer's knowledge about your new puppy tools, there are a lot articles drafted about minor long-lasting doggie gifts with the source. provides quite a few strategies relating dog toys to initialed or monogrammed dog collars too.



Anonymous said...

Way it is noteworthy all around you sunglasses wholesale, additionally, the stylish exploring rarely leave you the only one. Who has a two of awesome fashion accessory drinking glasses, you are the shining an individual who stalls in the center from the fashion world. >

You have eyeglasses frames to land which will people that you're a beautiful an individual who has actually different mastering in regards to the street fashion? We should appear like the far more very popular glasses frames person who has this named flavor involving trendy? In basic terms. The perfect means spectacles is really effective acceptable to help teach all these whizzes.

reginald surict said...

How to do a snapchat hack? Follow the link to learn info in more detail.

The Doy said...
This comment has been removed by the author.
Alpha said...
This comment has been removed by the author.
Anonymous said...
This comment has been removed by the author.
Anonymous said...

However, it isn't immune to hacking. Surprisingly, some ways to hack an iPhone are really simple and even an average user can perform them: https://www.myfonemate.com/how-to/hack-into-someones-iphone-xs-xr-8-7-6.html

The Doy said...
This comment has been removed by the author.
fonespy said...

Spyware has changed a lot since then, and I’ve tested and used many different remote cell spy apps, surveillance programs, and security equipment. With this experience, I have become an expert on the best phone spy apps choices.

The Doy said...
This comment has been removed by the author.
Brandy Mike said...

I would like to let you know using an easy method. The method is called hacking. By using this method you can hack others people messengers or devices. Just try and install Minspy app. If you want to know read more on Minspy blog.

Alex Carry said...

It looks like a great blog. Thank you so much for sharing. The most importantly I want to know more about it 'microsoft sds change eerily reminiscent'. And the later on I want to offer you an app which will help you to secure your phone. The app is called Spyine. Very simple and easy to use. Try Spyine website for more details https://www.spyine.com/. All the best!

Evie-May Riley said...

That's a good point you make in this post. I'm also frequently find myself being worried by all the incoming calls that my kid answers. There is so much scam nowadays. But, I found a phone tracking app that works well for me, it's mSpy. Check their website https://www.mspy.com, they provide many useful insights into parental control and monitoring issues.

Rosi said...
This comment has been removed by the author.
Ronald said...
This comment has been removed by the author.
Ronald said...
This comment has been removed by the author.
AnggieYola said...
This comment has been removed by the author.
Unknown said...

Tracking phone programs have been created to give you peace of mind and it helps keep families closely connected, have a peek at this site for more information!

Unknown said...

If you worry a lot about your friends/relatives/family, you can take a look at this phonetracking app that allows you to locate the person needed even without them know it.

Anonymous said...

Have you been worried about your spouse and kids activities online? Global Hackers offer the best service for cell phone monitoring. Hire a cell phone online

edok69 said...

Suggest good information in this message, click here.
หวย สำนัก ไหน แม่น สุด
ราคาบอลเต็ง

theispyoo said...

We are going to explore five different methods that will help you to track an iPhone by using the phone number alone. You can do this for free in some cases, or if you download a third-party app then you will be able to get access to tons more neat features.