(Dan Mabbutt) Most tutorials (including tutorials on this site) about programming a class will emphasize the Property statement and how it works with the Class constructors (the New subroutines) to instantiate the class.
Other News
How to remove duplicate rows from a table in SQL Server
Microsoft SQL Server tables should never contain duplicate rows, nor non-unique primary keys. For brevity, we will sometimes refer to primary keys as “key” or “PK” in this article, but this will always denote “primary key.”
Using PowerShell to Manage SQLServer
(Fabiano Pereira) The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs.
ADF BC: Creating an ‘EXISTS’ View Criteria
(Chris Muir) The EXISTS keyword in SQL queries is an efficient mechanism for returning record sets from one dataset when they exist in another dataset. For example we can write queries like:
Plan Stability Through Upgrade-Why is my plan changed?-new optimizer parameters
(Coskan Gundogar) Every Oracle version, developers at Oracle add or change some of the undocumented parameters to do better optimization. Most of the time these new optimizations works fine but from time to time they have a negative effect for the generated plan which causes post upgrade slowness.
Qualifying Column/Object names to set the right scope
(Hemant K Chitale) Earlier today, I had a curious query that I knew was returning the wrong results.
Best practices for migrating to SharePoint 2010
(Shawn Shell) With the release of SharePoint 2010, Microsoft continues to grow its already compelling content management platform. And although many enterprises are thinking about a move to SharePoint 2010, they aren’t necessarily coming from the same place.
Simple lessons in improving scalability
(Ronald Bradford) It can be very easy to improve scalability with a MySQL server by a few simple rules. Here is one of them.
Experimenting With Sub() And Deferred Objects In jQuery 1.5
(Ben Nadel) jQuery 1.5 added a method called sub(). I’m not entirely clear on what sub() does or how it works(); but, from what I can gather, it creates a sub-class of the jQuery object in an effort to let you augment a copy of the library without permanently damaging the core jQuery instance.
Monitoring an ERP Application in DB2 for z/OS
(Lockwood Lyon) Monitoring an ERP application suite involves using several basic measurement techniques. Since it probably co-exists with other applications within a DB2 subsystem or data sharing group, a means must be found to separate ERP package performance measures from those of other applicatio