Getting Started With Entity Framework 4.3.1

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/getting-started-with-entity-framework/

Sprinkler System Pump Assembly Demystified

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/sprinkler-system-pump-assembly/

How to Uninstall CollabNet Desktop Version 3.1.2.0

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-to-uninstall-collabnet-desktop/

Litter Robot Literally Randomly Starts/Stops Working

This article still exists! 

It has simply moved to:
http://obscureproblemsandgotchas.com/uncategorized/litter-robot-literally-randomly/

SSRS Report Viewer Control Broken Image Below Lines - Missing URL parameter: IterationId

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/ssrs-report-viewer-control-broken-image/

SSRS Logical Flaws of IIF

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/ssrs-logical-flaws-of-iif/

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. The request failed with HTTP status 404: Not Found.

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/the-attempt-to-connect-to-report-server/

How to Kill all Processes for a Specific Database

Usually you would just use the Activity Monitor like shown below...

The mundane repetition of right click each process and selecting
Kill Process becomes annoying after the n_th process. 

...buuuuut if you need to restore your Dev Database with fresh data, you need to kill all of the individual connections/processes before attempting a restore. Well when you are doing development work you can have over 10+ connections and using the Activity Monitor is very annoying to close all of them. Therefore I have come up with the following tSQL query:

SELECT
 dbid, 
 db_name(dbid) as DatabaseName,
 spid,
 KillStatement = 'KILL ' + CAST(spid AS varchar(10)) + '; '
FROM sys.sysprocesses
WHERE dbid = 15 -- Put your Databases ID here

The idea behind this query is to first find out what you database's ID is, enter the ID in the where clause and generate the KILL statements. Copy and paste the KILL statements and execute all of them at once. You will be warned about killing your own connection though like this:

Msg 6104, Level 16, State 1, Line 1
Cannot use KILL to kill your own process.

No worries though you can just kill that process in the Activity Monitor or just close the query window.

Enjoy

Worst Visual Studio 2010 Bug I Have Ever Seen

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/worst-visual-studio-2010-bug-i-have/

The Bestest Office Chair Evar

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/the-bestest-office-chair-evar/

Simple Class Creator Published on Google Code

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/simple-class-creator-published-on/

ObjectDataSource has no values to insert. Check that the 'values' dictionary contains values

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/objectdatasource-has-no-values-to/

Common Base Class Work Around for Page and UserControl

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/common-base-class-work-around-for-page/

Flottery: Florida Lottery Checker

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/flottery-florida-lottery-checker/

How to Make Your Recycled Printer Cartridge Work Flawlessly

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-to-make-your-recycled-printer/

ASUS Com Service (atkexComSvc.exe) Memory Leak Work Around

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/asus-com-service-atkexcomsvcexe-memory/

How to get rid of the black border on HDMI output on your AMD Radeon HD 7850

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-to-get-rid-of-black-border-on-hdmi/

Changed Blog Background

I changed the background of the blog because I think it is easier on the eyes. I have a problem staring at lines that are too close together like the last background. I apologize if that was hard on the eyes for anyone - this new background should even things out nicely.

I will be writing an article soon about office lighting, backgrounds, color and your eyes. Things people take very lightly, but should be more serious about. A preview of what I am referring to is - stop using white backgrounds especially if you wear glasses with a crappy prescription like mine.

How do I consolidate my student loans?

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-do-i-consolidate-my-student-loans/

GridView does not have a default Insert Support

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/gridview-does-not-have-default-inser/

Easy Way to Start/Stop SQL Server on a Multipurpose Machine

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/easy-way-to-startstop-sql-server-on/

Entity Framework: Executing SQL Strings

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/entity-framework-executing-sql-strings/

Entity Framework: Basic CRUD Operations

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/entity-framework-basic-crud-operations/

WCF: Why isn't my object showing up on the client side?

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/wcf-why-isnt-my-object-showing-up-on/

New cannot be used on a type parameter that does not have a new constraint

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/new-cannot-be-used-on-type-parameter/

How to get Filename and File Extension from a Column with tSQL

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-to-get-filename-and-file-extension/

Could not load file or assembly [AssemblyName] or one of its dependencies

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/could-not-load-file-or-assembly/

Why can't I access the System.Web.HttpUtility Class?

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/why-cant-i-access-systemwebhttputility/

Telerik RadGridView Hierarchical Data (Child Grids) for Winforms Gotcha

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/telerik-radgridview-hierarchical-data/

What to do after rooting your LG C800 T-Mobile myTouch Q

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/what-to-do-after-rooting-your-lg-c800/

How to root the LG C800 T-Mobile myTouch Q

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-to-root-lg-c800-t-mobile-mytouch-q/

Custom Controls in ToolStrip or StatusStrip

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/custom-controls-in-toolstrip-or/

Upgrade/Installing Parcloud Tomato on Asus WL-500gP (Premium) V2

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/upgradeinstalling-parcloud-tomato-on/

Telerik RadGridView Column Format Calamity

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/telerik-radgridview-column-forma/

WinForms: Object reference not set to an instance of an object

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/winforms-object-reference-not-set-to/

How to Combat Restricted Air Flow Due to Allergies

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-to-combat-restricted-air-flow-due/

DataGridViewButtonColumn Text Won't Show

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/datagridviewbuttoncolumn-text-wont-show/

Simple Class Creator

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/simple-class-creator/

Very Old Samsung 2 GB Drive the Sound of Old Tech

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/very-old-samsung-2-gb-drive-sound-of/

SQL Server: String or binary data would be truncated.

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/sql-server-string-or-binary-data-would/

SATA Drive Dynamic Invalid Disk

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/sata-drive-dynamic-invalid-disk/

Visio 2010 Activation Error 0x80072EFD

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/visio-2010-activation-error-0x80072efd/

DataGridView Loses Formatting and Columns After Setting DataSource a Second Time

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/datagridview-loses-formatting-and/

Windows Form Designer File Hell: Object reference not set to an instance of an object

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/windows-form-designer-file-hell-objec/

Programmer Breakfast

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/programmer-breakfas/

My.Request Equivalent in C#

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/myrequest-equivalent-in-c/

How to Convert a Rebate Debit Card into Almost Cash

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-to-convert-rebate-debit-card-into/

WSE: Server unavailable, please try later

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/wse-server-unavailable-please-try-later/

Windows Forms Project Crashes Immediately on Startup

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/windows-forms-project-crashes/

How to convert a String (Char Array) to List of Int (ASCII Decimal Equivalent)

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-to-convert-string-char-array-to/

WSE: You Cannot Return Custom Exceptions

I answered this on StackOverflow.com here:

http://stackoverflow.com/questions/138477/using-own-exceptions-in-wse-not-only-soapexception/9320072#9320072

Transactional Memory

This is pretty damn amazing:

http://arstechnica.com/business/news/2012/02/transactional-memory-going-mainstream-with-intel-haswell.ars

Its not a gotcha I solved, but still post worthy.

CS0246: The type or namespace name 'NameHere' could not be found (are you missing a using directive or an assembly reference?)

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/cs0246-type-or-namespace-name-namehere/

HTTP Error 404.2 - Not Found, Error Code 0x800704ec

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/http-error-4042-not-found-error-code/

HTTP 404.17 - Not Found, Error Code: 0x80070032

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/http-40417-not-found-error-code/

Repairing an ASP.Net installation for IIS7

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/repairing-aspnet-installation-for-iis7/

Can't Run Web Application After Renaming Web Project

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/cant-run-web-application-after-renaming/

Things Not Everyone Should Drink at Work: Chamomile Tea

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/things-not-everyone-should-drink-a/

Credit Cards: How to use them Correctly

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/credit-cards-how-to-use-them-correctly/

How to use Treasury Direct

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/how-to-use-treasury-direc/

Visual Studio's Immediate Window - C# vs VB.Net

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/visual-studios-immediate-window-c-vs/

Visual Studio Macros

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/visual-studio-macros/

Windows Services and Creating a Setup Project

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/windows-services-and-creating-setup/

SQL Server: Attaching a Second Copy of a Database that Exists Already in the Same Server

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/sql-server-attaching-second-copy-of/

SQL Server 2008 R2 will not install - Unhandled Exception has occurred in your application.

The post you are looking for still exists, it was just moved here: http://obscureproblemsandgotchas.com/uncategorized/sql-server-2008-r2-will-not-insta/

Visual Studio 2008 Installation - Debugger Not Installed!

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/visual-studio-2008-installation/

Notepad++ Errors: Doing a full Uninstall

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/notepad-errors-doing-full-uninsta/

Straight to the Point: Query for Database and Table Sizes

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/straight-to-point-query-for-database/

Query SQL Server using PowerShell

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/query-sql-server-using-powershe/

Selecting Random Date Between a Date Range with tSQL

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/selecting-random-date-between-date/