HowTo: Grow a very large MS-SQL Log File
Microsoft SQL Server 2005 has a nasty habit of creating thousands or hundreds of thousands of logical log files even though you set Autogrowth to a large size, say 8GB. The following SQL code automates manually growing your log file by 8GB increments. When using the ALTER DATABASE command to modify log file size manually like this, SQL Server seems to properly create logical log files of around 1GB each resulting in far less logical log files overall. This should increase log file performance. Read more
Remove Custom Menu Bars from Microsoft Access 2003
Run the following command from the VB Immediate Window (CTRL-G) inside Microsoft Access to remove any custom command bars present in the currently loaded database:
CurrentDb.Execute “DELETE * FROM MSysAccessStorage WHERE ParentId IN (SELECT msa.Id FROM MSysAccessStorage AS msa WHERE msa.Name = ‘Cmdbars’;);”
Execute the following code to completely remove all custom command bars Read more
Track application crashes and disable Windows Error Reporting at the same time!
Recently we’ve been experiencing a number of software failures company-wide in our custom-built line-of-business app. The application connects via Web Services to the Sabre GDS to obtain hotel room pricing and availability at multiple hotels simultaneously.
The application is multi-threaded, consuming upwards of 300 or more threads during Read more

