I'm sure everyone is familiar with the system: one finger means you have to pee, two mean you have to poo. Yaty and I find this inadequate. Sometimes there are things that need to be done outside of the parameters that a simple number system works well with. Here is our proposal:

1. Pee
2. Poo-Poo
3. Diareah
4. Vomiting
5. 1-4
6. Total Jerk

You'll see that 1-4 each have as many syllables as their number, for an easy mnemonic. Number five is the dreaded one through four. That one's tough and makes you drive like crazy in traffic. Thus we assume that most bad drivers in traffic are either a #5 or #6. Also to this list #0 constipation and #7 everything else. #0 should be obvious, and #7 is just borrowed from the recycle numbers.

Apparently while I wasn't paying attention, Sony made pages for Playstation Network profiles:

Playstation Profile DKFour

Props to Kooshmoose.

A comment by poster "Zaphod Beeblebrox III" helped me find it:

Microsoft Showcase: Windows Media Center: Netflix and The White Gloves:

...you have to go to Tasks -> Settings -> General -> Automatic Download Options in Media Center and then click the button to run the update manually. Then, a new option for Netflix shows up under the Movies section and the prompts guide you through an easy Netflix installation.

However this wasn't obvious, I even went into the "Automatic Download Options" page, but it appeared to just be for album art and such, it wasn't until this comment sent me back that I saw the manual update button, which then prompted me to "setup Internet", which seems odd since I can't figure out what the setting up process did...

9 Principles, 12 Values : Glenn Beck – The 912 Project:

It is not un-American for me to disagree with authority or to share my personal opinion. On your right to disagree “In a free and republican government, you cannot restrain the voice of the multitude; every man will speak as he thinks, or more properly without thinking.” George Washington

Wow, apparently he hasn't really thought about the quote he used? Or didn't realize that this was George Washington's argument against a representative democracy and for a republic? I mean, honestly, the above is the sort of quote that Colbert would use mocking the right, but apparently the right is attempting to put Colbert out of business?

I had been using Microsoft's Live OneCare. It seemed to have less issues than McAfee or Norton when I first got it, and then I discovered that I only needed 1 subscription for the entire house, I liked that. However no one else seemed to like it, so Microsoft is killing it. Enter Microsoft's new plan:

Virus, Spyware & Malware Protection | Microsoft Security Essentials:

Microsoft Security Essentials provides real-time protection for your home PC that guards against viruses, spyware, and other malicious software.

Microsoft Security Essentials is a free* download from Microsoft that is simple to install, easy to use, and always kept up to date so you can be assured your PC is protected by the latest technology. It’s easy to tell if your PC is secure — when you’re green, you’re good. It’s that simple.

Now I'm not sure how a bad selling product being replaced by a free product makes a company more money, but I need to find something to replace the sunsetted Live OneCare so this is as good a place as any to start...

Enabling CLR Integration:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'clr enabled', 1;

GO

RECONFIGURE;

GO

Very exciting T-SQL script used today...

Creately Releases Its Simple Diagramming And Design Tool To The Masses:

Creately, an online diagramming and design application launched by Cinergix and showcased at TechCrunch50’s Demopit in 2008, is unveiling its online tool to the greater public (the startup has been in private beta). Creately lets anyone create create and collaborate on flow charts, wireframes, network diagrams, sitemaps and more within its site.

Very impressive. By the look of the video there is a new #2 contender to the Visio throne, and perhaps a future Google acquisition...

LINQ to XSD - Home:

The LINQ to XSD technology provides .NET developers with support for typed XML programming. LINQ to XSD contributes to the LINQ project (.NET Language Integrated Query); in particular, LINQ to XSD enhances the existing LINQ to XML technology.

Still not native, even in .NET 4.0, but no longer seems to be in alpha.

Initially when I named my PC I picked the generic "StudioXPS" which is the model of dell, or so I thought I did. Actually I named it "SudioXPS" as if I am a huge Phil Collins fan... I know it's a pain to change names, and the places that machine name gets carved in stone, but the OCD kicked in and I NEEDED to fix it. And, as expected, SQL Server wasn't so happy.

SQL Learnings: Can't Modify/Delete Maintenance Plans in SQL 2005 after Rename:

After renaming SQL Server 2005 server the maintenance plans couldn't be deleted. When trying to delete or modify a plan user gets an error. Using the SSMS there is no way to delete the plan. I thought it might a similar issue to I had encountered with SQL Server 2000 Jobs (link); so I searched to see if Maintenance plans table was storing server name and couldn't find anything.

Not so fast, my machine didn't even seem to like that, so let's manually delete all jobs first:

Sql Server 2005 Delete Maintenance Plan Error « Gediminas (Gedas) Gudenas:

Below is the manual SQL fix to address this error: Drop failed for Job ‘XXXXXXXXXXXXX’. (Microsoft.SqlServer.Smo) The DELETE statement conflicted with the REFERENCE constraint “FK_subplan_job_id”. The conflict occurred in database “msdb”, table “dbo.sysmaintplan_subplans”, column ‘job_id’. The statement has been terminated. (Microsoft SQL Server, Error: 547)

Then back to the first page, and voila! We're ready to do the Maintenance Plan Wizard from scratch. Thanks Hive Mind that we call the Interwebs! *bawk* *bawk*