(John Papa) This article will explain how to create a custom Windows Service that retrieves posts from multiple RSS feeds and then stores them in a SQL Server database. Once you store the posts in the database you can then retrieve them and display them on a web site, so you can combine multiple fee
Other News
Preserving XML queries during schema evolution
(Mirella Moura Moro, Susan Malaika and Lipyeow Lim) The always evolving context of the Web imposes the challenge of how to accommodate new functionalities and new data types in the database that underlies a Web application or service. For XML databases, new schema versions can be released as frequen
Get a handle on directory security with .NET’s DirectorySecurity object
(Tony Patton) An important topic when working with .NET directories is security; that is, you want the users who need to access a directory to have it and restrict other users from the directory. This article examines the details of controlling and setting security at the directory level.
Using Java to Produce SVG Code in XHTML Data
(Richard G. Baldwin) This is the third lesson in a series designed to teach you how to write servlets to produce SVG code that will be rendered in graphic form by an SVG-compatible browser. In this lesson you will learn how to write Java code to produce XHTML files containing in-line SVG/XML code.
‘Myth-Busting DB2 Version 8 CPU Regression’ in z/Journal Magazine
(Willie Favero) Cute title, right? That’s what we called my latest article in z/Journal Magazine. If you like to take a look at the pre-publication of this article, go here: “Myth-Busting DB2 Version 8 CPU Regression”
Temp Tables and Table Variables: When To Use What And Why – Part 1
(George P. Alexander Jr.) An experience I had once upon a time made me look at writing efficient code even more seriously and meticulously. You usually learn these things the hard way and for me, this was one of those situations where you had to clean up someone else’s code and such an excerise teac
Important New Concepts in Windows Presentation Foundation
(Adam Nathan) To finish Part I of this book, and before getting to the really fun topics, it’s helpful to examine some of the main concepts that WPF introduces above and beyond what .NET programmers are already familiar with. The topics in this chapter are some of the main culprits responsible for W
Performance Impact of Using NTFS Compression with Read-Only Databases
(Linchi Shea) SQL Server 2005 supports placing read-only filegroups or read-only databases on NTFS compression. In other words, you can compress the database files in a read-only filegroup or a read-only database. This can be a very useful feature if saving disk storage is of high priority.
Improving the performance of queries using SQL Server Part 2
(Pete O’Hanlon) In the previous article SQL_Server_Performance.asp, we discussed using SQL Profiler to identify queries that need looking at, to see if performance can be improved. We learned how to set the criteria that allow us to focus on the queries that are most likely to give us performance ga
Left, up, down, right … GROUP!
(Tim Dexter) The majority of reports I see are laid out as what is termed ‘group above’, the break groups appear above the detail data thus.