(Werner Schuetz) A schema in DB2 is a collection of named objects, such as tables, views, nicknames, triggers, functions, and packages. Schemas provide a logical classification of objects in the database. A schema name can be up to 30 bytes long and is used as the high order part of a two-part objec
Author: SSWUG Research
Establishing ASP.NET 2.0 WebPart Communication
(Sahil Malik) I use a number of Web sites every day. Each Web site has a header, footer, some kind of navigation, and an area where I actually do my work. I am almost certain that each of these sites has “widgetized” or componentized its functional UI into smaller breakable pieces. For instance, the
An Introduction to the ASP.NET 2.0 Wizard Control – Validation
(John Peterson) This article is a follow up to my article An Introduction to the ASP.NET 2.0 Wizard Control, which was published a few weeks ago. It seems that many of you are unsure how to use the ASP.NET validation controls in conjunction with the new ASP.NET 2.0 Wizard control. The process is lar
WPF Windows: Code-based layout versus XAML
(Dragos Dumitru) With WPF, Microsoft introduced a new XML based descriptive language for use when designing interfaces called XAML. To help you use the new language, the company built in the VS forms desgigner support for XAML. Also, the Microsoft Expression Interactive Designer can be used to creat
Countdown to the end of DB2’s Private Protocol
(Willie Favero) The people at DB2 Development have been talking about DB2’s private protocol going away for what seems like forever. Can you say “No changes since DB2 Version 5”? That’s a heck of a long time to go with enhancements. And all through V5, V6, V7, and now V8 the subtle suggestions have
Predicates and Actions
(Ken Getz) It’s not that I’m lazy, but it really bothers me to have to manually iterate through all the members of a collection, taking an action on each. I wish I could just tell the collection what to do for each member and let it do the iterating. Well, guess what? On a recent exploration of the
Mini-tip #1 – Getting rid of spaces after TO_CHAR
(Lewis R Cunningham) I noticed on Dr Anton Chuvakin’s blog, Anton on Security that he started doing a Tip of the Week. I used to do a Thought of the Day. I think this kind of entry is useful, especially if it is interesting information and is kept kind of small.
Other MDX Entities: Perspectives
(William Pearson) As I state in Mastering Enterprise BI: Introduction to Perspectives, a member article of my series Introduction to MSSQL Server Analysis Services at Database Journal, Analysis Services 2005 extends the concept of a cube, and the more “geometrical” basis upon which it once rested, w
Using the OUTPUT Clause to Capture Identity Values on Multi-Row Inserts
(graz) SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables. Previously this data was only available through triggers. We can use this in an INSERT … SELECT statement to capture all the inserted identity values. Previously th
Validating XML Files Against XSD Schemas in .NET 1.x and 2.0
(Keyvan Nayyeri) XSD Schema, DTD and Relax NG are three common ways to validate a XML file structure. The first approach, XSD Schema, has been supported by Microsoft .NET Framework and is the best approach for .NET developers. Schema files are a special kind of XML file that define the structure o