(Susan Lawson) To reduce elapsed time for a query, DB2 can give queries parallel resources, such as several I/O paths or processors. By taking advantage of these resources, queries can run in a shorter period of time, enabling more work to be pushed through the system. Parallelism can help improve t
Other News
New Flashbook for DB2 10 – Launching at IDUG Denver
(Susan Visser) Yet another great reason for you to attend IDUG in Denver this May… we are launching the latest Flashbook.
ColdFusion 10 – ColdFusion Query Of Queries vs. Functional Programming
(Ben Nadel) For years, I have been a huge fan of the ColdFusion query object and the power of ColdFusion query-of-queries. While at times, they can present some funky and irksome data-type behaviors, these query-based operations have made storing, accessing, and mutating internal data structures a t
Getting to the Share(Tipping)Point
(Ed Deiss) Getting to the Share (Tipping) Point involves users seeing demonstrable evidence that leveraging SharePoint capability results in increased productivity and effectiveness.
Was a query served from MySQL Query Cache?
(Maciej Dobrzanski) The MySQL query cache is a special buffer, where database stores the text of a SELECT statement together with the corresponding result that was sent to the client. For as long as no table that a statement refers to changes in any way, including the contents, the cached result can
IBM Cognos Proven Practices: Use Case: Tracking Down an Intermittent IBM Cognos Report Not Returning any Data
This document is intended to provide a troubleshooting methodology which incorporates publicly available utilities to diagnose and resolve an issue identified within a specific use case. The use case will be presented as a scenario where an IBM Cognos Support Analyst is working with a client to diag
Data Driven Colored Text for Reporting Services Reports
(Brady Upton) How can I color code certain entries in a SSRS report? In SSRS you can use data driven expressions to color code certain rows, so check out this tip to see how to accomplish this.
Is it Time for ORMs?
SSWUGtv With Stephen Wynkoop On the show today we have Kevin Kline as he shares his thoughts on why Big Data is important Watch the Show Is it Time for ORMs? Object Relational Mapping tools have been around for years, and are still a controversial issue. Coming from a DBA background I find them to be both a friend and […]
Ben Taylor and Stephen Wynkoop talk about the very recent SSWUG.ORG makeover and move to the cloud.
Pro-Center Video Programming for IT Professionals
Database Version Compatibility
Database Version Compatibility Today we have a couple comments that I found quite interesting. Robert talks about the ORDER BY clause in Views being supported, deprecated, and returned once again. Sanders shares thoughts about using features beyond those ANSI defines for SQL Engines. Robert writes: ORDER BY IN VIEWS! First it was there, then it was gone, then it was […]