Browse by Tags

• Events and Community
• Examples
• SQL Server
• SQL Server CLR
• XML

• 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... Posted Apr 05 2005, 08:06 AM by ktegels with | with no comments Filed under: SQL Server CLR, SQL Server XML, Events and Community

• 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...? :) Posted Feb 23 2005, 07:42 PM by ktegels with | with no comments Filed under: SQL Server XML, Examples, XML

• 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. Posted Feb 22 2005, 05:32 PM by ktegels with | with no comments Filed under: SQL Server XML, Examples, Events and Community, XML

• 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... Posted Feb 18 2005, 08:48 AM by ktegels with | with no comments Filed under: SQL Server XML, Examples, XML

• 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... Posted Feb 17 2005, 11:55 AM by ktegels with | with 1 comment(s) Filed under: SQL Server, SQL Server XML, XML

• 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... Posted Feb 07 2005, 07:19 AM by ktegels with | with no comments Filed under: SQL Server CLR, SQL Server XML

• 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? Posted Nov 17 2004, 12:19 PM by ktegels with | with no comments Filed under: SQL Server, SQL Server CLR, SQL Server XML, Events and Community, XML

• 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 | with no comments Filed under: SQL Server XML, XML

• 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... Posted Nov 10 2004, 08:20 AM by ktegels with | with no comments Filed under: SQL Server, SQL Server XML, Examples, XML

• 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... Posted Nov 09 2004, 09:49 AM by ktegels with | with no comments Filed under: SQL Server, SQL Server XML, Examples, XML