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.

Remove password protection for excel 2007/2010

If you have a password protected workbook, you can fix this when you forget your password.

Step 1:
            Backup your excel file

Step 2:
            Change the extension from .xlsx to .zip

Step 3:
            Open the zip file with 7-zip

Step 3:
            Goto the directory xl

Step 4:
            Open workbook.xml in edit mode with notepad

Step 5:
            Find tag <WorkbookProtection>

Step 6:
            Highlight tag <WorkbookProtection> to </WorkbookProtection> and delete.

Step 7:
            Save workbook.xml

Step 8:
            Update respository

Step 9:
            Change the .zip to .xlsx

Step 10:
            Open excel file and it is now unprotected.

Saving Excel worksheet in VB.NET

Saving Excel worksheet in VB.NET

When saving an excel file in VB.NET
objExcel.SaveAs([FileName], fileformat:=[Number from below])

Find the format you want on the left or right, the number next to that format is your fileformat.
xlOpenDocumentSpreadsheet;60; OpenDocument Spreadsheet

xlAddIn ;18; Microsoft Office Excel Add-In.
xlCSV ;6; Comma separated value.
xlCSVMac ;22; Comma separated value.
xlCSVMSDOS ;24; Comma separated value.
xlCSVWindows ;23; Comma separated value.
xlDBF2 ;7; Dbase 2 format.
xlDBF3 ;8; Dbase 3 format.
xlDBF4 ;11; Dbase 4 format.
xlDIF ;9; Data Interchange format.
xlExcel2 ;16; Excel version 2.0.
xlExcel2FarEast ;27; Excel version 2.0 far east.
xlExcel3 ;29; Excel version 3.0.
xlExcel4 ;33; Excel version 4.0.
xlExcel5 ;39; Excel version 5.0.
xlExcel7 ;39; Excel 95.
xlExcel9795 ;43; Excel version 95 and 97.
xlExcel4Workbook ;35; Excel version 4.0. Workbook format.
xlIntlAddIn ;26; Microsoft Office Excel Add-In international format.
xlIntlMacro ;25; Deprecated format.
xlWorkbookNormal ;-4143; Excel workbook format.
xlSYLK ;2; Symbolic link format.
xlTemplate ;17; Excel template format.
xlCurrentPlatformText ;-4158; Specifies a type of text format
xlTextMac ;19; Specifies a type of text format.
xlTextMSDOS ;21; Specifies a type of text format.
xlTextPrinter ;36; Specifies a type of text format.
xlTextWindows ;20; Specifies a type of text format.
xlWJ2WD1 ;14; Deprecated format.
xlWK1 ;5; Lotus 1-2-3 format.
xlWK1ALL ;31; Lotus 1-2-3 format.
xlWK1FMT ;30; Lotus 1-2-3 format.
xlWK3 ;15; Lotus 1-2-3 format.
xlWK4 ;38; Lotus 1-2-3 format.
xlWK3FM3 ;32; Lotus 1-2-3 format.
xlWKS ;4; Lotus 1-2-3 format.
xlWorks2FarEast ;28; Microsoft Works 2.0 format
xlWQ1 ;34; Quattro Pro format.
xlWJ3 ;40; Deprecated format.
xlWJ3FJ3 ;41; Deprecated format.
xlUnicodeText ;42; Specifies a type of text format.
xlHtml ;44; Web page format.
xlWebArchive ;45; MHT format.
xlXMLSpreadsheet ;46; Excel Spreadsheet format.
xlExcel12 ;50; Excel12
xlOpenXMLWorkbook ;51; Open XML Workbook
xlOpenXMLWorkbookMacroEnabled ;52; Open XML Workbook Macro Enabled
xlOpenXMLTemplateMacroEnabled ;53; Open XML Template Macro Enabled
xlTemplate8 ;17; Template 8
xlOpenXMLTemplate ;54; Open XML Template
xlAddIn8 ;18; Microsoft Excel 97-2003 Add-In
xlOpenXMLAddIn ;55; Open XML Add-In
xlExcel8 ;56; Excel8
xlWorkbookDefault ;51; Workbook default 

 

example:

below will save your excel file in Excel version 95 and 97 format

objExcel.SaveAs("C:|NewExcelFile.xls", fileformat:=43)

Link to article:
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.xlfileformat.aspx

Compare and synchronize SQL DBMS data visually between databases

Looking for a SQL tool to Compare and synchronize SQL DBMS data visually between databases.
CompareData

Overview

CompareData is a native Windows 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.

Features

• 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
• Compare resultsets of any size.* See comparing large resultsets
• Compare schema for two tables or a group of tables including: columns, indices, primary key, foreign keys, triggers and table permissions
• Compare stored procedures/functions
• Command line or internally schedule comparisons and data synchronization
• Multi-threaded, multicore-ready design. Native 64-bit version is available. See x64
• Free for comparing table/view data. New evaluation period with each new release.

Find and remove W32/VBNA-X worm

This is how we found and removed the W32/VBNA-X worm or sexy,x.mpeg,porn worm


    Info on the Worm
    http://www.net-security.org/malware_news.php?id=2340
   
    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
       
        Change GPO
           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