• Customer Support


    (800) 247-9045

  • Email Us


    support@bisconsultants.com

  • Online Remote Support


    BIS Help.me

  • IT Support After-Hours


    (800) 247-9045, PRESS 4

Author Archive

I came across this virus today…. pcspeedmaximizer browser virus

The popup from today was a redirect to a web site at ” h ” t ” t ” p ” ” ://pcspeedmamimizer.s3.amazonaws.com/index.html” saying someting about my regestry being damaged. “Errors have been found in your opperating system registry. Click to download free regristry cleaner software

After hours of trying to figure it out. this website http://www.bleepingcomputer.com/forums/topic367771.html and this tool tdsskiller fixed my problems.

Command prompts for windows

Here are a list of command prompts for windows

http://en.kioskea.net/faq/403-command-prompts-for-windows

2011 TAAD Conference

Come by and visit us at Booth 19  if you are planning on going to the Texas Association of Appraisal Districts Conference in Austin. Visit their site at http://taad.org

Renaissance Austin Hotel
9721 Arboretum Blvd.
Austin, TX 78759
Phone: 512-343-2626

Get the Dell Service tag remotely via command line

Do you need to get the service tag of a computer on network? Use this handy command line script.

wmic /user:administrator /node:remote-host bios get serialnumber

Lookup MX record via the command line

If you are looking for a fast way to find the mx record of a domain run this command from the command line

nslookup -querytype=mx yourdomain

kill remote sql connections

USE master 
GO 

SET NOCOUNT ON 
DECLARE @DBName varchar(50) 
DECLARE @spidstr varchar(8000) 
DECLARE @ConnKilled smallint 
SET @ConnKilled=0 
SET @spidstr = '' 

Set @DBName = 'DB_NAME' 
IF db_id(@DBName) < 4 
BEGIN 
PRINT 'Connections to system databases cannot be killed' 
RETURN 
END 
SELECT @spidstr=coalesce(@spidstr,',' )+'kill '+convert(varchar, spid)+ '; ' 
FROM master..sysprocesses WHERE dbid=db_id(@DBName) 

IF LEN(@spidstr) > 0 
BEGIN 
EXEC(@spidstr) 
SELECT @ConnKilled = COUNT(1) 
FROM master..sysprocesses WHERE dbid=db_id(@DBName) 
END 

Dell mass driver and firmware update tool

Dell driver and firmware update tool

Download the four ISO file segments to a new, empty folder.

Open a command prompt and navigate to that directory where the 4 ISO files are saved.

Run the following command to combine them into one large ISO file.

                copy /b om* om640_suu_a00.iso

Burn the large newly created ISO fie to  a DVD.

© Copyright by BIS Consulting l Farmers Branch, TX l Simplifying IT and GIS for Government Agencies - All rights reserved.