Browse by Tags

Monitor Comcast Cable Modem Bash Script

See the following blog post for details: http://www.bunkerhollow.com/blogs/matt/archive/2009/05/02/automatically-reboot-comcast-cable-modem-script.aspx

Posted to Software (FileGallery) by Matt Williamson on 07-17-2009
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 checking to see if a column already exists before...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 07-08-2009
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 or outside of my network, while retaining search...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 06-07-2009
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 from most other applications in two ways: It doesn't...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 06-05-2009
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\Application\chrome.exe That certainly does what...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 06-05-2009
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 is this often happens at the most inopportune...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 05-02-2009
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 method requires that the primary key is an integer...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 03-10-2009
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 go declare @StringToSearch varchar...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 03-09-2009
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 what each one does. You can then run the script...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 02-19-2009
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 into other tables using those values. Give me some...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 02-18-2009

Page 1 of 2 (15 items) 1 2 Next >