Wednesday, May 15, 2013

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.

Wednesday, May 1, 2013

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 
  2. Gardner Bender 50-600 VAC Circuit Alert Non-Contact Voltage Tester
  3.  Klein Tools Digital Circuit Breaker Finder
  4. Klein Tools Circuit Breaker Finder Accessory Kit 
  5.  Gardner Bender 120 VAC GFCI Outlet Tester
  6.  7 Function Digital Multimeter
  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.

Sunday, March 10, 2013

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.

Wednesday, February 13, 2013

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

Tuesday, January 15, 2013

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.