(Rob Crowther) The Semantic Web brings with it the opportunities for users to get smarter search results, and for site owners to get more targeted traffic as users find what they really want. But these benefits don’t just magically appear. This article leads you through the aspects of both informati
Other News
R12 : Management Reporting Security
(Sanjit Anand) Do you know, in R12 there is a new management segment qualifier for your chart of accounts. This would qualify a segment to be the management segment if that segment has management responsibility and you can facilitate setting of Read, Write access permissions while defining Data acce
A first look at the Dynamic Data Engine—the DynamicGridView Control
(Dino Esposito) Dynamic Data Controls are a new family of strongly-typed data-oriented controls made available with the first CTP of ASP.NET 3.5 Extensions. Right after installing the package, a brand new project template shows up in your Visual Studio 2008 project box – Dynamic Data Web site. If yo
SQL Server 2008 XML: XML DML Enhancements
(Stephen Forte) Yesterday we discussed the changes to XQuery by allowing LET statements. Today the last XML enhancement is an “enhancement” to XML DML.
Observing the MySQL Query Log
(Martin Brotzeller) Debugging an existing application can be hard to bootstrap. Sometimes it just helps to observe the queries a web application is sending to the database. Unfortunately, the MySQL Query log does not directly tell the user which query goes to which database.
Create an upgrade plan for your move to SQL Server 2005
(Denny Cherry) The key to a successful upgrade project is proper planning. Without a proper plan, there’s no way to guarantee the upgrade project will be successful and completed on time. Moving from SQL Server 2000 to SQL Server 2005 is a major upgrade, much like the upgrade from SQL Server 6.5 to
Building Cubes with SQL Server 2005 Analysis Services
(Thomas LaRock) I admit that when it comes to SQL Server Analysis Services (SSAS), I found plenty of reasons to not get started. I have enough to do on a daily basis and I was just not very interested in learning about how to build cubes. Also, there is not much of a demand for cubes where I current
Support Parameterization from Analysis Services
(William Pearson) In this article, we will work with an identical copy of the basic OLAP report we created in Customize Automatically Created Parameter Support Objects Pt. I. We will continue working within the scenario we established within that article, again with an objective of meeting the need
Oracle Diagnostic Tools – Some Random Thoughts (Hammer To Fall)
(Richard Foote) There’s been a bit of discussion lately and some interesting opinions aired, such as those by Daniel Fink , Doug Burns, and Alex Gorgachev regarding the whole issue of the usefulness or otherwise of various Oracle diagnostic tools (such as Statspack, AWR, ADDM, Extended Tracing, etc)
Using XML Package Configuration with SQL Server Integration Services (SSIS) Packages
(Ray Barley) We have adopted XML configuration files as a standard development practice within our organization. We use them in ASP.NET web applications as well as Windows Forms applications. How can we use XML configuration files with our SSIS packages?