(Partha S) Recently had to design a Windows app that would display a status of database operations.
Author: SSWUG Research
Namespaces, Tables, and Schemas, Oh My
(W. Eliot Kimber) The rant of the day is not really a rant as a conundrum: what’s the best way to enable recognition of standard XML types that are intended to contain arbitrary stuff from non-standard namespaces such that the schemas governing the non-standard stuff can constrain the rules for what
Reporting on Hierarchical Recursive Data Using MS Reporting Services
(Asif Sayed) I will start with a question here. How many of you had chance to interact with the Employee table from Northwind sample database? There you go…. I can imagine countless hands in air, and why not? It is one of the standard databases that comes with both Access and SQL server. All right
Developing Applications on Oracle 10g XE: Generating a Report
(Jayaram Krishnaswamy) This tutorial shows you how to create a report based on a table in the Oracle 10g XE database without stepping out of the IDE. It will show you how to manipulate the report and create a UI.
MDX Operators: The IS Operator
(William Pearson) While MDX functions comprise the lion’s share of the MDX Essential series, numerous operators are supported within the language. (We examined a group of basic operators in my Database Journal article MDX Operators: The Basics). Of the logical, comparison, set, string, and unary ope
Understanding – DBCC SHOW_STATISTICS
(Vinod Kumar) Most SQL Server internal is undocumented, and even if they are documented there is hardly any information anyone can get out of these. So here is one such attempt where I take the DBCC SHOW_STATISTICS command and try to understand what it is trying to give us as useful information. I h
Analyst: Oracle lags behind SAP on compliance
(Mark Brunelli) Enterprise resource planning (ERP) software vendors like SAP AG and Oracle are racing to offer customers a comprehensive strategy for complying with data retention regulations. And when it comes to these two longtime rivals, SAP is definitely in the lead, according to one industry an
Behind the Scenes with XHTML
(Lee Underwood) In a previous article, we quickly touched on the requirements for proper XHTML coding, especially in relation to HTML 4.01. In this article, we’ll take a closer look at what some of those requirements are in relation to the head portion of the Web page. This is the portion of the doc
Users Declare: Thumbs Up (Mostly) For Microsoft’s BI Stack
(Stephen Swoyer) Make no mistake about it: Users are excited about Microsoft Corp.’s aggressive business intelligence (BI) push.
Retrieving settings in different XML configuration formats
(massivegas) We always use the regular app.config or web.config. But sometimes, we want our configuration files more flexible. Here’s a simple piece of code that will allow us to use more costumizable config files.