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 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.
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:
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
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.
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.
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.
Looking for a SQL tool to Compare and synchronize SQL DBMS data visually between databases. CompareData
CompareDatais a nativeWindows cross-dbms application that allows you to visually compare and synchronize data between two SQL databases using ODBC drivers. You can retrieve some/all data for a table/view from two databases and compare the data visually to see differences highlighted on the screen. You can also compare data of two sql queries and dbms metadata.
Compare data between two tables/views of the same or different names
Compare columns having the same or different names and/or data types
Compare data of two sql queries
Synchronize table data at row level, table level or folder level
Compare data of a group of tables/queries or all tables with one command
Clean up step 1 change GPO to disable autorun on all drives
find local dns servers or where gpo policies are pushed out from on the network log in to the dns server
start up group policy editor start command line type in gpedit.msc
Local Computer Policy Computer Configuration Administrative Templates Windows Components AutoPlay Policies Turn off Autoplay Double click on Turn off Autoplay enable GPO and turn off for All drives Click Apply Click OK
need to download a virus scanner that will help us out we used the emisoft emergency kit
once you have the zip file and unzip it you can move the directory to each server that you want to scan so you do not have to download each time
goto http://www.emsisoft.com/en/software/eek/ and download emisoft emergency kit for free once you have the zip file unzip zip file open EmisoftEmergencyKit directory double click start.exe Click on Emergency Kit Scanner sometimes it takes a little while to open that is ok just wait Click on Update now to get the latest signatures Once all updated click on scan pc on left hand side of screen Click on deep scan Click on scan this will take a while so let it go on the server
the .exe worm/malware/virus variant has these files ..exe tskoe.exe autorun.inf x.mpeg porn.exe sexy.exe
secret.exe changed all files and directories to [file].exe
The file are not gone don't worry they are just hidden
Log on to servers where network shares are located this will need to be done to all servers
start up command window this will display all hidden files and in current directory type dir /ah
if anything appears other than for example system folders then you are still infected The follow command will unhide all files and directories this sometimes takes awhile so let it go also you might get errors that it can not do system files that is ok The following command clears the system attribute, clears the hidden attribute, include all sub-directories, and apply command to directories also
type attrib *.* -h -s /s /d
now what we did was move the exe files to another directory just in case there where actual exe that people wanted The following command creates a directory called exe
type mkdir exe
the following command moves all files .exe in current directory to new exe directory move *.exe .\exe
this will hide the exe directory so only you guys can see it and pull back what is needed attrib +h exe
If you know that all these files are corrupt then delete them out
this will take some time on each server do a search for autorun.inf you can open an inf file in notepad now open each autorun.inf and see if it an actual autorun.inf or if the contents do not look correct then close notepad and delete the autorun.inf file
also on each server do a search for x.mpeg we found these and just deleted them
also on each server do a search for secret.exe we found these and just deleted them
also on each server do a search for porn.exe we found these and just deleted them
also on each server do a search for sexy.exe we found these and just deleted them
also dont forget to make a log someplace that you have shut off autorun on all drives for later because someone might complain that there CD or DVD or usb just does not start up anymore they have to go and click on the files manually
If possible try to find computer 0 so you can ask them for there usb and also to check there home computer