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 »

EXEC sp_MSforeachtable "exec sp_spaceused '?'" Read More »

Use this SQL server script from the SQL query window to rename an existing database. The script below will place the database in single user mode then rename the device and put then new device name back into multi user mode for use. Read More »

Run a query against sysprocesses to figure out what is going on on a SQL Server Read More »

qwista / rwinsta command line tools Read More »

Configuration Options for an RDP file (which is really a txt document). Read More »

If you haven't already checked this software out.. you should. The ultimate enterprise email software Read More »

If you have access to your Imail registry, and need to decrypt the hash passwords in order to convert to another (better) mail software, here's what you would need to know.... Read More »

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap) Read More »

Search error log for "Return value 3" and trace to find out what you're missing, then install that, then go with it. Read More »

ex: ./SiteCode to ./Backup-YYYY-MM-DD-WKD Read More »

set VAR=%VAR:/=-% would replace any / with - in a variable.. Read More »

Found this article, and have had to search this out each time, so this time I'm blogging it so I don't have to find it again.. besides, others may like it.. How To Add the "Export To Excel" option To Internet Explorer if it isn't there, but excel is installed. Read More »

For example a service left over rootkitreveler or psexec service like ASHDBDK linked to a non-existant temp file in the users temp directory (sysinternals services) using SC Read More »

SET UtilPath=%~dp0 Read More »