Speed up Comcast Xfinity Tips

Written on:July 26, 2013
Comments
Add One

These days I’m working from my home office.  We switched to Comcast Xfinity for our television and internet about a year ago and recently added phone service for my home office.  When I moved my office upstairs I found that I had dismal wireless speed for my workstation as well as for my very nice laptop provided by my employer.  It’s very possible that my cheap wireless card for the workstation is the main issue.  However, despite my desire to get by on the cheap you may want to try some of these tips. Essentially if you currently have the basic internet service that Comcast provides (not the business class) with a standard router with wireless capability you can try the following tips to increase the performance.  Again, think cheap.  :)

The first thing I did was research to find out what others suggest.  I did not do as clerks at a local big box electronics store suggested, which was to buy a 200 dollar new router. Why should I buy a new more expensive router when I already have one?  Well there are many suggestions on how to speed up your cable connection to the internet.  Several were to use software.  Because I have a Linux workstation going the software route was not feasible.  The best suggestion I found was to purchase a second router and use it as an access point.  There are lots of good tutorials on how to set up a second router as an access point so just do a search. Also a decent second router these days is approximately 50 to 60 bucks.

To my suprise adding a second router as an access point that sits no more that 5 feet from the comcast router my browsing speed is significantly better and the signal is better as well.  All I did is go to the local big box electronics store and purchase a budget priced NetGear router.  I plugged it in and configured it to work on my current network as an access point and then connected to it via wireless.

The second thing I did was change the DNS setting for my wireless connection upstairs.  I used the DNS servers from GOOGLE.  I’m not entirely sure that changing the DNS server helped much, but I believe that once I had the new router in place I went one step further to find out what else could increase the performance of my connection.

The third thing I did was change the channel that my new router being used as an access point is using.  Around my home it seems like everyone uses one or two channels the most for their wireless network.  I choose a channel that very few to no one is using near me.

Well, even though I am not telling you the exact details on how to do each step if your interested in making your home office internet connection perform better do some research and try out one or all of the above suggestions.  Why do it?  Well, because for less than 60 bucks I now have a high performance wireless connection in my home office upstairs, that’s why. :)

As time permits I will add a few links for tutorials on how to set up an access point.  If you have any networking experience at all it isn’t that hard.  If you have questions you can always send me a message as well.

Happy Browsing!

 

Print Friendly

T-SQL Update Table Using Join

Written on:February 11, 2013
T-SQL Update Table Using Join

  When working with tables in our relational database we are often faced with updating a field in one table that is based on field from another table. So table A is the target table that has the field that you want to update and Table B is the table that has the desired data. If you are new to SQL this tip should help you out. What to do?…

Print Friendly
Read more...

Resolving the “Sheet is invalid Error” in Tableau

Written on:January 30, 2013
pie chart

I’ve been busy these days putting together data structures for a data warehouse.  The product I’m using for the presentation layer is Tableau. After working for about 3 hours on a dashboard I published it to the server, but found that all of the work sheet views did not show in the dashboard views. Indeed I was getting “The sheet is invalid” error. If you are getting this error and…

Print Friendly
Read more...

T-SQL Concatenating Date and Time

Written on:September 20, 2012
T-SQL Concatenating Date and Time

This is a technique I’ve used several times in day to day work.  It’s straight forward and easy to understand. 1.  Declare your variables DECLARE @date Char(8), @starttime CHAR(8), @endtime CHAR(8), @startdt DATETIME, @enddt DATETIME 2. Set your variables SELECT @date = Convert(varchar,GetDate(),110), @starttime = ’16:50:00′, @endtime = ’23:50:00′ SET @startdt = CAST(@date AS DATETIME) + @starttime SET @enddt = CAST(@date AS DATETIME) + @endtime 3.  Use @startdt and @enddt…

Print Friendly
Read more...

SQL Server: Replace Invalid Date using ISDATE function

Written on:June 7, 2012
blue-information-glossy-button-md

I often run into invalid date formats.  Here’s one way to get around it. CASE WHEN ISDATE([Your_Date_Field]) = 1 THEN [Your_Date_Field] ELSE NULL END AS [Your_Date_Field] This code should replace the invalid date with a null.  You might also select into a temporary table to find the bad dates as well for cleanup.      

Print Friendly
Read more...

SSIS: SSIS Frameworks (Part 1)

Written on:April 2, 2012
ssis-dataflow

SSIS is Microsoft’s Extract, Transfer and Load (ETL) software that has evolved from the previously available technology in SQL Server 2000 called Data Transformation Services (DTS).  If you look at the names for objects used at run time the DTS prefix for objects is still very prevalent.  Many of us have been using SSIS for years, but without much guidance on how to get the maximum usage from this part of…

Print Friendly
Read more...

SQL Server: Time Saver writing complex joins

Written on:March 29, 2012
information

I have a few add-in products loaded for my work in SSMS.  One of which is SSMS tools.  This is a free add-in for SSMS and it works fantastic.  However, as well all know we are often faced with writing complex join statements.  If I had a dollar for every join statement I’ve ever written over the past years I’d be extremely wealthy.  So here’s my tip: If you are…

Print Friendly
Read more...

The Core Components of an SSIS Package

Written on:March 28, 2012
controlflow

In this post I want to point out the core components that are used to to create an SSIS package.  It’s important to not get confused between what is a development  environment feature and what that the feature actually provides.  For example, the toolbox is not a core component of an SSIS package, but it is a design feature that lets you select various controls to use when designing one…

Print Friendly
Read more...

SQL Server: Using the OPENROWSET function to query Excel data

Written on:March 27, 2012
blue-information-glossy-button-md

Whew! A few months ago I was tasked with importing data from that was composed of Sharepoint linked lists that were being used as part of an Excel worksheet for analysis. Part of the problem was that there wasn’t a standard set of columns to work with in the Excel worksheets. This made it difficult to import each row to a table because the rows could have different columns. Because…

Print Friendly
Read more...

Slowly Changing Dimension Wizard Step by Step

Written on:September 11, 2011
information

When working with analysis services in conjunction with a data warehouse or data mart you typically have one to many dimensions.  Dimensions can be thought of as the tables in your warehouse by which you want to slice and dice your fact table information.  For example, it is common to have a time dimension so that you can look at the measures in fact tables for a given amount of…

Print Friendly
Read more...