Posts

Showing posts from 2012

Using SqlDependency without providing an options value Error

Using SqlDependency without providing an options value Error.
When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance.
Using SqlDependency without providing an options value Exception.

SqlDependency is awesome.  It truly is.  Problem is it has a lot of unexpected behaviors to an SqlDependency noob. 

I got this error: "When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance" couple of hours ago and I decided to share.

This error occurs if you didn't started your SqlDependency or it got closed for some reason.  I usually start it this way in the Global.asax:

protectedvoid Application_Start(Object sender, EventArgs e)  {    var sConn = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;    SqlDependency.Start(sConn);�����…

Get Month Name In Javascript

Month Name in JavaScript.
Get Month Name Javascript.
Javascript Date Object, Months Names.

There's a very simple way to get the month's name in javascript.  The only problem is, that people do it over and over instead of just placing this in the Date object.

Do, the solution is rather simple:

Date.prototype.getMonthName = function() {
var monthNames = [ "January", "February", "March", "April", "May", "June",
                        "July", "August", "September", "October", "November", "December" ];
return monthNames[this.getMonth()];
     }

Next time you'll want to get a name you can just:
var month_Name = new Date().getMonthName();

p.s.
Sometime in the near future I'll upload a file with all of my extensions to Javascript's Array and Date objects.

Elad Shalom,
CTO at ITweetLive.com

Deleting Folders In Visual Studio

Deleting Folders In Visual Studio.
Deleting Folders In TFS.
Removing Folders In Visual Studio.
Removing Folders In TFS.

I just got the most annoying message while trying to delete a folder in Visual Studio 2010 that is connected to TFS:

"This operation cannot be completed. You are attempting to remove or delete a source-controlled item where the item is either exclusively locked elsewhere or otherwise unable to be deleted from source control."

The solution is very simple.

Create an item inside the folder you are trying to delete.  No need to check in.
Now delete that folder.

TFS and VS have some weird bug with deleting empty folders, so, this is the fastest workaround.

Hope it helped,
Elad Shalom,
CTO at ITweetLive.com

Find was Stopped in Progress Visual Studio

Image
Find was Stopped in Progress.
Visual Studio 2010.
Visual Studio 2005.

 Visual Studio has some known issues.  One of them is the inability to search something using Ctrl+Shift+F because of the following error:

"Find was stopped in progress".

DataSet HasTables Method

DataSet Extentions.
Add Methods to Objects.

So, it's getting me tired to always right:
     if (ds != null && ds.Tables.Count > 0)
to make sure that a certain dataset really has tables inside.

So here is an extension I added to the DataSet object:
publicstaticbool HasTables(thisDataSet ds)         {             if (ds != null && ds.Tables.Count > 0)                 returntrue;             returnfalse;         }
Simple, yet efficient :)

Elad Shalom,
CTO at ITweetLive.com

DataTable HasRows Method

DataTable Extentions.
Add Methods to Objects.

So, it's getting me tired to always right:
     if (dt != null && dt.Rows.Count > 0)
to make sure that a certain table really have rows.

So here is an extension I added to the DataTable object:
publicstaticbool HasRows(thisDataTable dt)         {             if (dt != null && dt.Rows.Count > 0)                  returntrue;             returnfalse;         }
Simple, yet efficient :)
Elad Shalom,
CTO at ITweetLive.com

Change Primary Key SQL

Change Primary Key in Sql Server 2005 .
Change Primary Key in Sql Server 2008.
Change PK from Clustered to NonClustered in Sql Server.

Just this morning I encountered a problem in my database performance.
It appears like the person who created the table created the primary key as a clustered one, without thinking of what will be in the future and the purpose of the Id PK in the table.

After digging the web, I found this great answer which gave me the hint for the desired solution:

use MyDB
DROP INDEX MyTable.IX_MyTable_FamilyName
ALTER TABLE MyTable
    ADD CONSTRAINT UQ_TableX UNIQUE(Id)

ALTER TABLE MyTable
    DROP CONSTRAINT PK_MyTable

ALTER TABLE MyTable
    ADD CONSTRAINT PK_MyTable PRIMARY KEY NONCLUSTERED(Id)

ALTER TABLE MyTable
    DROP CONSTRAINT UQ_TableX

CREATE NONCLUSTERED INDEX IX_MyTable_FamilyName ON MyTable(FamilyName)



This solves it :)
p.s.
it takes some time to drop and re-index everything.

Elad Shalom,
CTO at ITweetLive.com

Single Responsibility Principle

Image
"The simplest way to do something is usually the best"