Monthly Archives: July 2009

Auto Hotkey

Leave a reply
Free and opensource. Might be useful. Written in C++
  • Automate almost anything by sending keystrokes and mouse clicks. You can write a mouse or keyboard macro by hand or use the macro recorder.
  • Create hotkeys for keyboard, joystick, and mouse. Virtually any key, button, or combination can become a hotkey.
  • Expand abbreviations as you type them. For example, typing "btw" can automatically produce "by the way".
  • Create custom data-entry forms, user interfaces, and menu bars. See GUI for details.
  • Remap keys and buttons on your keyboard, joystick, and mouse.
  • Respond to signals from hand-held remote controls via the WinLIRC client script.
  • Run existing AutoIt v2 scripts and enhance them with new capabilities.
  • Convert any script into an EXE file that can be run on computers that don’t have AutoHotkey installed.

EXE Generator

Leave a reply
Compile your .BAT > .EXE.

 
Might be useful for you if you need to hide password or don’t want anyone to play around with your Batch file.
  •   Compile any BATch file to EXE format.
  •   DOS/Win95/98/Me/2000/XP/2003/VISTA compatible!
  •   Batch file window HIDE/SHOW itself at runtime! Run in backround with no
  •   console window!
  •   Select EXE Icon!
  •   Colorful editor syntax highlighting.
  •   Hides the contents of your batch file from viewing and change with  encryption.
  •   Contains powerful extended commands including math / input functions.
  •   Very useful for installations and automation tasks.
  •   Compiled EXE do not require DLL libraries to run.
  •   Royalty Free. You may create unlimited products.

ASP.NET MVC

Leave a reply

ASP.NET MVC is a free and fully supported Microsoft framework for building web applications that use a model-view-controller pattern. Like ASP.NET Web Forms, ASP.NET MVC is built on the ASP.NET framework. Requires .NET Framework 3.5.

ASP.NET MVC provides the following benefits:

  • Provides complete control over your HTML markup
  • Enables rich AJAX integration
  • Intuitive website URLs
  • Clear separation of concerns which results in web applications that are easier to maintain and extend over time.
  • Testability – including support for test-driven development.
 
 

.NET – Troubleshooting Timeout expired. All pooled connections were in use and max pool size was reached.

Leave a reply
This problem occurred because of connection leak. Either the connection string do not close properly or consistently.

To resolve:
1. Call the Dispose() method after you close the connection.

 

DbConnection conn = null;

DbCommand cmd = null;

try

{

Database db = DatabaseFactory.CreateDatabase(base.ConnectionStringKey);
conn = db.CreateConnection();
cmd = db.GetStoredProcCommand("[ods.transaction].[usp_UpdateReviewDate]");
db.AddInParameter(cmd, "ReviewDate", DbType.DateTime, reviewDate);
conn.Open();
db.ExecuteNonQuery(cmd);

}

catch (Exception ex)

{

throw new TradeSourceException("Unable to update review date." + ex.Message, ex);

}

finally

{

if (conn != null)

{
     conn.Close();
     conn.Dispose();
}

if (cmd != null)

{
     cmd.Dispose();
}
}

2. Ask the DBA to check for open connections to find the faulty application.
Use SQL command: EXEC SP_WHO2

3. Check the web.config/app.config for the pool settings. 
Usually in the connection string:
  Max Pool Size – Increase to 512
  Min Pool Size – Mark it 0
  Pooling – Mark to true

4. Restarting the IIS which refreshes the Application Pool.

 


WinMerge

Leave a reply

Opensource and written in Visual C++, you can use this to compare the codes different between 2 files and perform merging.

This is one of the best tool around which can save you A LOT of time. Usually using for comparing of deployment scripts, config files and codes.

In fact for one of my new application SIT, we are required to verify the integrity of data of huge amount of transformed data. While users uses their excel and eyes to compare against their production data, I output the data as csv (comma delimited) and automate the compare using winmerge. A task that took hours was done in seconds.

One of my favourite tool!
Http://www.winmerge.org