If you need to increase the connection pool in a .NET application this is what you need to add to your webconfig file:

;max pool size=200

This would increase the connection pool to 200 ( from a default of 100 I believe )

This will be in the appsettings node as follows:

I have been working with jQGrid and upon adding a new record wasnted to jump to the last page of the grid upon successful save of a new entry without clicking the "last page" button. It really wasn't that had and Dave pointed me in the right direction with setParam.

Here is the code:


Working with jqGrid has been great but I'm also really looking forwards to the official jQuery grid.

I recently had to move data from one server to another.  The serevr runs linux, Railo and mysql.  It's always a pain migrating databases bewteen servers but mysql makes this so easy:



This will prompt you for the root password but if you want to can add the password after the -p and not be prompted.

Thats it.  you can now run this and restore all your databases on the new server or pick through it and restore the ones you need.

What would you prefer and why?

EXTjs is not free

jQuery is.

EXTjs is built into ColdFusion jQuery is not.

jQuery is Microsoft's defacto Ajax library so it has some big support behind it.

We use EXTjs at work but I use jQuery at home.

We had a largeish DB server corrupt a disk and in the process cause one of the databases to become suspect.

This can be resolved by running the following:

EXEC sp_resetstatus 'DBName'
GO
ALTER DATABASE DBName SET EMERGENCY
DBCC checkdb('DBname')
ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DBName', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DBName SET MULTI_USER

GO

From: http://blogs.microsoft.co.il/blogs/dbaces/archive/2008/12/28/how-to-repair-sql-server-2005-suspect-database.aspx

However we had a database with a hyphen in the name eg: data-base-name

To get around this use " " around the data-base-name eg:


EXEC sp_resetstatus 'data-base-name'
GO
ALTER DATABASE "data-base-name" SET EMERGENCY
DBCC checkdb('data-base-name')
ALTER DATABASE "data-base-name" SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('data-base-name', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE "data-base-name" SET MULTI_USER

GO