How to bake Jachnun

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-bake-jachnun/

A very simplistic explanation of events 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/a-very-simplistic-explanation-of-events/

TSQL: Passing objects to stored procedures via XML

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

If you use Blogger with Google+ for comments you will lose the ability to review comments

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/if-you-use-blogger-with-google-for/

Simple Class Creator and DTO Generator

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-and-dto-generator/

Visual Studio 2012 Crashes When Attaching to Process or When Opening Solution

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-2012-crashes-when/

Dell Latitude E6400, Topaz Signature Pad and Broadcom USH Drivers

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/dell-latitude-e6400-topaz-signature-pad/

Setting Up WCF with Windows Authentication

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

Bank of America Master Card Points Reward Program Dollar and Points Ratio

This post has moved along with the rest of this blog to WordPress please go to this link here: http://obscureproblemsandgotchas.com/uncategorized/bank-of-america-master-card-points/

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/

Litter Robot Literally Randomly Starts/Stops Working

This article still exists! 

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

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

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/

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 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/

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/