majorsilence

Sample code for exporting scripts to drop and recreate all user defined Stored Procedures and Functions in a database.

The code uses SQL 2005/2008 Server Management Objects to accomplish this task. It loops through all functions and SPs and writes drop command for each of them then loops through and appends the create scripts for them to the same file. All commands are appended to the "c:\SomePath\SPExport.sql" file.

Update (2010/07/29): Added IronPython example.

C# Code

using Microsoft.VisualBasic;
using System;
using System.Collections;

I have fixed some bugs to allow zpu to work with the latest ZenPhoto server software again. I have committed the changes to the sourceforge.net svn repository (http://sourceforge.net/projects/zpu/develop) and built a new windows msi package.

The msi package can be downloaded from my site at http://majorsilence.com/zpu.

My Screen Video Capture software works perfect on my home computer (64-bit Windows Vista) but crashes almost immediately on my work computer (64-bit Windows 7).

I have been running it in the debugger for a while now and have fixed one error. I am also logging all exceptions properly now so that should help if I get any errors on another computer.

Watching the task manager it appears that I also have a GDI leak that could be causing numerous problems. In fact after watching it hit the default limit (10000) it does indeed cause bad things to happen.

I have finished reading Design Patterns Explained. Moving onto finishing code complete 2.

Finished reading chapter 19 Factory Pattern Method.

See http://www.majorsilence.com/design_patterns_explained.

Uploaded a new copy of ScreenVideoCapture2.

http://majorsilence.com/screen_video_capture

MajorSilenceConnect is a basic replacement for ultravnc single click that uses the regular ultravnc server winvnc.exe. I find that this works much better on Windows Vista/7. Requires .NET 2.0.

Currently this project only supports the port forwarding setup (does not support repeater mode) because that is all I need. It should be simple enough to add repeater support if it is ever needed.

How compile MajorSilenceConnect

Read the chapter "The Template Method Pattern". Had a hard time concentrating on this chapter.

To quote the book: "Define the skeleton of an algorithm in an operation, deferring some steps to subclasses. Redefine the steps in an algorithm without changing the algorithm's structure." Design Patterns Explained chapter 18 page 283.

See http://www.majorsilence.com/design_patterns_explained

As of a few days ago I purchased a new house and moved in Sunday (16 May 2010).

Since I believe in its current state DeVeDe will never run as good on Windows as it does on Linux I have decided to write a small clone of the DeVeDe dvd module using .NET.