by Scott
18. April 2010 16:41
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
by Scott
12. April 2010 17:35
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
dbd9fe15-8768-4f04-aa61-5e7835f70efc|0|.0
Tags: Tools
General
by Scott
8. April 2010 06:44
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!
by Scott
1. April 2010 19:06
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.
by Scott
1. April 2010 06:58
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)
by Scott
30. September 2009 12:24
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
by Scott
9. July 2009 06:45
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.
by Scott
3. June 2009 04:08
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
by Scott
19. May 2009 00:16
VS2010 beta 1 and .net fx 4 ships! I just downloaded it from MSDN. Going to open up a project and see how it goes.
Here is a link for a first look of Visual Studio 2010
by Scott
11. May 2009 08:38
I just downloaded
TweetDeck and signed in. There is a problem that I just figured out how to solve. The TweetDeck icon appears in the taskbar, but TweekDeck is nowhere to be found. I am running a dual monitor setup and maybe that has something to do with it, but if you hover over the icon in the taskbar, and then right-click on the preview window that pops up, you gain access to the context menu that allows you to move. Click move, then press shift-Up arrow and then grab your mouse while still holding the shift key down. There it is! Apparently it opens up way off the screen. I hope they fix this soon. This is the only Adobe Air app I have ever used...I wonder if they're all like that? I need to find a good WPF/Silverlight client - I used
Witty in the past, but as cool as it is/was, it did crash occasionally.