(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
Author: SSWUG Research
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
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.
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 […]
Refactoring to State/Strategy
(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
Auto Resize Dropdown Box
(Ashish Singh) Sometimes, using a built-in dropdown control does not meet your requirement. Suppose a dropdown box contains text that is longer in length than your box; therefore, the width of the dropdown will increase as the text length increases. But, an increase in the dropdown’s size affects yo
Create and work with DB2 for z/OS stored procedures, Part 3: Create package variations and perform deployment on procedures on DB2 for z/OS V9.1 using IBM Database Add-ins for Visual Studio 2005
(Vasantha Jayakumar) Using the IBM Database Add-ins for Visual Studio 2005, you can now avoid the manual steps that have previously been required to deploy a stored procedure on a second target server. In addition, you can also easily view, create, and drop packages for stored procedures. Each packa
Extract an XML Schema from a .NET 2.0 ConfigurationSection subclass for Configuration Validation & Intellisense in Visual Studio
(Steve Ward UK) .Net 2.0 introduces significant changes to the System.Configuration namespace. There are plenty of articles out there that already deal with the new ways of using the configuration classes. This article will not try to steal their thunder by essentially copying their content here. In
21-hours Phantom SELECT Causing ORA-1555 ’snapshot too old’
(Alex Gorbachev) One of our clients had an ORA-1555 “snapshot too old” error two nights in a row. The quick and dirty fix would be to increase the retention_period and the potential size of the UNDO tablespace.
Invalid or unsupported parameter ‘JOB_QUEUE_INTERVAL’
(Byte64) If you worked with version 8i, you probably remember the initialization parameter JOB_QUEUE_INTERVAL.