SQL Server 2005 and Other Database Links
Using Webservices and Xml Serialization in CLR Integration
“Calling webservice methods requires serializing all the types being used to xml. Outside SQL Server, this serialization code is generated at runtime, compiled and loaded in the application. However, for security and reliability reasons, SQL Server does not allow you to dynamically load assemblies.” This post addresses this constraint in SQL Server 2005.
SQLCMD Utility Tutorial
“You can use the sqlcmd utility, a Microsoft Win32 command prompt utility, to run ad hoc Transact-SQL statements and scripts.” This information was attractive to me until Microsoft figured out how to get the SQL Management Studio CTP loaded on my development workstation.
A Dynamic Sql-Based Self-Caching RSS Feed Generator
This article is a SQL-Server-centric follow up to my earlier post about the role of HttpHandler.
Introduction to XML Extender
“XML Extender provides the ability to store and access XML documents, to generate XML documents from existing relational data, and to insert rows into relational tables from XML documents.” I first heard about this tool from a Java programmer who says this tool sucks. I think he said something like 12 relational tables are needed just to parse one XML document. He refuses to name the authority figure that authorized is featured use in our 3.x version application. There is an approved proposal to remove XML Extender in out 4.x version.