Reputation
6,572
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 24 47
Newest
 Curious
Impact
~246k people reached

Mar
2
answered Entity Framework limitation
Mar
1
answered WPF vs. WinForms - a Delphi programmer's perspective?
Feb
23
comment Best practices for connecting from ASP.NET to SQL Server?
I agree. This is the option I'm leaning toward. I just wanted to understand all the options before I pursued one over the others.
Feb
23
comment Best practices for connecting from ASP.NET to SQL Server?
By running ASP.NET as testuser. So in IIS under the app pool, you can configure the app pool to run as Network Service (the default), or a particular NT ID.
Feb
23
comment Best practices for connecting from ASP.NET to SQL Server?
Can you expand on this Wyatt? Because I can't seem to get this working. Let's say you want users to authenticate against IIS with Windows Auth, and you want ASP.NET / IIS to talk to SQL Server with a particular NT ID - call it testuser. Then you have to run ASP.NET as testuser, right? And then in order to get Kerberos working you have to set up an SPN for testuser against that server. This is what I've found to be the case. What am I doing wrong? You can look at my serverfault post that I linked to for more details.
Feb
23
comment Best practices for connecting from ASP.NET to SQL Server?
Yes I should've included the encryption in my writeup. Almost certainly if you are going with the first option you would want to encrypt the connectionstrings section of the web.config. But this is still a con, as encryption adds complexity, and you have to maintain the password, change it between QA & Prod, etc.
Feb
23
asked Best practices for connecting from ASP.NET to SQL Server?
Feb
16
comment What can programmers learn from the construction industry?
+1 Wow this is a great analogy. I plan on shamelessly stealing it. :-)
Feb
16
answered How many ASP.NET developers program using pure OO?
Feb
15
comment Advantages of object-oriented programming
Downvoter care to give a reason?
Feb
4
comment Should you sacrifice code readability with how efficient code is?
+1 I was scrolling down quickly to make sure this quote was included. Now I don't have to put in an answer. :-)
Feb
3
comment What should you test with unit tests?
+1 Good explanation of Red,Green,Refactor,Repeat
Feb
3
comment Why isn't software as reliable as a car?
+1 Building a car is not the equivalent of building a software program. Building a car is more equivalent to running a software program. Designing and speccing a car is more equivalent to building a software program. And there are tons of problems during car design that get ironed out along the way, just as with software.
Jan
26
comment Can lack of “bit parity” between web server and DB server impact performance?
That is interesting Martin. Is there any reference page for this binary channel conversion?
Jan
26
comment Can lack of “bit parity” between web server and DB server impact performance?
That is a good idea. I am planning on doing that. The point of this question was to make sure I wasn't crazy before I did so. :-)
Jan
26
comment Can lack of “bit parity” between web server and DB server impact performance?
That is what the vendor was claiming, yes. Performance of 32,32 or 64,64 is higher than 32,64 or 64,32.
Jan
26
answered Property-coalescing operator for C#
Jan
26
answered Is “call and return” a pattern or an antipattern?
Jan
26
comment Can lack of “bit parity” between web server and DB server impact performance?
TCP has flow control... Maybe we aren't talking about the same layer or something? In general, "normal" network traffic does have flow control. But this is immaterial to this question I think. Reference: en.wikipedia.org/wiki/…
Jan
26
comment Can lack of “bit parity” between web server and DB server impact performance?
That would be possibly only if they were using low-level network protocols that allowed for that kind of thing. Using "normal" TCP/IP or whatever prevents those types of issues. And speed of sending vs. speed of receiving has nothing to do with server "bit-ness".