Mr. Bad Example

We're all examples: some good, some bad, some ugly.

Browse by Tags

All Tags » SQL Server XML (RSS)
April 2005 SQL Server Webcast Series
Discover how Microsoft SQL Server 2005 offers database developers the optimal combination of a tightly integrated development and data management platform . The rich and flexible programming environment in SQL Server 2005 allows you to leverage your existing...
XML Addict? SQL Junkie? I've got required reading for you.
Michael Rys posts links to three key white papers on XML storage, XQuery and XML indexing internals. What are you waiting for...? :)
Jeff Nolan demonstrates why I love XQuery.
He gets it and he offers a demo . It's happening... unstructured text search. Been a long time in coming and when it gets into the hands of users look out, a whole new way to manage information.
Non-obvious but true: SQL's XML type instances are not DOM documents by default
Darshan Sighn, publisher of YukonXML posted an interested question on the SQL2005 XML newsgroup yesterday asking how to force an untyped XML instance to be like an normal XML document where there is a single root element. I'm not sure there's a way to...
Yesterday's thinking, Today's Technology and Tomorrow's Problems
I think we're getting really close to a very interesting convergence of two very different forces that's going to be the catalyst for the next big thing. Force one: Yesterday's thinking is failing to give us the ability to build solutions today that help...
SQL CLR and XML: Saw the woman in two carefully
Aaron Weiker post drew my attention to Sahil Malik posting about SQLCLR UDTs, and Shawn Wildermuth's response . My response grew into this article . My advice is to listen to Warren Zevon warning... I can saw a woman in two, but you won't want to look...
If you're not already subscribed to the SSX Blog RSS...
...you better get on it ASAP . I'm hopefull that we're going to see a blizzard of activity there in the next few days related to SQL Server 2005 Express, Express Manager (XM) and build releases. 'nuff said?
Microsoft Word 2003: WordProcessingML Transform Inference Tool
Well now isn't this interesting... I've not cracked it open yet, but one of the big use cases I see for the XML type in Yukon is the storage, query and serving of WordDocs. Now sure, you can use XQuery to shape the XML you from those instances, but sometimes...
Posted: Nov 12 2004, 05:56 PM by ktegels | with no comments
Filed under: ,
Example: Loading RSS feeds into an SQL Server 2005 XML column Redux
Kirk and I are having a lot of fun with this RSS issue. Here's an updated version of my previous example that copes with Unicode BOMs and pre-validates the fetched RSS before it attempts to store it. It demonstrates that typed XML really does validate...
Example: Loading RSS feeds into an SQL Server 2005 XML column
There's been a brief discussion on the SQL Server 2005 XML newsgroup regarding RSS and the XML type on SQL, encoding and schema. In keeping with my recent series of code-heavy examples, here's the guts of a primvative little VB.NET console app that sucks...
More Posts Next page »