Mr. Bad Example

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

Browse by Tags

All Tags » Examples » SQL Server (RSS)
Reporting Services Scripter Rocks!
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...
Greg Low shows the value of DDL triggers
Aussie SQL Guru Greg Low shares a script the prevents changes to a SQL Server 2005 master database. Too cool.
Service Oriented Integration and the Reporting Services Web Services
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...
GoSQLServer March 2005 Meeting Annoucement
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...
It's Official: Kickstarting Reporting Services on SSWUG
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...
Installing the AdventureWorks DB on SQL Express
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.
Example: Using .nodes() to shred XML
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...
Posted: Nov 15 2004, 09:19 AM 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...
Example: Unioning XQueries results from Variable instances
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...
More Posts Next page »