Very useful utility functions in knockout

I found functions explained in following post are very useful for developing knockout applications, particularly array compare and flatten array.

http://www.knockmeout.net/2011/04/utility-functions-in-knockoutjs.html

Serialization in .Net

The OOB binaryserializer does not work in some cases for no apparant reason, while searching on net I came across this serializer library which could help solve many problems

https://github.com/mgravell/protobuf-net

List all constraints in database or table

The post below shows various methods to list all constrains in a SQL Server database or table, it is quite handy to know sysobjects table.

I normally use the query

SELECT OBJECT_NAME(object_id) AS ConstraintName,

SCHEMA_NAME(schema_id) AS SchemaName,

type_desc AS ConstraintType

FROM sys.objects

WHERE type_desc LIKE ‘%CONSTRAINT’ AND OBJECT_NAME(parent_object_id)=‘Employee’

https://bhaveshgpatel.wordpress.com/2009/11/04/sql-server-list-all-constraints-of-database-or-table/