(Craig Shallahamer) When performance data is periodically collected (i.e., snapshotted) and stored, the question undoubtedly will cross our minds, “Is the stored value correct at the beginning or the ending snapshot time?” In relation to Oracle’s AWR system and specifically the dba_hist_sysstat tabl
Other News
How to validate using Data annotation(MVC tutorial number 11)?
(Questpond) In this article we will try to understand how we can use data annotations for doing validations in MVC web application.
Improving .NET Application Performance Part 6: Threading
(Ard-Jan Barnas) In our last article we discussed some guidelines to optimize Garbage Collection using the Dispose and Finalize methods. In this article we’ll look at best practices for using threading. The .NET Framework offers various threading and synchronization features. Using multiple threads
Modifying Tables Online – Part 1: Migration Strategy
(Michael J. Swart) In the next few days I want to describe a way to modify the definition of very large tables while keeping the table available for other queries. Some table changes are already online operations. But offline changes need extra work to keep the table available. I explore one way to
DB2 10.1 – Time Travel Query
(Clara Liu) In this video, you will learn how you can use DB2 V10.1 Time Travel Query.
Rollback in Data Import Task–SSIS
(VidhyaSagar) I was working in a package and I was requested to set the import task as transaction consistent. In SSIS you can do all sorts of ETL stuff so when you import data you need to make sure the import is in consistent state which means either all the data should gets loaded or it should be
DB2 for z/OS: Trading Memory for MIPS (Part 2)
(Robert Catterall) In part one of this three-part entry on leveraging System z memory to reduce CPU consumption for a DB2-accessing application workload, I wrote about getting your DB2 buffer pool configuration house in order by doing things to improve CPU efficiency without increasing the total amo
ColdFusion 10 – Selectively Exposing ColdFusion Component Behaviors – Part II
(Ben Nadel) Yesterday, I looked at using ColdFusion 10’s Closure syntax as a light-weight, class-free way to expose selective behaviors on ColdFusion components. This was inspired by a Douglas Crockford presentation that talked about giving objets only as much authority as they need to get the job d
Why you should use a SQL Alias with SharePoint
(Neil King) Recently I was asked to take a look at a SharePoint 2007 system that was having a few problems after an IP readdressing project.
Another way to work with MySQL process list
(Maciej Dobrzanski) In an earlier post titled “How to work with a long process list in MySQL”, we showed a neat way to work with the process list by using various shell tools. But some of that can also be done using pure SQL.