| Login

Search this Blog


Links I like to keep around


Here are the most recent postings to this blog. Use the archive calendar or search to find other entries.
Author:R TeachoutCreated:6/15/1999 6:20 AM
Ramblings, SQL Scriptlets, VBS Scriptlets, Linux Stuff, and more!

Is This Possible?  NO, but you CAN ACCOMPLISH THE GOAL YOU WANT ANYWAY...Sorta, but it works !!!!

Getting queries to use multiple clustered indexes.

Read More »

Determine the MTU Size Limits of the full path of an internet route

Read More »

Can't figure out how to Activate Windows 2008 Server - If you installed from a Volume License CD, it never prompted you for the license key, so it will not activate.  Here is how to change the Product Key & then Activate the server.. easy!
(I've also included a number of other common activation stages you can "jump" to - and a shortcut on how to activate a windows 2008 core installation)

Read More »

how to use gdb to debug something in asterisk (I used this to help the chan_sccp_b developers to find a bug in the module unloading/loading process

Read More »

Force Windows to recheck and fix any "Windows File Protection" files - just a reminder of sfc commands

Read More »

Find Windows netstat port usage by Process id/name

Read More »

Just a "hack" way to fix this issue, without restarting the entire machine.

Read More »

Here is the quick how-to on easily installing NLB (which is no longer installed by default in 2008)

Read More »

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.

Read More »

A must have list for sysadmins that are (or will) be managing IIS7.. a blog entry from the IIS7 Team

Read More »

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

Read More »

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

Read More »

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.

Read More »

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

Read More »

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

Read More »

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

Read More »

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

Read More »

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!

Read More »

How to Find Orphaned Users on a database use database; exec sp_change_users_login 'Report'

Read More »

Ever need to immediately disconnect users on a database, such as when running a Database Restore? Here's a quick trick.

Read More »

Need to transfer your users from SQL2000 to SQL2005? Here's how

Read More »

Useful with a combination of some other scripts I have in blog entries. I found this online, so I can't take credit for this, but I swear I at least had started the same type of script before I googled..

Read More »

Useful when transferring all databases from one SQL server to another.

Read More »

Useful when transferring all databases from one SQL server to another.

Read More »

(Switch between running 32-bit applications and 64-bit applications in IIS on a 64-bit version of Windows) Also: switch between the 32-bit version of Microsoft ASP.NET 1.1 and both the 32-bit version and the 64-bit version of ASP.NET 2.0 on a 64-bit version of Microsoft Windows.

Read More »


When the power of love overcomes the love of the power, the world will know peace.
-J. Hendrix

Inspired by Nina