Ramblings, Scriptlets, and more!

DNN: Disable Ajax Manually on a particular page

rich@teachout.com — Fri, 22 Aug 2008 22:29:00 GMT

I needed to disable AJAX on the profile pages in DNN due to a 4.8 bug, but I was using ajax in lots of other places, and didn't want to turn it off everywhere, so heres the fix.

VBS (ASP) code to display all session variables in a webpage

Thu, 07 Aug 2008 19:15:00 GMT

I regularly have to look this up, so it was time to blog it!

Web Deployment Tool Beta 1 (Go Live) just released (Sync IIS Servers)

rich@teachout.com — Tue, 08 Jul 2008 20:02:00 GMT

Web Deployment Team released the Beta 1 version of the deployment tool! If you're not familiar with the tool already, it is here to help you keep sites or servers in sync with IIS6 or IIS7, as well as migrate from IIS6 to IIS7

cscript: Ensure a VBS scripts is ONLY run from a command line

Thu, 03 Jul 2008 13:49:00 GMT

Hate the vbs scripts that output results, and when you run them from wscript, you have to click 'OK' a few hundred times? Ensure it is running from cscript with this little bit of code.

MSSQL - Find the number of rows in all of your tables.

rich@teachout.com — Thu, 03 Jul 2008 06:50:00 GMT

Just a quick way to find the number of rows in all of your tables.

MSSQL: Convert Database from SQL 2000 to SQL 2005 - best practices

rich@teachout.com — Thu, 03 Jul 2008 06:43:00 GMT

Recommended steps to migrate a database from SQL 2000 to SQL 2005

MSSQL: Get the last day of the current month

rich@teachout.com — Thu, 03 Jul 2008 06:30:00 GMT

SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE())))

MSSQL: Easily Load table into RAM (like you can easily do in Mysql)

rich@teachout.com — Thu, 03 Jul 2008 06:23:00 GMT

Ever wonder how to put a mssql table into RAM after it has been read?

Grant Exec to ALL Stored Procedures and Functions for ALL db_datareader users on a database..

rich@teachout.com — Wed, 02 Jul 2008 08:04:00 GMT

For years I have used a script that I had to manually add the ADO user to, and then run it on a database, take the results, and then execute them. I finally got fed up with this, so I wrote a script I could use to automatically just run after I added a Stored Procedure, Function or User to a database, and have it just fix everything.
SLICK!