Geeks With Blogs
David Douglass .NET on My Mind November 2008 Entries
Garbage Collection in VB6 and .NET
I've noticed some confusion amongst VB6 programmers who've moved to .NET regarding garbage collection, so I'd like to explain the differences. VB6 is built on top of COM. In COM, each object has a hidden reference count inside it, a count of the number of in scope variables that point to the object. When you new an object the reference count is set to 1. If you then assign that variable to another, the reference count is incremented to 2. As those references go away, either by variables going out ......

Posted On Sunday, November 30, 2008 11:47 AM

Quick Database Sanity Check
My project is on the move, literally. We're migrating from our old data center to a new one; everything is being brought up on new hardware. Since we're using full and incremental backups, an important sanity check is to make sure all the data has been restored, which is being done using the following query: select 'select ''' + TABLE_SCHEMA + ''' as TableSchema, ''' + TABLE_NAME + ''' as TableName, count(*) as [Rows] from ' + TABLE_SCHEMA + '.' + TABLE_NAME + ' union' as [SQL] from INFORMATION_SCHEMA.TABLES ......

Posted On Friday, November 28, 2008 8:43 AM

Copyright © David Douglass | Powered by: