Featured Article(s) Is it Time to Terminate an Employee A few years ago I had to make an incredibly hard decision on whether I let an employee go or if I tried to keep that person on my team and develop that persons skill set. Far too often people determine a DBAs skill set by only factoring in how much […]
Other News
Hints And Pitfalls In Database Development (Part 5): The Importance Of Choosing The Right Clustered Index
(Arno) In database design, a clustered index defines the physical order in which data rows are stored on disk (Note: the most common data structure for storing rows both in memory and on disk are B-trees, so the term “page” can also be interpretated as “B-tree leaf node” in the following text, altho
Using Visual .NET Components
(Bruce Armstrong) Microsoft recently released the Interop Forms Toolkit 2.0 in order to allow “developers to incorporate VB.NET Forms and Controls into their VB6 applications.”
Faking VB.NET Events in Code
(Dan Mabbutt) A few days ago, I wrote about how Focus and Select seem to almost completely duplicate each other. That’s not the only duplication in VB.NET. For example, the Button object has a PerformClick method. But it totally duplicates simply calling the event directly.
.NET Tip: Converting Strings to Numbers
(Jay Miller) First, take a look at the Convert class. The Convert class offers methods to convert to and from every base data type, but for the purpose of this tip I’m only going to use the Convert.ToInt32() method. The method accepts a string parameter and returns an integer. If you pass in a strin
The Trouble With XML Schema Imports and Includes
(Anthony Coates) Any of you who have written W3C XML Schemas will know that there are two mechanisms for sharing Schema definitions across files. is used like traditional programming language “include” statements, so that you can split a single large file up into separate, modular piec
XHtmlTree – Tree control with support for HTML, XML and Smart Checkboxes
(Hans Dietrich) Everyone is familiar with tree controls: every time you open Windows Explorer, you see file system hierarchy as a tree. Another kind of tree is used by some programs, such as installers, to allow you to select options to install. When all options of a particular subtree are selected,
Extracting data from a xml-mapped document
(Wouter van Vugt) I have just returned from an MSDN InTrack session over here in the Microsoft Technology Center about Office Open XML and I wanted to share one of the demos I created for this event with you. The demo app extracts XML data from an XML-mapped WordprocessingML document. Note that this
What Happens to Your Data When it Gets Old?
(Robert Catterall) At way too many sites, the answer to this question is, “Nothing.” Application developers and DBAs spend lots of time figuring out how data in a database will be inserted, updated, and retrieved, but all too often the matter of removing data from the database ends up getting deferr
Long in the Tooth Query/400 Gets a Replacement
(Robert Gas) Like those of an aged race horse, the glory days have passed for IBM Query for iSeries (aka Query/400).