vlad navazhylau's blog - bad things happen to good people

comments spam

vlad — Wed, 12 May 2010 07:14:00 +0200

Wondered why my google analytics data was going up when there was not any content update in last 6 month or so.The secret was comment spam ;-(

Massive comments’ spam has been cleaned up. New version of BlogEngine has some better spam fighting features.

Blogengine 1.6.1 has some new admin features as well that allow more or less bulk comment deletes.

An upgrade from version 1.5 of BlogEngine to 1.6.1 was pretty easy since I did not have too many customizations. Left “themes” and “app_data” folders unchanged > deleted everything else > uploaded new files from version 1.6.1 without overriding before mentioned folders.

Anything But SourceSafe

vlad — Tue, 22 Apr 2008 12:24:22 +0200

Source Control: Anything But SourceSafe -> http://www.codinghorror.com/blog/archives/000660.html
Visual SourceSafe Version Control: Unsafe at any Speed? -> http://www.developsense.com/testing/VSSDefects.html
Visual SourceSafe: Microsoft's Source Destruction System -> http://www.highprogrammer.com/alan/windev/sourcesafe.html

Source Control HOWTO -> http://www.ericsink.com/scm/source_control.html

Article "Version Control for Multiple Agile Teams" by Henrik Kniberg http://www.infoq.com/articles/agile-version-control

CSS contents and browser compatibility

vlad — Mon, 03 Mar 2008 12:48:14 +0200

http://www.quirksmode.org/css/contents.html
http://en.wikipedia.org/wiki/Comparison_of_layout_engines_(CSS)
http://www.thenoodleincident.com/tutorials/box_lesson/boxes.html

Checks Web sites for broken links.

vlad — Mon, 25 Feb 2008 11:57:05 +0200

It is hard to live without tool like Xenu's Link Sleuth in today Internet age. This tool help me with projects at work. I scanned this blog and found that I need to do some cleaning here as well.

"Xenu's Link Sleuth (TM) checks Web sites for broken links. Link verification is done on "normal" links, images, frames, plug-ins, backgrounds, local image maps, style sheets, scripts and java applets. It displays a continously updated list of URLs which you can sort by different criteria. A report can be produced at any time. "

Tuning Up SQL Server 2005 Databases

vlad — Tue, 25 Dec 2007 06:30:49 +0200

http://www.w3schools.com/sql/sql_select_into.asp

Work around for XML data type not supported in Distributed Queries

vlad — Tue, 25 Dec 2007 06:26:18 +0200

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:

You cannot use a table or view that contains xml or clr type as 4-part name in your query
You need to cast the column to either nvarchar(max) or varbinary(max) or other appropriate type to use
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."

Indexing encrypted data

vlad — Tue, 25 Dec 2007 06:21:30 +0200

http://blogs.msdn.com/raulga/archive/2006/03/11/549754.aspx

Simple JAVA and .NET SOA interoperability

vlad — Mon, 24 Dec 2007 10:21:48 +0200

http://www.infoq.com/articles/REST-INTEROP

Memory Leak Detection in .Net

vlad — Mon, 24 Dec 2007 10:18:48 +0200

http://www.codeproject.com/useritems/Memory_Leak_Detection.asp

Problems making a string property mandatory in Web Services

vlad — Mon, 24 Dec 2007 10:09:59 +0200

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