Explore different ways of dealing with disparate data sources in Cognos BI, particularly Report Studio and Framework Manager, and identify the pros and cons to each method. This article includes tips on how to reduce performance impact where applicable.
Other News
Convert SQL Server DateTime Data Type to DateTimeOffset Data Type
(John Sterrett) I saw this tip on new date types provided with SQL Server 2008. I am interested in using the datetimeoffset because we support end users around the world. How do I convert the datetime data types to the datetimeoffset data type in SQL Server 2008?
Oracle Options on Itanium
Back by Popular Demand – SSIS and SQL Replication Virtual Courses Taught by SQL Server MVP Eric Johnson, these virtual online courses provide you in-depth information for SQL Server Replication and SQL Server Integration Services. These 12 sessions are a clear value, at $169 for full SSWUG.ORG members and $199 for non-members. Registration ends March 31. Courses are available for […]
Oracle Drops the Bomb
DBTechCon – Spring 2011 Hosted by SSWUG.org. Have you been putting off registering for DBTechCon? The wait is over. Due to the high level of interest in DBTechCon SSWUG has been able to secure many sponsors for the event. This results in great savings to you. In the past our rates were $279 for non-members and $249 for members. Sign […]
XPath is to XML as regex is to text
(Ben Bass) Anyone who has been a developer for a while gets familiar with regular expressions. They eat text for breakfast, and spit out desired answers. For all their cryptic terseness, they are at least in part reusable, and are based on only a handful (or two…) of rules. ‘regexes’ are a domain-
Try XML-based Extensible Business Reporting Language (XBRL) for accounting reports
(Jack Vaughan) A few years ago XML came to the fore – right away it was chock full of ways to transfer metadata over HTTP. That was the good news. The bad news was that there were so many industry-specific standards that it was difficult to keep track or keep up.
How do I know what extended statistics are needed for a given workload?
(Maria Colgan) In our previous post we introduced extended statistics, which help the Optimizer improve the accuracy of cardinality estimates for SQL statements that contain predicates involving a function wrapped column (e.g. UPPER(LastName)) or multiple columns from the same table used in filter p
Using Flexviews – part one, introduction to materialized views
(Justin Swanhart) If you know me, then you probably have heard of Flexviews. If not, then it might not be familiar to you. I’m giving a talk on it at the MySQL 2011 CE, and I figured I should blog about it before then. For those unfamiliar, Flexviews enables you to create and maintain incrementally
SVG Path Attributes to Draw a Freehand Shape
(Darla Ferrara) Path is the scalable vector graphics version of a pencil. By utilizing the shape element <path>, you can draw something freehand. This is complex because you are not physically drawing a shape. You are giving directions to draw the shape.
I Finally Understand The Finally Part Of A Try/Catch Control Statement
(Ben Nadel) I love a good Try / Catch block! In fact, I used one just the other day when dealing with transactional rollbacks involving 3rd party APIs. But, as far as the Try / Catch control flow goes, I never quite understood the need for a “Finally” statement; if you have a Catch statement, why no