(Brian Moran) In March, I pointed you to a Microsoft survey about a new data-modeling tool that Microsoft hasn’t yet announced but is presumably planning. In my commentary “Data Modelers, Arise, and Take Microsoft’s New Survey”, I asked you what design features are most important for Microsoft to in
Other News
Programming SQL Server
(Jurgen Postelmans) This article will give you an overview how you can write stored procedures, triggers and user-defined functions in SQL Server “Yukon” using C# as a programming language.
Sorting a DropDownList by Value
(Trent Miesner) The DropDownList control does not expose a sort method to sort items by either the value or the displayed text. Usually this is not a problem because the DropDownList will display the items in the order they were loaded into the control. Typically it’s easy enough to ensure the data
Normalizing Syndicated Feed Content
(Mark Pilgrim) So you want to write a program to read RSS and Atom syndicated feeds. Sounds simple enough. After all, RSS stands for “Really Simple Syndication” (or “Rich Site Summary”, or “RDF Site Summary”, or something), and Atom is just RSS with different tag names, right? Well, not exactly.
Build Distributed Apps a New Way
(Patrick Meader) Visual Studio Magazine’s Editor in Chief Patrick Meader spoke with Microsoft’s modeling maven Keith Short recently about the new Visual Studio Distributed Architecture Designer technology, code-named “Whitehorse.” Whitehorse will be included in Whidbey, which is being previewed at V
Indexing in Oracle
In Oracle, several kinds of (clustered) indexing are supported. This page briefly explains the SQL DDL statements that can be used to setup (clustered) indexes.
Experiences with Real-Time Data Warehousing Using Oracle Database10G
(Michael D. Schmitz) The client has a number of plants generating energy to supply its customers. Each plant has a recommended maximum output capacity which leaves some reserve capacity in case the maximum is passed. Peak demand periods are usually somewhat predictable but do vary depending on w
Encrypt XML data with TEA
(Phillip Perkins) One of the biggest problems with XML is that it’s designed for humans to read. In some instances, this means that anyone spying on your data streams can see the data encased in your XML. (R)
DB2 Explains Itself: A Roadmap to Faster Query Runtime
(Greg Nash) Have you ever wondered why some of your queries take so long to run? Or how DB2 interprets your requests? As with all high-level programming languages, SQL must be translated into a set of smaller operations, which can be performed in turn. Because the efficiency of each operation ca
Using SOAP Header and SOAP Extensions in a Web Service
(Sovon Nath) We will develop a web service that would authenticate users for web sites. The web site needs to pass the user ID as well as the password for the user. Apart from this the web site also needs to pass the site’s ID and password. This information is needed so that the web service can