(Kai Zeller) How to set up the feature ‘Display the hierarchical information for crosstabs and charts in the report output’ (Breadcrumbs) within IBM Cognos Analysis Studio.
Other News
Hiding parameters and using default parameter values in SSRS reports
(Siddharth Mehta) Many times in a parameterized report, we may come across situations where we need to execute a report using a fixed parameter value depending upon the users group. In such cases, displaying a list of parameters to the user would not make sense.
Separation of Customer Data for Hosted Solutions
Virtual Workshop: SQL Server 2008 Indexes – Internals and Best Practices Feb. 25, 2011 Along with a good database design I would say that Indexes are a cornerstone to good database performance. There are a lot of other skills you can develop in relational databases; but without these two skills, you’re going to find yourself in a heap of trouble. […]
Database Controls are not Only History Tables
DBTechCon – Spring 2011 The SSWUG Spring 2011 virtual conference is quickly coming together. You can go to the registration page and see profiles for presenters, and summaries for the sessions to be presented. Without a doubt, this will be the largest virtual conference in the information technology industry. Access more than 70 sessions from well seasoned professionals with in-depth […]
How to Create Xml Poll
(ayrilmaz) The subject of our new article is to develop a simple and a nice poll application that we can use in our web-sites. Although most of the samples use the database to save the poll data, our choice will be xml.
Thinking about the HTML and XML
(Norman Walsh) After considering a set of use cases, the HTML/XML Task Force has decided to issue a report of its findings. This is not that report. These are some notes, musings, and experimental prose.
Validating e-mail in PL/SQL
(Scott Wesley) This seems like a frequent request across all languages. I google search can give you all sorts of options for validating a singular e-mail address.
APAR UPDATE – INSERT performance in critical DB2 9 for z/OS tables
(Julian Stuhler) Many DB2 experts have given excellent presentations on this important subject, and there are several good techniques you can use to reduce the elapsed time for high-volume concurrent INSERT operations.
Visualizing BI with Infragistics NetAdvantage for Silverlight Data Visualization
(Peter Vogel) The Infragistics Data Visualization bundle includes a wide variety of controls for converting data into visual displays: two kinds of graphs covering every format I know of, two charts (one targeted for static data and another for handling live data streams), a configurable gauge contr
Controlling Growth of a Distribution Database
(Satnam Singh) I was recently asked to set up Transactional Replication comprising of 29 publishers as well as same number of subscribers. One interesting challenge was that the size of the distribution database suddenly increased from few MB’s to around 62 GB and as a result the disk on which the p