Browse by Tags

• Authentication
• Backup
• Bash
• Bat
• Batch
• Cable
• Chrome
• Code
• Comcast
• Command
• Console
• Error
• File
• Google
• Hyper-V
• Linux
• Media
• Microsoft
• Modem
• Network
• PowerShell
• Programming
• Query
• RDP
• RemoteApp
• Robocopy
• Shares
• Shell
• Software
• SQL
• Template
• Terminal Services
• TS
• Ubuntu
• Virtualization
• Vista
• VLC
• Web
• Windows

• MS SQL Check If Column Exists

  The following SQL script checks if a certain column exists in a certain table, then prints some text to the output window. I'm getting into the best practice habit of creating SQL scripts that can be re-run without any errors and this is useful in... Posted Jul 08 2009, 10:38 AM by Matt Williamson with | with 1 comment(s) Filed under: Script, Software, Code, SQL, Query

• SQL Replace Function on NTEXT Data

  Today I've made some changes to my hosted environment. I've decided to enforce my websites URL as always 'http://www.bunkerhollow.com' instead of 'http://bunkerhollow.com'. This will keep the URL the same whether I'm inside... Posted Jun 07 2009, 04:39 PM by Matt Williamson with | with 1 comment(s) Filed under: Error, Script, Code, SQL

• TS Web Access Publish Google Chrome RemoteApp

  You may be trying to publish Google Chrome as a RemoteApp to launch from your Terminal Services Web Access dashboard. I say 'trying' because you're probably having trouble. It took me a little while to get it right. Google Chrome is different... Posted Jun 05 2009, 02:33 PM by Matt Williamson with | with 4 comment(s) Filed under: Error, Script, Software, Web, RDP, Batch, Terminal Services, TS, Google, RemoteApp, Chrome

• Batch File (*.bat) Hide Console Window

  This won't work for all scenarios but it's quite easy and works well for what I need accomplished at the moment. All I need is a simple batch file to launch an application, like this: LaunchChrome.bat C:\Users\%username%\AppData\Local\Google\Chrome... Posted Jun 05 2009, 01:39 PM by Matt Williamson with | with 9 comment(s) Filed under: Windows, Script, Command, File, Code, Batch, Bat, Console

• Automatically Reboot Comcast Cable Modem Script

  My Comcast cable modem freezes sometimes. If I lose internet access I'll take a look at the modem and usually the 'Send' light is flashing steadily and/or the 'Online' light is out. Rebooting the modem fixes the issue. The real problem... Posted May 02 2009, 10:12 AM by Matt Williamson with | with 7 comment(s) Filed under: Comcast, Script, Software, Code, Linux, Cable, Bash, Shell, Ubuntu, Modem

• MS SQL Loop Through Table Scripts

  At some point you may want to loop through every row in a table and perform operations based on the fields in each row. After a bit of investigation, I've found the 2 most common ways of doing it. Loop Through All Rows of a Table Using a Counter This... Posted Mar 10 2009, 10:24 AM by Matt Williamson with | with 3 comment(s) Filed under: Script, Software, Code, SQL, Programming, Microsoft

• SQL Find All (Search) Scripts

  The following is a running list of MS SQL scripts I've used to search for items within databases. Wouldn't it be great if they just had a better Find function in SQL Management Studio?! Find All Tables with Certain Text in the Table Name use YourDataBaseNameHere... Posted Mar 09 2009, 09:14 AM by Matt Williamson with | with no comments Filed under: Script, SQL

• Robocopy GUI

  Hey hey hey, I just found this utility that makes using Robocopy faster and easier! If you've never used Robocopy before, I'd recommend using this tool to learn how. You can hover over all the options, as shown below, to popup a tooltip describing... Posted Feb 19 2009, 07:57 AM by Matt Williamson with | with no comments Filed under: Robocopy, Script, Backup, Software

• SQL Server Insert Using Identity

  While developing SQL scripts you'll probably find yourself inserting rows with identity columns at some point. You'll then probably want to obtain those newly created identity rows (generally ID columns of some sort) and want to insert new rows... Posted Feb 18 2009, 08:45 AM by Matt Williamson with | with no comments Filed under: Script, Software, SQL

• Hyper-V VM Backup Script Batch File

  This will shutdown your virtual machines, copy the .vhd virtual hard disk files (not snapshots) to a backup location, and then power your virtual machines back on. Install the Windows PowerShell Feature You may need to install Windows PowerShell on your... Posted Sep 24 2008, 10:18 PM by Matt Williamson with | with 19 comment(s) Filed under: Windows, Script, Backup, PowerShell, Hyper-V, Virtualization

• VLC Media Streaming

  I setup VLC to stream media throughout my home and over the internet, and it works great. I tested it out by streaming a handful of mp3's and avi's over the http protocol. It works internally and over the internet as it should. The interesting... Posted Sep 08 2008, 09:08 PM by Matt Williamson with | with 2 comment(s) Filed under: Script, Media, Batch, VLC

• Accessing Network Shares From A Backup Script

  This issue came up this weekend when I was creating a backup script to copy my website files from my webserver to my file server. The problem is the webserver isn't on the domain so it won't be able to authenticate the user who runs the script... Posted Dec 09 2007, 04:30 PM by Matt Williamson with | with no comments Filed under: Authentication, Robocopy, Script, Backup, Command, Network, Shares

• Robocopy Backup Script Template

  Robocopy is a powerful command line tool commonly used for backing up files. It's options go above and beyond the standard COPY and XCOPY tools included with Windows. For pre-Vista users, Robocopy is available in the Windows Resource Kit . For Vista... Posted Oct 04 2007, 12:42 PM by Matt Williamson with | with 3 comment(s) Filed under: Vista, Robocopy, Template, Script, Backup