New Years Resolution: Leave FACEBOOK!

“If you’re building a product that people love, you can [afford to] make a  lot of mistakes.” – Mark Zuckerberg

Here is why I left Facebook, I do not respect Mark Zuckerberg the founder of Facebook. He doesn’t value your information which he proved in a series of text messages a few years ago. The company has a lack of concern about your private data, allowing third parties such as Zynga access to data the shouldn’t have required. Facebook has since fixed this only to run into further privacy concerns.

People are addicted to Facebook

People are posting where they are on Facebook, great you just potentially told a theif, “Hey I’m not home right now, so take all of my cool electronics”. People are posting what they had for breakfast! Really who cares, you aren’t two years old anymore. Maybe these people should try to put their time to better use, like learning something new, get a job, try to be a better version of you. Think about all the time you spend on Facebook, it adds up! If you are complaining about your place in the world quit Facebook, you will find that you are actually doing things again and moving in a better direction.

Quitting Facebook, what you should know

Facebook hired a consulting company to figure out what would make you want to stay, they give you a pathetic form to fill out. They are trying to play on your emotions to keep you in their clutches. Good news, you fill it out, click submit, and you are free. Free to get on with your life.

Life After

I quit at the start of the New Year after watching a CNBC documentary on Facebook, it was really enlightening. I urge everyone to watch it. Please people, time to get on with living and spend less time on your computer.


WD TV Live Plus HD ~ Review and Tips


Greetings again, I recently acquired a WD TV Live Plus HD. At first I was rather suprised how tiny the device is. Once plugged in, be prepared for a a lot of patches. Not exactly what I call a good time but with each upgrade you can see a lot of new and improved functionality. If they keep on improving the software, as well they should, it’s only going to get better.


Navigating through the system is fairly self explanatory. There are a lot of services available to you in the internet media section. Any network shares you have setup are available to you (with some configuration in the settings).

The remote leaves me wanting more. The buttons are rather small and require a little more pressure applied to them to get them to work. Western Digital does provide the ability for a USB keyboard (even wireless). I have yet to try this but I’m very anxious to use a keyboard with it, I have seen a keyboard used and it is much faster to navigate and search for your shows.


1080P (via HDMI), need I say more… The clarity is superb. Of course, one caveat is the video is only as clear as the source. If a YouTube video is low res, the video on the WD is going to be grainy, especially if it’s on a big screen. The WD TV Live Plus includes CVI/RCAs that plug into the back of the device with a minijack connector.


As mentioned earlier, the device can accept a keyboard from one of it’s two USB ports. These USB ports can also accept a wireless adapter or a WD portable hard drive.  YOU HAVE TO REVIEW THE LIST ON WD’S WEBSITE FOR A COMPLETE LIST OF WHAT IS ACCEPTED AS IT IS VERY PICKY. The list can be found here.

Note: The portable hard drives take a while to be recognized, but typically install in a minute. You will see a new icon in Settings > File Management if it was successfull

Wireless ~ Tip

If you are like me, your TV is far away from your router. I took a look at the list WD provides and didn’t like the fact that they get extremely particular, down to versions numbers of the hardware, something you can’t get to without blind luck. You could buy something like a Linksys Range Extender, they work well if you do not have a lot networks surrounding your home plus, they don’t yet offer wireless-n.

My solution was to create a wireless bridge using my dual-band Netgear router, (I purchased a second one to get this to work). The great thing about doing that is the dual band functionality. All of my other devices are either wired to my base router or using standard 2.4ghz wireless g. All of my “entertainment” devices at my tv (like an Xbox, Wii,Blue-Ray) are wired into the repeating-secondary-router. On the base and secondary routers, the 5ghz band is reserved for just communicating to one another. 5ghz does not recieve as much interference as 2.4ghz and transfers data much faster (300mbs vs 54 mbs) than a standard wireless g on 2.4ghz.

If you are interested in a more detailed explanation, let me know, I will be happy to post a more detailed explanation with some instructions.

How To Get Lots of TV Shows offers a lot of great value. Install it on a computer you don’t mind running all the time. Basically it turns your PC into a media server. Your PC, using, will grab shows from tv websites that they are providing. The TV Live Plus can connect to your PC (media server) and browse through content and play them on your TV. Also, you can stream the channels to your phone. All this for a one time fee of $50 for the software.

Hulu Plus offers good value. They offer a free trial but you have to pay every month.

Flingo, currently free, has some great exclusive content. I really enjoy Engadget, and if you are reading this, I am sure you will too.

Drop All Tables in a Database

So I recently had to delete all tables in a database based on schema name. Here is the solution I came up with:

DECLARE @tblName VARCHAR(200) ;




SELECT SCHEMA_NAME(schema_id) + ‘.’ + name AS tableName

FROM sys.tables

WHERE schema_id IN (SCHEMA_ID(‘admdb’), SCHEMA_ID(<Your Schema Here>), SCHEMA_ID(<Your Schema Here>)) ;


OPEN tbl ;





EXEC(‘DROP TABLE ‘ + @tblName) ;





CLOSE tbl ;



A couple things worth mentioning is that I set the table name to 200 character varchar. Of course this script can do some damage, please, please, please make sure you don’t need anything in any of the tables before running this!

By default, drop table does not accept a variable but if you turn it into a dynamic query (wrapping it in an execute function) works perfectly.

IE9 & Firefox 4 – Facebook & Flash Issues Continued

Are you having problems with Facebook games on Facebook using IE9 or Firefox 4? Another solution…

So I figured something out recently, if you need the hardware acceleration turned on (I have to admit it is a nice thing to have) in your web browser, the problem might be related to your graphics driver. Most laptops today use the Intel graphics drivers. Go to to download the latest drivers (Microsoft’s Windows Update is a little behind on this) then follow the on-screen installation steps. If you are unsure which drivers you have on your system they have a utility that can help you, simply go to

If this is not the case for you I recommend going to my previous post, which is still very useful if you are not using an Intel chipset.

Subscribe to this blog if you like this tip.

Fun With Images and Photographs – Photosynth

This is very interesting and compelling. Anyone have an other great ideas for processing of images? What are your plans for images? I would love to hear them as I am planning my own project similar to this one but to a different end and for a different purpose.

More on SQL Server Denali!

This guy has a great blog article on high availability on the latest version of SQL Server. I highly recommend reading it. Unlike previous versions, you can query all the nodes and you aren’t limited to a two node configuration like before! I have another article, a very terse one, here:

SQL Server Denali: HADRON ROCKS. | Brent Ozar – Too Much Information | Brent Ozar – Too Much Information.

Hotmail / Live POP3 Settings

In case you are like me, carrying around a smart phone;  I would like to receive email from my ancient Hotmail account. After some searching I found the info here: which was posted by dubstar_04.

K9Mail is a little more complex to setup than the default email client for Android but is far superior when it comes to speed and ease of maintenance.

In case the link gets broken here is what he posted:

It seems that this is a little known fact that msn / Hotmail pop3 access can be gained using these settings. I find that K9 Mail works better than the standard email app. Incoming: Username: Password: your password POP server: Port: 995 Security type: SSL (always) Outgoing: SMTP server: Port: 25 / 587 Security type: TLS (always) Username: Password: your password When i first set an account up it brings back some blank mail, which i delete after that it works fine. Regards, Dubstar_04

If you are reading this, chances are you have a Windows Live or Hotmail account. If that is the case, I recommend another one of my articles to get the most out your Skydrive.