Brian Steinmeyer
Author's posts
Jan 02 2013
Recover SA Password on Microsoft SQL Server
Applies to: Microsoft SQL Server 2005, Microsoft SQL Server 2008 Overview If you ever lost a SA password, you may have thought your only option is to reinstall SQL and re-attach to the DB’s. However, SQL server provides a much better disaster recovery method which preserves objects and data in the master DB. Members …
Dec 29 2012
BackupRouters-TelnetToLocal.pl
#!/usr/bin/env perl #========================================================================= # BackupRouters-TelnetToLocal.pl # VERSION: 1.0 # AUTHOR: Brian Steinmeyer # EMAIL: sigkill@sigkillit.com # WEB: https://sigkillit.com # DATE: 12/29/2012 # COMMENTS: Uses the Telnet::Cisco module to copy a Cisco Router’s running # configuration to the local machine. This module uses telnet so passwords # will be in clear text. Pass the Cisco Router’s …
Dec 29 2012
Perl Show Current Script Name
If you ever needed to show the currently running Perl script name, here are the examples you need. I personally like using the following to name log files based on the script name by replacing the extension: use File::Basename; #Display Current Script Name my $scriptName = basename($0); print $scriptName #Display Current Script Name with Different …
Dec 28 2012
Recover Private Key for SSL Certificates in IIS
Problem: Your SSL Certificate is installed but missing the private key. At the time of this writing, this applies to: IIS5 IIS6 IIS7 Causes: There can be multiple causes from deleting the original SSL certificate to your server crashing and not having a backup of the private key. Resolution: Â Log on to the computer that …
Dec 21 2012
ListRunningScripts.vbs
‘========================================================================= ‘ ListRunningScripts.vbs ‘ VERSION: 1.1 – Null value is returned when a script is launched by another user on the local computer and the script is not elevated for UAC. I added a check to look for this and alert the user. ‘ AUTHOR: Brian Steinmeyer ‘ EMAIL: sigkill@sigkillit.com ‘ WEB: https://sigkillit.com ‘ DATE: …
Dec 08 2012
IDK.vbs
‘========================================================================= ‘ IDK.vbs ‘ VERSION: 1.0 ‘ AUTHOR: Brian Steinmeyer ‘ EMAIL: sigkill@sigkillit.com ‘ WEB: https://sigkillit.com ‘ DATE: 12/8/2012 ‘ COMMENTS: If you have ever had an issue making a decision like “What Should ‘ I eat for dinner” or “What should I do tonight?” then IDK aka “I Don’t Know” ‘ is the script …
Dec 07 2012
Cannot Connect to Windows 7 SMB Shares from XP/2003
If you’ve ever tried connecting to a Windows 7 SMB share from a Windows XP or 2003 computer, you may notice you cannot connect to the server. Being the savvy person you are, you: Check the share and NTFS permissions on the Windows 7 Share Run gpresult on your XP/2003 machine and confirm you are …
Apr 01 2012
EmailParts.vbs
‘========================================================================= ‘ EmailParts.vbs ‘ VERSION: 1.0 ‘ AUTHOR: Brian Steinmeyer ‘ EMAIL: sigkill@sigkillit.com ‘ WEB: https://sigkillit.com ‘ DATE: 4/1/2012 ‘ COMMENTS: Four methods to break an email address into the local and ‘ domain parts. I prefer the string methods because you can make them ‘ 1-liners, doesn’t require additional variables, and simplifies error ‘ …
Apr 01 2012
GoogleSitemap.vbs
‘========================================================================= ‘ GoogleSitemap.vbs ‘ VERSION: 1.0 ‘ AUTHOR: Brian Steinmeyer ‘ EMAIL: sigkill@sigkillit.com ‘ WEB: https://sigkillit.com ‘ DATE: 4/1/2012 ‘ COMMENTS: Traverse a local website root folder and generates a Google ‘ Sitemap .xml file based on the folder structure. Modify the variables ‘ in the settings section accordingly. The variables are explained below: ‘ …