By R Teachout on 8/22/2007 3:01 PM
set VAR=%VAR:/=-% would replace any / with - in a variable..Read More » |
By R Teachout on 8/5/2007 5:09 PM
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 » |
By R Teachout on 7/26/2007 3:20 PM
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 SCRead More » |
By R Teachout on 6/28/2007 10:31 AM
SET UtilPath=%~dp0Read More » |
By R Teachout on 6/18/2007 2:03 PM
Redirects output of command line tools to the Windows clipboard.
This text output can then be pasted into other programs.Read More » |
By R Teachout on 6/13/2007 10:24 PM
Here's a quick how-to (for those technically inclined) on:
How to Get the Current Activity for a Single Database (SQL2000) when running as a DBO not as a sysadminRead More » |
By R Teachout on 6/3/2007 10:07 PM
Great for queries where you need > date < date results..Read More » |
By R Teachout on 5/14/2007 8:16 PM
This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It's very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample data to your vendor or technical support provider for troubleshooting purposes. Read More » |
By R Teachout on 5/9/2007 12:35 PM
Ex: MRTG Calculation on a switch port showing the BW rate, to determine the GB Equivalent amount of Data Transfer.Read More » |
By R Teachout on 5/4/2007 10:08 AM
To Load from a Text File into MSSQLRead More » |
By R Teachout on 5/1/2007 9:59 AM
Custom Module DeveloperRead More » |
By R Teachout on 4/27/2007 2:39 PM
Closes the current error log file and cycles the error log extension numbers just like a server restart. The new error log contains version and copyright information and a line indicating that the new log has been created.
MSSQL.1\MSSQL\LOG\ERRORLOGRead More » |
By R Teachout on 4/27/2007 2:36 AM
Shared servers usually have many databases belonging to different customers, and MS SQL Server Management Studio (SSMS) will display all those databases when used by a valid login to connect to SQL Server 2005. If you seek to change that default behavior, you can do so with a SQL Server 2005 configuration change.Read More » |
By R Teachout on 4/11/2007 8:17 AM
This command line tool enables an administrator to display the MAC address for one or more network adapters on a system.Read More » |
By R Teachout on 4/8/2007 6:43 PM
Javascript Zoom when Mouse Scrollwheel is used over an image...Read More » |
By R Teachout on 3/31/2007 9:32 PM
This allows you to set the permissions on all of the stored procedures (except the built-in ones) on a database.. great after a SQL RecoveryRead More » |
By R Teachout on 3/17/2007 2:09 PM
Simple 4 line script excellent for scheduled tasks to open a webpage to run some automated process (such as admin processing)Read More » |
By R Teachout on 3/5/2007 1:19 AM
Pricing for SQL Server 2005 - Retail Pricing, for Reference... this puts the monthly price of MSSQL SPLA into perspective.Read More » |
By R Teachout on 1/31/2007 1:54 AM
a tool for SQL Server 7.0/2000/2005 database administrators and developers
to generate data scripts in a valid T-SQL format which can be executed in Query Analyzer. Read More » |
By R Teachout on 1/26/2007 2:10 PM
Just to keep this aroundRead More » |
By R Teachout on 1/17/2007 2:15 PM
Great script I found online.Read More » |
By R Teachout on 1/7/2007 11:31 PM
The best Linux Web administration project!!!Read More » |
By R Teachout on 12/28/2006 1:07 PM
EXEC sp_dboption 'db_name, 'single user', 'FALSE'Read More » |
By R Teachout on 12/23/2006 2:18 PM
use dbname
execute sp_changedbowner [user]Read More » |
By R Teachout on 12/22/2006 5:10 AM
Reporting the amount of physical hard disk space used by each virtual machine.Read More » |