Gildner Solutions

Comments not working

Filed under General

I just found out comments are not working on my blog since I upgraded to blogengine 2.0.  I am going to try and figure this out.

EDIT:  Comments should be working now.  It was a permissions issue on my server.

Upgraded to BlogEngine 2.0 RC

Filed under General

This installation was perfect!  Since I don't have any customizations, I just backed up my folder, installed the new version and then copied over my App_Data files (I don't run this blog off a database currently).  Cheers!

http://www.dotnetblogengine.net/

Scott

Using Fiddler with ASP.NET and FireFox

Filed under General

I attempted today to use Fiddler with firefox to debug my asp.net web site on my local developer machine.  I was greeted with:

[Fiddler] Connection to localhost failed.
Exception Text: No connection could be made because the target machine actively refused it ::1:11973

After messing with many of Fiddler's options, I found that by unchecking the "Enable IPv6 (if available)" option, traffic was once again flowing through Fiddler.  I am running Windows 7 64 bit with Visual Studio 2010.

Hope this helps somebody,

Scott

ReSharper 5.0 Unleashed

Filed under General

I've been using ReSharper sincer version 2.0, it's a must have for me.  Version 5.0 was released today to support VS2010.  Get it right here  I think I'll run VS2010 naked for a few days to see what goodies they baked in that R# provided in previous versions...

More to come for sure on this topic

Visual Studio 2010 at MSDN?

Filed under General

I am eagerly awaiting availability of Visual Studio 2010 on MSDN.  I anticipate since it's not out there already that they will release it after their big kick off at DevConnections

 EDIT:  It's here!

Adding a unique constaint to a column that allows nulls

Filed under General

I have an integer column in one of my database tables that allows nulls.  What I want is for any value other than nulls to be unique.  Here's how I did it:

CREATE UNIQUE NONCLUSTERED INDEX idx_SupplierID_notnull
ON Brands(SupplierID)
WHERE SupplierID IS NOT NULL; 

Brands is my table and SupplierID is the column I want to be unique.

Entering a NULL value using SSMS

Filed under General

This happens every once in a while, I need to enter a NULL value when opening a table in SSMS.  I'm writing it here so I don't forget what it is.

Highlight the field and press

CTRL + 0  (zero)

SourceSafe on it's way out!

Filed under General

I haven't used VSS since 2007, but good to see an "end of life" plan being developed to finally get developers off it.  The problem I've seen before is that TFS just plain costs too much.  This drives people to other solutions like Subversion and Git

http://tech.yahoo.com/news/infoworld/20090930/tc_infoworld/93983_1

Silveright and WCF on Windows 7 issues

Filed under General

I've just found a solution to a problem I was having.  Using SL2 when adding a service reference to my WCF service, my project compiles fine, but does not run.  I get the error:

"Unrecognized element '' in service reference configuration. Note that only a subset of the Windows Communication Foundation configuration functionality is available in Silverlight."

It turns out this is only a problem on Windows 7 rc. In your client side service reference file, something like MyServiceReference.ClientConfig, you'll have:

The fix is to remove the <security> element above that is circled.  Apparently this is not valid and only happens on Windows 7 RC.

Connecting to a remote development SQL Server 2008

Filed under General

I have a nice low-end Dell PowerEdge SC1430 server that I run out of my house to host some testing and development sites.  It's running Windows Server 2008 with SQL Server 2008 and is set up as a web server.  This has happen a few times now but I forget how to fix it every time, so I'm blogging about it.  I just reinstalled SQL 2008 because I botched it up somehow and it's sometimes easier to just start over.  After reininstalling and installing the server packs, I restored my databases and was back in action -- at least locally.  My IIS sites were running great.  So today I try to connect to my SQL Server 2008 instance through my laptop and SSMS and I'm shut out - connection failed.  I figure it's a firewall issue.  Nope, I already have port 1433 opened on both machines.  Some googling led to me a "allow remote connections" checkbox in the server instance properties.  Nope, already checked.  After an hour of racking my brain, I remembered one last thing -  enable the TCP/IP protocol on the SQL Server!

And bingo.  It works.

So, the next time I install a new SQL Server and need to allow remote TCP/IP access to it (through SSMS or a tool like SQL Compare), I'll take the following steps:

1.  Allow access to TCP port 1433 access on both the client and server machines through Windows Firewall (or whatever firewall that is used)

2.  In the properties of the server instance, under Connections, check the "Allow remote connections to this server":

3.  Enable TCP/IP access in the SQL Server Configuration Manager.

Hope this helps someone who was stuck like me.

Scott