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.

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 »

Have you ever faced the problem of assigning more than 8000 characters to varchar data type or more than 4000 characters to nvarchar data type? Read More »

This is actually a simple method to do it, but it is extremely effective. Read More »

So, no, you do not know the 'sa' password, but…you do know that the 'sa' password will only be needed for an upgrade or something, not for ongoing connectivity, so you proffer a solution, "I will change the 'sa' password for you for long enough to complete the upgrade, and then I will need to change it back again. This is because I do not know what processes may be trying to use 'sa'". Read More »

Ever have a need to disable your triggers to do some maintenance or update work? Here's a way! Read More »

Yep.. you did it.. You upgraded to SP3 for Windows XP, and now you can't configure your computer to automatically login. Here's the easiest way to fix this. Read More »

This is a simple command, just many don't know about it. Here's a simple quick way to schedule a dns zone to be updated at a later time/date Read More »

I've been working this a bunch, but I have a number of sites on the same server, some running 1.1 and some 2.0, but all new sites were automatically flagged as 1.1.. and I'd prefer 2.0, so I had a development box setup to figure this out.. Now I know how can I change the default asp.net version in IIS6 on the "Web Sites Folder" ONLY without affecting the existing sites running 1.1! Read More »

incredible useful little script does is generate a series of insert or update statements for the rows in a table Read More »

MSSQL Scripts to do this.. (Set Identity Insert) Read More »

Just run this query, which will build a list of commands you can put into a batch file, and execute! Read More »

Just a SQL Script Hack to make it easier to do a restore. Or just a quick way to add the same username on MANY MANY (ALL) databases at once. Read More »

SELinux is a set of extra security restrictions on top of the normal Linux security tools. It gives the systems administrator a finer grain of control than what the kernel typically provides. But SELinux can sometimes get in your way. For example, I have had typical services, such as Apache, appear to start up correctly, but remain inaccessible from the outside world because I forgot to allow the apache user rights to open that port or maybe my distro forgot about it. Before you turn off SELinux make sure you know why you are turning it off and the security concerns you might be opening yourself up to. Read More »

Linux tool to set the duplex settings on your network card. Read More »

Ever had a remote SSH connection where you were doing an upgrade (say to asterisk or pbxinaflash, etc) and you lost your internet connection, which killed your ssh session, and stopped your compile, leaving your system in a horribly unusable state? NEVER AGAIN! That is what I use screen for! Read More »

If you haven't already tried freepbx, you should!! Read More »

Where: Historic Charleston, SC When: February 27-29th, 2008 (and evening reception February 26th) Read More »

SELECT dbid FROM master.dbo.sysdatabases WHERE name = 'database_name' Read More »

Need to make a clone of a database structure, but have too many procedures/functions/tables to do it all manually? I believe this is a good answer to that problem: Read More »