(Shaun Eutsey) Today has been one of “those” days. A co-worker asks for something that sounds easy, but in reality it becomes larger than it ever should have been. That, my friends, is a recipe for a migraine and a learning opportunity.
Author: SSWUG Research
Populate a Flex Accordion with XML
(Glenn Gervais) I’ve been spending a lot of time lately learning Flex. So far I think it’s fantastic. I’m amazed at how easy it is to put together a nice looking dynamic application with so little code.
TechTip: Testing Stored Procedures
(Kevin Forsythe) If you’ve braved the intimidating unknowns of creating stored procedures, you’ve probably learned that support for them in IBM’s STRSQL command is limited. You can call a stored procedure only if it does not return a parameter or a result set.
Protect ‘Data at Rest’ Using DB2 on Linux, UNIX or Windows
(Rebecca Bond) When we think about security, we often mention the term “security in depth.” Layer after layer, we build our security architecture attempting to achieve a robust defense mechanism. We put in firewalls, build access control lists, devise elaborate intrusion detection schemes, enforce
Get CPU Attribution
(Marco Gilbert) The following query will allow you to see the CPU attribution of the first level plan and the CPU attribution of the subplans used by this plan. (The query assumes that your first level plan is named “PLAN…” and your subplan is named “SPLAN…”.)
Create/Edit operations and setCurrentRowWithKeyValue action in Oracle ADF
(Andrejus Baranovskis) This post is based on my previous post – Invoking Create method programmatically. I have decided to extend it and to show how Edit form for newly created data should be opened. While Create functionality is reused, in Edit form Master-Detail relationship is implemented. Master
Creating a Gantt-chart in SQL
(Lucas Jellema) There are many things that can help make this world a better place. A pure SQL-based Gantt-chart is not one of them. However, that is exactly what this article will present to you. So you might as well skip it.
Logical Functions: IsGeneration(): Conditional Logic within Calculations
(William Pearson) It should come as no surprise, to anyone who works with MDX on a regular basis, that, in working with multidimensional data, it is not uncommon to find ourselves confronted with business needs to have some calculated members give different results, depending upon “where in the cube
Two approaches to recording shift work in SQL Server
(Arthur Fuller) Assume that your organization has three shifts for its factory workers: 12:00 A.M. to 8:00 A.M., 8:00 A.M. to 4:00 P.M., and 4:00 P.M. to 12:00 A.M. Employees sign in using an electronic clock, which automatically adds records to the SQL Server database. From time to time, your organ
How alter table locks tables and handles transactions
(Eric Bergen) I’ve talked to several people that have questions about how alter table works under the hood. They want to know how it handles locking tables why they can sometimes use a table during alter table and other times they can’t. Also why it’s so slow.