Agile Development, Architecture, .NET and The Art of Listening  RSS 2.0

Navigation
 Sunday, January 06, 2008
Google Chart API --> http://code.google.com/apis/chart/
Google Analytics --> http://www.google.com/analytics/
Sunday, January 06, 2008 3:22:01 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Cool | Tools | Useful stuff
TimeSnapper is an Automatic Screenshot Journal.
It runs in the background of your computer, taking screenshots of your desktop every few seconds all week long.
http://timesnapper.com

Sunday, January 06, 2008 3:02:09 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Cool | Tools
NSIS (Nullsoft Scriptable Install System) is a professional open source system to create Windows installers. It is designed to be as small and flexible as possible and is therefore very suitable for internet distribution.
http://nsis.sourceforge.net

Sunday, January 06, 2008 3:00:06 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Tools | Useful stuff
Sunday, January 06, 2008 2:58:55 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Tools | Useful stuff
Eric Sink's book --> http://www.ericsink.com/bos/Business_of_Software.html

Podcast on the topic from Scott --> Hanselminutes Podcast 47 - How to start your own MicroISV

25 steps on secreetgeek.net --> http://secretgeek.net/25steps.asp

I recommend comprehend the material in the order listed here. Book give you reqlly good base, espeacially if you don't have a business degree. Leon Bambrick in his interview and his blog gives some practical perspective.

Sunday, January 06, 2008 2:53:23 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Book | Podcast | Useful stuff | microISV
The Ruby Way: Solutions and Techniques in Ruby Programming, Second Edition
by Hal Fulton
Publisher: Addison Wesley Professional
Pub Date: October 25, 2006
Print ISBN-10: 0-672-32884-4
Print ISBN-13: 978-0-672-32884-8
Pages: 888
http://techbus.safaribooksonline.com/0768667208

Sunday, January 06, 2008 2:40:53 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Book | Ruby
Sunday, January 06, 2008 2:39:31 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | Architecture | Useful stuff | Patterns & Practices
Sunday, January 06, 2008 2:37:47 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
EAI | SOA | Useful stuff
Sunday, January 06, 2008 2:37:10 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Architecture | SOA | Useful stuff | EAI
Sunday, January 06, 2008 2:35:56 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Architecture | Book | Useful stuff
An Overview of XML Support in SQL Server 2005
http://www.15seconds.com/issue/050803.htm

Improving XML Data Access Performance with SQL Server 2005
http://www.15seconds.com/issue/050811.htm

Improving XML Update Performance with SQL Server 2005
http://www.15seconds.com/issue/050818.htm

Sunday, January 06, 2008 2:34:24 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
2005 | Performance Tuning | SQL Server | T-SQL | Useful stuff | XML
Sunday, January 06, 2008 2:32:46 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Useful stuff
 Sunday, December 30, 2007
Pragmatic Programmers is my favorite publisher.
Now they also have a podcasts http://www.pragprog.com/podcasts

Sunday, December 30, 2007 12:52:53 PM (Central America Standard Time, UTC-06:00)  #    Comments [1] -
Book | Podcast
 Friday, December 28, 2007
Friday, December 28, 2007 11:10:14 AM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
2005 | Helped with work | SQL Server | T-SQL | Useful stuff
 Thursday, December 27, 2007
Thursday, December 27, 2007 5:26:09 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
2005 | Cool | Helped with work | SQL Server | T-SQL | Useful stuff
Continues Integration Factory
http://www.cifactory.org/


CruiseControl.NET is an Automated Continuous Integration server, implemented using the Microsoft .NET Framework.
ccnet.thoughtworks.com
Thursday, December 27, 2007 9:31:44 AM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Continues Integration | Cool | Tools | Unit Testing | Useful stuff | Version Control
 Wednesday, December 26, 2007
Wednesday, December 26, 2007 4:11:21 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
2005 | Cool | Helped with work | SQL Server | T-SQL | Useful stuff
 Tuesday, December 25, 2007
Jeff Atwood has really nice post.

http://www.codinghorror.com/blog/archives/001025.html

I looked at Ruby couple times before and really liked how the syntax feels. Since version 2 of Ruby on Ralis came out and I bought a book few month ago I should really concentrate and try to learn it. With IronRuby on .NET framework and DLR I feel that I own myself to learn the original language  and framework first and only then copmare it to IronRuby implemention.

Tuesday, December 25, 2007 11:29:41 AM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Cool | Useful stuff | Ruby
 Monday, December 24, 2007

USE AdventureWorks;
GO
-- Passing values as constants.
EXEC dbo.uspGetWhereUsedProductID 819, '20050225';
GO
-- Passing values as variables.
DECLARE @ProductID int, @CheckDate datetime;
SET @ProductID = 819;
SET @CheckDate = '20050225';
EXEC dbo.uspGetWhereUsedProductID @ProductID, @CheckDate;
GO
-- Try to use a function as a parameter value.
-- This produces an error message.
EXEC dbo.uspGetWhereUsedProductID 819, GETDATE();
GO
-- Passing the function value as a variable.
DECLARE @CheckDate datetime;
SET @CheckDate = GETDATE();
EXEC dbo.uspGetWhereUsedProductID 819, @CheckDate;
GO



http://msdn2.microsoft.com/en-us/library/ms189915.aspx
Monday, December 24, 2007 3:33:32 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
2005 | Performance Tuning | SQL Server | T-SQL | Useful stuff
Monday, December 24, 2007 3:30:49 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
2005 | Performance Tuning | SQL Server | When things go wrong
http://www.msdner.com/dev-archive/84/19-85-847101.shtm

SELECT
Cast(a.XML_Data as XML) as XML_Data
FROM OPENQUERY([LINKED SERVER NAME HERE],'
SELECT
Cast(XML_Data as Varchar) as XML_Data
FROM
[DATABASE NAME].[SCHEMA].[TABLE NAME]'
) A

Basically, the data is queried on the remote server, converts the XML data to a varchar, sends the data to the requesting server and then reconverts it back to XML.

StephenDudzic at 2007-9-3 22:09:22 >

"Re: XML data type not supported in Distributed Queries This is a limitation in SQL Server 2005. Columns of xml type or CLR type cannot be queried directly or referenced from one server to another - this means the following:
  1. You cannot use a table or view that contains xml or clr type as 4-part name in your query
  2. You need to cast the column to either nvarchar(max) or varbinary(max) or other appropriate type to use
  3. If you have a table that has xml type for example then you need to create a view that contains all columns other than xml and query it instead. Or you can issue a pass-through query using OPENQUERY with the appropriate columns only."
Monday, December 24, 2007 3:26:18 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
2005 | SQL Server | T-SQL | When things go wrong
Monday, December 24, 2007 3:25:08 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | ASP.NET | Useful stuff
Monday, December 24, 2007 3:23:44 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Useful stuff | Version Control
Monday, December 24, 2007 3:21:30 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
2005 | SQL Server | T-SQL | When things go wrong
"Fiddler is a HTTP Debugging Proxy which logs all HTTP traffic between your computer and the Internet. Fiddler allows you to inspect all HTTP Traffic, set breakpoints, and "fiddle" with incoming or outgoing data. Fiddler includes a powerful event-based scripting subsystem, and can be extended using any .NET language."

http://www.fiddlertool.com/fiddler/
Monday, December 24, 2007 3:20:08 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Cool | Helped with work | Tools | Useful stuff
Monday, December 24, 2007 3:18:19 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Tools
Have not tried it myself, but looks promising.

http://www.spry.com/webmin-vps/

And the best shared hosting ever that I use is www.Hostmysite.com
Monday, December 24, 2007 3:17:06 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Useful stuff | Web Hosting
 Sunday, December 23, 2007
Sunday, December 23, 2007 7:26:14 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Useful stuff
Sunday, December 23, 2007 7:21:48 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | SOA | Web Services | When things go wrong
Sunday, December 23, 2007 7:20:40 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | ASP.NET | Performance Tuning | Web Services | XML
Sunday, December 23, 2007 7:19:44 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Helped with work | Useful stuff
Sunday, December 23, 2007 7:18:48 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | When things go wrong
Sunday, December 23, 2007 7:17:09 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | ASP.NET | Web Services
Sunday, December 23, 2007 7:16:26 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | ASP.NET | Web Services
Source Link

I am developing a web service for a customer. The service has a method, that
returns an array of Forms. Each form has a Name property of Type String.

The customer wants the contract to specify, thath the name is mandatory and
not nullable. To reflect this, they want the xml in the wsdl (the Form part)
to look similar to this:

<xs:complexType name="Form">
<xs:sequence>
...
<xs:element minoccurs="1" maxoccurs="1" name="Name" nillable="false" type="xs:string">
...

So, minOccurs should be 1 and nillable should be false (or omitted), to
ensure the value is present and not null.

No matter how I go about this, however, I cannot make the wsdl generate the
desired values. I have tried to do contract-first development using WSCF from
thinktecture, and have the schema dictate the above values for minOccurs and
nillable, but this approach has not remedied the problem.

Is it at all possible to do what I want using .Net and Visual Studio 2005? I
hope my problem is described adequately, otherwise please request more
information. Any help is greatly appreciated.


Regarding on the webservice class property definition problem you
mentioned, here are some of my understanding and suggestion:

1. .NET webservice will always generate the xsd scheme for class property
as below:

** for value type(primitive types or struct), it will use minOccurs="1"
since value type will always be assigned a value(doesn't have null value
unless you use nullable type).

** for reference type(such as normal class), it will use minOccurs="0"
since value type will always support null value, the "string" type in your
case is just conform to this policy.

So far this rule is not changable in our custom code(attribute).

2. Also, XML XSD schema definition's element definition doesn't 100%
completely identical to .NET(or OO ) class/type definition. For example, if
you have the following xsd schema

<element minOccurs="1" ..../>

you can not find a reference type to mapping it since reference type always
support null reference value. I think you can consider define a wrapper
class(which inherit from ValueType ), property of such type will be
automatically generated as minOccurs="1" in XSD schema. However, you still
need to ensure that any sub property of reference type(such as string) has
been supplied a value in your own code.

Sincerely,

Steven Cheng
Microsoft MSDN Online Support Lead







Sunday, December 23, 2007 7:09:59 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | Web Services | When things go wrong | XML
Kimball University (KU) is the definitive source for dimensional data warehouse education. We provide the highest quality and most practical education consistent with our instructors’ books and extensive experience in the dimensional approach. You’ll learn from the best in the business. http://www.kimballuniversity.com/
Sunday, December 23, 2007 7:08:46 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
BI
Sunday, December 23, 2007 7:06:35 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Tools | Oracle
Sunday, December 23, 2007 7:05:32 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
SQL Server | Useful stuff
Sunday, December 23, 2007 7:04:27 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Helped with work | SQL Server
Sunday, December 23, 2007 7:03:26 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
BI | SQL Server | Useful stuff
http://codebetter.com/blogs/eric.wise/archive/2006/11/16/Note-to-self_3A00_-Firefox-Windows-Authentication.aspx


To enable windows authentication on your domain.
  1. Open Firefox
  2. Navigate to the url about:config
  3. Locate the following preference names and put as the value the comma separated values of the address roots.
  • network.automatic-ntlm-auth.trusted-uris
  • network.negotiate-auth.delegation-uris
  • network.negotiate-auth.trusted-uris
Your value should look something like this: localhost, server1, server2, serverX
Sunday, December 23, 2007 6:19:49 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Helped with work | Useful stuff
Sunday, December 23, 2007 6:17:02 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
Web Services | SOA
Sunday, December 23, 2007 6:16:10 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | Security
Sunday, December 23, 2007 6:15:32 PM (Central America Standard Time, UTC-06:00)  #    Comments [0] -
.NET | Performance Tuning | Useful stuff | Web Services