Useful SQL Server Utilities

Useful SQL Server Utilities

Some usefull SQL Server Utilities
SQLServer Utilities

The utilities include:

RestoreChecker

RestoreChecker is a utility that restores SQL Server backup files in order to verify that the backup files can be sucessfully restored and in addition perform data integrity checkes on the backups restored while offloading the intensive IO activity from your production servers.

SQLScripter

SQLScripter is a utility that scripts SQL Server databases, jobs, logins and any other sql server object. The utility is designed to automate the process of schema generation.

How to Install VB6 on Windows 7

May 1, 2013
-----------------------------------------------------------------------------------------------------------------------

How to Install VB6 on Windows 7

fourtypoundhead.com has a great article here on how to install Visual Basic 6 onto Windows 7.
Thank you very much for your port helped me out.

The only thing I will add to it is how to create a zero length file.

1. Open command window
• Start button
• type
• cmd.exe
2. type in command window
•  set nul=%nul% > c:\windows\msjava.sll
3. check your new zero length file type
• dir c:\windows\msjava.dll

Here is a link to his instructions:
http://www.fortypoundhead.com/showcontent.asp?artid=20502

Electrical - Find and Map Electrical outlets and switchs

May 1, 2013
--------------------------------------------------------------------------------------------------------------------------

Electrical - Find and Map Electrical outlets and switchs
Electrical - What Circuit breaker does this Electrical outlet go to
Electrical - Where does this outlet come from or go to
Electrical - Is this outlet wired correctly
Electrical - Is this outlet live

Equipment that was used:

1. Gardner Bender Wire-Tracker Wire Tracer 
• The transmitter is a compact, hand-held instrument designed to generate a distinct tone in any unenergized wire or cable. The Receiver is a portable, hand-held inductive tracer that will aid in identification of wires without piercing their insulation.
• This tool only works in the presence of No AC Voltage
• http://www.homedepot.com/p/Gardner-Bender-Wire-Tracker-Wire-Tracer-GET-4110K/202867889
2. Gardner Bender 50-600 VAC Circuit Alert Non-Contact Voltage Tester
•  Indicates the presence of AC Voltage
• http://www.homedepot.com/p/Gardner-Bender-50-600-VAC-Circuit-Alert-Non-Contact-Voltage-Tester-1-clam-5-clams-master-GVD-3504/202867895
3.  Klein Tools Digital Circuit Breaker Finder
•  Quickly and accurately find the corresponding circuit breaker of 120-volt standard outlets, the circuit breaker finder has an arrow that flashes for easy identification of the circuit breaker.
• This tool only works in the presence of AC Voltage
•  http://www.homedepot.com/p/Klein-Tools-Digital-Circuit-Breaker-Finder-ET300/202330830
4. Klein Tools Circuit Breaker Finder Accessory Kit 
•  the kit was designed for use with the circuit breaker finder.  It has a light socket adapter that allows the circuit breaker finder to be screwed into a standard light bulb socket. The kit has an alligator clip adapter that allows the circuit breaker finder to be used on bare wires.
•   http://www.homedepot.com/p/t/202266613?productId=202266613&storeId=10051&langId=-1&catalogId=10053&cm_sp=BazVoice%2d%5f%2dREP%2d%5f%2d202330830%2d%5f%2dx
5.  Gardner Bender 120 VAC GFCI Outlet Tester
•   Ground Fault Receptacle Tester & Circuit Analyzer tests ground fault receptacles by overloading circuit and tripping GFCI. Tests standard outlets, GFCI outlets, and Extension cords. Simply plug tester into any circuit protected by a ground fault receptacle (110 - 125 V AC) and press black button to overload circuit.
• Also works on Regulat Receptacles
•   http://www.homedepot.com/p/Gardner-Bender-120-VAC-GFCI-Outlet-Tester-1-clam-5-clams-master-GFI-3501/202867890
6.  7 Function Digital Multimeter
•  This versatile 7 function multimeter provides precise measurements and tests for a variety of electronics. The multimeter tool conducts tests of AC/DC voltage
•  http://www.harborfreight.com/7-function-multimeter-98025.html
7.  Screw Drivers
8.  Pliers

Electrical - Find and Map Electrical outlets and switchs

When you want to find where the wire goes from a receptacle to ....
First if you use Klein Tools Digital Circuit Breaker Finder to find the Circuit breaker in the Electrical box that that outlet is on.  Plug the toner into the live outlet, turn on circuit breaker finder and when the circuit breaker finder finds the signal the green arrow will light up.  This is the breaker that you are looking for.  If you shut off the power to that recepticle.  Now if you go back to the recepticle, if you use the Gardner Bender 50-600 VAC Circuit Alert Non-Contact Voltage Tester or 7 Function Digital Multimeter to test that the recepticle has no voltage running to it.  You can remove the faceplate and recepticle.  You can attach the Gardner Bender Wire-Tracker Wire Tracer to the bare wires.  Now you can trace the wire as it goes through your house.  Once you are done replace the recepticle and faceplate.  Plug in the Gardner Bender 120 VAC GFCI Outlet Tester to the recepticle.  Go back to the Electrical box and return the power to that recepticle.  When returning to the recepticle you can see if the recepticle is wired correctly.