Native XML Web Services (HTTP endpoints)...deprecated for SQL 2008

I noted that SQL Server Magazine's issue last month (January 2009) had a feature outlining all of the deprecated TSQL for SQL Server 2008. One that was either missed, overlooked, or simply left out, was the functionality and associated syntax relating to Native XML Web Services; yep, it's been put on the chopping block for the next release. What's interesting about this deprecation is that Microsoft gave us nothing in SQL Server to revert to, possibly the first that I have seen where they didn't provide a "Ok use this now instead". Well, I take that back - the entire SSNS (Notification Services) went bye bye without directing users to new or other avenues, AFAIK. The community content of the announcement directed you to 1) web services, 2) Bob Beauchamin's blog on what probably replaces the technology, 3) a tutorial on WCF and Linq, and finally, 4) a link to explain WTH WCF is in case you happened to choose #3.

Microsoft should understand that not everyone uses true n-tier when building their applications, not everyone uses ORM tools to resolve "impedance mismatches", and not everyone has a nice DAL/BLL to do things the way folks these days think it should be done. Do I like the technology? Maybe. Could I find a reason to use it? Sure. Never say never when programming and developing. Matter of fact, those that do I tend to avoid like the plague. Additionally, Microsoft should realize that people build applications with the tools that they provide and expect them to be there for awhile, especially if they work well. They spend dollars developing applications to hopefully use for awhile, since rewrites every other year tend to be rough on the budget. It's not necessarily Native XML Web Services in itself that is the problem here, but rather, the way things get deprecated these days. Personally, inside the firewall, this is a good method for exposing data in my opinion. Who cares that SQL Server presents to http.sys the data source?  It's funny that, while this is a pretty well-thought out methodology - and they're getting rid of it - I was shocked to find the old sp_OA stuff still exists.

Lee

---------------------------------

"Impedance mismatch". Are you kidding me? Give me a frickin' break! LMAO

[http://sqlmag.com/Articles/ArticleID/100697/100697.html]