(Brian Mains) Sometimes it is more costly to implement an object as it is. Because of that, it is easier to refactor the design into an alternative approach. It can be more efficient and easier to maintain and I am going to illustrate this with a class I originally created that needs to be refactore
Other News
CheckedListBox (1) – Checking, Unchecking, Comparing
(Ged Mead) This blog item was originally going to be about ten lines long and all I intended to show was how to programatically uncheck all items in a CheckedListBox in VB 2005. But, you know how it is, you think “Hmm, what about if …?” or “What if I … ?” and before you know it, you’ve got a […]
Implicitly Hidden Columns [DB2 9 for z/OS]
(Craig Mullins) Another nice new feature deep in the bowels of DB2 9 for z/OS is the ability to hide columns from the SELECT * statement. As far back as anyone can remember the advice has been given to avoid using SELECT * in application programs. But I still see it every now and then.
Metadata at Work
(Yves Schnabes) Navigating through a used book sale at my local public library, I was struck by the disorganization evident on each shelf. Cookbooks were stacked with children’s books, and sci-fi novels were mixed with historical biographies. Once I rifled through the mess for about an hour, I final
Expand Your SQL Server 2005 Dictionary Using Extended Properties
(Michael Klaene) There are a number of ways to obtain metadata in SQL Server 2005. Metadata, in the simplest terms, means data about data. Metadata is content that describes your application’s data and potentially how that data is used. Metadata is useful in many ways. Software vendors rely extensiv
Positing the Intelligence: Conditional Formatting in the Analysis Services Layer
(William Pearson) An important consideration, when designing a Business Intelligence system within any environment, is “where to put the intelligence” among the various “layers” within the system. I have stated many times in the past, in both articles and presentations, that “multi-layered reportin
Index Build strategy in SQL Server – Part 4-2: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)
A source partitioned table can be mis-aligned to the index partition in many different ways. For example, by using the same partition function and scheme, we can have non-aligned case like the following where the table and the index are partitioned on different columns.
Creative uses for coalescence in SQL Server
(Arthur Fuller) COALESCE() accepts a series of values and a value to use in the event that all items in the list are null; then, it returns the first not-null value. This tip describes two creative uses of the COALESCE() function in SQL Server.
How to eliminate temporary tables in MySQL
(Xaprb) I’ve written before about how to make MySQL replication reliable. One thing I think you need to do to make statement-based replication reliable is eliminate temporary tables. I found an elegant way to replace temporary tables with real tables in the systems I maintain. This article explains
Beyond SOA & Web Services – ColdFusion / .NET Integration
(Catalin Sandu) As both a .NET programmer and ColdFusion developer, I always wondered how I could leverage the world of .NET in ColdFusion. Both platforms come with powerful features and using them together might be a wonderful friendship, if one could only make them cooperate. There are two worlds