(H.Tonguç Yýlmaz) Performance problem posts are maybe one of the most popular posts at forums. Usually what I see is the opponent does not provide any Oracle release information or any statistics related to his/her problem. So since usually we are after quick dirty solutions, answers come immediatel
Other News
Tip: Find all The Rows Where Any Of The Columns Is Null Or Zero Or Both
(Denis Gobo) This question is asked every now and then so I decided to do a little blog post. How can you quickly without writing a bunch of OR statements determince if any columns have a NULL value, a value of 0 or if the value is 0 or NULL?
How do I… Reject alpha characters in a SQL Server character column?
(Susan Harkins) Enforcing your data’s integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analysis and reports. It only takes one piece of bad data to throw everything off. It’s s
Oracle BI EE 10.1.3.3/2 – Dynamic Column Headers using Presentation Variables, Sets and Conditional Formatting
(Venkatakrishnan J) Yesterday we saw how to dynamically vary the columns in a report based on the column that we choose in a dashboard prompt. But if you had noticed, the column header in that report would have had a constant value. I got this question yesterday via email, whether there is any way w
Microsoft Windows PowerShell and SQL Server 2005 WMI Providers – Part 2
(Yan Pan) In part 1 of this article series, we illustrated how to access one of the two SQL Server 2005 WMI Providers – WMI Provider for Configuration Management, using Window PowerShell. We also illustrated how to use the provider to perform administrative tasks.
The Baker’s Dozen: 13 Comparisons Between Crystal Reports and SQL Server Reporting Services
(Kevin S. Goff) Recent polls show that nearly fifty percent of applications with reporting functionality use Crystal Reports, and about twenty percent use SQL Server Reporting Services. That popularity warrants taking a look at some of the major reporting tasks that developers face, and how these co
SQL Server 200x and Software Assurance – What Is The Answer?
New SelectViews Show Posted Need your help and opinion on a question in the show! We’ve just posted this week’s SelectViews show – I’m headed up to Microsoft later in the week and wanted to make sure we got the show out for you. Open source feedback, the SQL Server 2008 Slip, the 60-second SQL Server tip of the day […]
XSLT – On the Client
In the previous chapters we have explained how XSLT can be used to transform a document from XML to XHTML. We did this by adding an XSL style sheet to the XML file and let the browser do the transformation.
XPath Navigation Holding Back Database XML Industry
(Michael M. David) Having worked with hierarchical then relational and now hierarchical structures again with XML, I have been waiting for hierarchical database processing to progress at least to the point it was before. From this experience, I believe that XML’s use in database processing has faile
Still looking for open source DB2 monitoring tools?
(Fred) It’s fun when somebody crashes a dull party, and very few parties have been more dreary over the past few years than the gathering of open-source monitoring tools that work out of the box with DB2 LUW. After deploying and customizing Nagios for a few of my DB2 customers, I felt the need to wo