Archives: August 13, 2011

Iobit makes a free tool for this.  Works nice.

http://www.iobit.com/download.html

Choose the free iobit Uninstaller.

The removed the file types thing from Vista / 7.  I.E. you cannot associate files and have them run with a program with special commands.  This program allows you to do many things with file associations rather than editing HKCR.

Download Types:

http://izt.name/soft/types/

Useful to know for what SP a server is running:

http://support.microsoft.com/kb/158530

You receive an error message when you try to perform any editing tasks, or you must click to enable the compose frame in Outlook Web Access.

http://support.microsoft.com/kb/911829/en-gb

I have a windows mobile phone and it stopped syncing with Exchange.  No reason.  Usually rebooting the phone fixes it (remove battery).  No dice.  In OWA you can login as yourself, go to options, mobile devices and remove your phone.  Then on your phone you can go ahead and do a send and receive and it will resync everything.  Not a big deal
unless you were sending a bunch of messages from your phone which is usually
unlikely.  Just a tip.

Like take spaces out of a bunch of files and replace them with something like a hyphon?  How about just remove the spaces out of files?

Use BatchFileRenamer!

http://download.cnet.com/Batch-File-Renamer/3000-2094_4-11655280.html

Const cdoSendUsingPickup = 1

Const cdoSendUsingPort = 2

Const cdoDSNDefault = 0 ‘None

Const cdoDSNNever = 1 ‘None

Const cdoDSNFailure = 2 ‘Failure

Const cdoDSNSuccess = 4 ‘Success

Const cdoDSNDelay = 8 ‘Delay

Const cdoDSNSuccessFailOrDelay = 14 ‘Success, failure or delay

set objMsg = CreateObject(“CDO.Message”)

set objConf = CreateObject(“CDO.Configuration”)

Set objFlds = objConf.Fields

With objFlds

.Item(“http://schemas.microsoft.com/cdo/configuration/sendusing“)
= cdoSendUsingPort

.Item(“http://schemas.microsoft.com/cdo/configuration/smtpserver“)
= “<changeme – server ip or name>”

.Update

End With

strBody = “<change me – body of email message>” & vbCRLF

With objMsg

Set .Configuration = objConf

.To = “<Changeme – emall addresses separate by a semi colon>”

.From = “<changeme – form email address>”

.Subject = “<changeme – subject of email>”

.TextBody = strBody

.Addattachment “<changeme – path to attachment>”

.Fields(“urn:schemas:mailheader:disposition-notification-to”) = “<changeme- email address of admin”
.Fields(“urn:schemas:mailheader:return-receipt-to”) = “<changeme – email address of admin”

.DSNOptions = cdoDSNSuccessFailOrDelay

.Fields.update

.Send

End With

Copy and paste to a text file.  Change all the <Changeme> text to your liking.  Helpful to run as a scheduled task to email attachments or general emails for server monitoring things.  Combine with SQL Database size scripts or mailbox size scripts to get emailed reports at a set schedule.

http://www.mssqltips.com/tip.asp?tip=1583

Helpful if you have all SQL backup jobs using the default folder.  This way all future jobs will use the folder/drive to free up space /resources.

Run this Query:

SELECT name, physical_name AS current_file_location

FROM sys.master_files

Gives you all the databases and their database file location and log file location.  (the actual filesystem paths)

Helpful for when you take over a setup and someone has decided to put stuff all over the place!

I do not by any means recommend doing this.  Do so at your own risk as I have had users ask to do this and have been forced to do this for others in the past.

To stop the information bar from blocking file and software downloads

1. Open Internet Explorer by clicking the Start button , and then clicking Internet Explorer.
2. Click the Tools button, and then click Internet Options.
3. Click the Security tab, and then click Custom level.
4. Do one or both of the following:
   – To turn off the Information bar for ActiveX controls, scroll to the ActiveX controls and plug-ins section of the list, and then, under Automatic
   prompting for ActiveX controls, click Enable.
   –  To turn off the Information bar for file downloads, scroll to the Downloads section of the list, and then, under Automatic prompting for file downloads, click Enable.
5. Click OK, click Yes to confirm that you want to make the change, and
   then click OK again.