Fellow SQL Server MVP Jasper Smith has come with a really neat tool named "Reporting Services Scripter" that makes managing multiple Reporting Services installations easier. It enables scripting of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to...

I was blessed with the opportunity to follow one of the best .NET brains in Omaha last night -- the Phil Canarski (sp?) -- with a quick presentation on using Reporting Services's Web Services as part of a Service Oriented Integration effort. Its just amazing some the stuff that folks are doing with Reporting...

Who: The "Best of the best of the best" from Blue Cross/Blue Shield of Nebraska - Al Zyck and Ravi Thoutireddy What: Overview of BCBSNE's multi-Terabyte, 64bit, SQL Server 2000/Informatica Enterprise Data Warehouse When: 2005-03-17 18:30:00-06:00 (that's 6:30PM Central Time, of course) Where: Vatterott...

SSWUG's daily newsletter announced it this morning: Getting Started with SQL Server Reporting Services Our next webcast, all about SQL Server Reporting Services, is just days away. Please register ASAP. Here's the description on this great opportunity to learn more about RS and get started quickly with...

I like doing things the simple way I guess. Here's an example of using the .nodes() method of an XML-type instance to produce a tabular shred of its data. Not hard once you figure out that its giving a new current context for each row. Continues here.

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 everything... Continues here.

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 feeds into a table. The basic gist of the problem...

There was a post this morning the SQL Server 2005 XML newsgroup that caught my eye. I don't know that I answered the poster's question exactly, but it lead to what I thought was an interesting example. So, here's another code-heavy article on showing how to do that.

I've just posted an article about how to install the AdventureWorks database into the default instance of SQLExpress . Not hard, but I thought if I could make it easier for folks, that's cut down on the complaining about it not being done by default.

I've posted my most code-dense article in ages over on SQLJunkies. It's a lifecycle walk-through of managing XML schema collections in SQL Server 2005 . And Mom said I couldn't just shut up and code...