(Solmaz Kolahi and Leonid Libkin) Design principles for XML schemas that eliminate redundancies and avoid update anomalies have been studied recently. Several normal forms, generalizing those for relational databases, have been proposed. All of them, however, are based on the assumption of a native
Other News
Extended TreeView
(G. Mohyuddin) It is a TreeView Control that has been extended from the ASP.NET TreeView shipped with .NET Framework 2.0. By extending it from the built in TreeView control, the purpose is to have all basic features of the existing TreeView with some new features, which are highly required but are n
Using the DOM class in AJAX with the GWT and Java
(Richard G. Baldwin) Historically, the development of Ajax web applications has been a complex process. This is due mainly to the requirement to learn and use a variety of technologies, such as HTML, JavaScript, XML, ASP.NET, Java servlets, various scripting languages, etc.
SQL Server 2005: Using OVER() with Aggregate Functions
(Jeff Smith) One of new features in SQL 2005 that I haven’t seen much talk about is that you can now add aggregate functions to any SELECT (even without a GROUP BY clause) by specifying an OVER() partition for each function. Unfortunately, it isn’t especially powerful, and you can’t do running total
Generate RSA public and private keys, export to XML
(Stefan Prodan) The following method shows how RSA keys can be saved to disk as an XML file. The XML files can then be used to make an RSA secure channel — the public key is used for encryption and the private one for decryption. (R)
Intelligent Layering: Leverage Conditional Formatting Logic from Analysis Services
(William Pearson) The reporting / presentation layer of the integrated Microsoft business intelligence solution is often the only point of interaction for organizational information consumers. It is here that we often find it desirable to manifest the effects of conditional formatting. Conditional f
Moving domain index to another tablespace
(Pawe³ Barut) It seems to be very easy task that can be accomplished using rebuild option: ALTER INDEX MY_INDEX REBUILD TABLESPACE NEW_TBS;
Creating Oracle Table and Column Names that Start with an Underscore
(Amit Jain) Typically, as part of the product installation, applications/products are required to create some database tables. It’s a good practice to isolate product installation tables from the application/solution specific tables.
Taking the Guesswork out of SQL Server Performance Profiling Part 2
(Mario Broodbakker) In the previous article, Dude, where’s my time, I described a method, based on use of SQL Server wait events, for measuring response time and pinpointing the main bottlenecks in your SQL Server applications.
Getting PHP to Talk to MySQL
(Michele Davis and Jon Phillips) In this first part of a three-part series. you will begin learning how to use PHP to display and modify data from a MySQL database.