SharePoint: Content Query Webpart - OOB, Custom Fields, Custom Style with Table format

http://prafulgoyal.blogspot.com/2013/04/sharepoint-content-query-webpart-oob.html

Cassndra

http://www.edureka.in/blog/how-to-open-cqlsh-of-cassandra-installed-on-windows/

Setting the JAVA_HOME Variable in Windows

https://confluence.atlassian.com/display/DOC/Setting+the+JAVA_HOME+Variable+in+Windows

Use Client side javascript to diable ASP.Net validators

http://www.willasrari.com/blog/use-client-side-javascript-to-disable-aspnet-validators/000289.aspx

Get Date/Time from datetime datatype SQL SERVER

To get DatePart of DateTime type

SELECT CONVERT(DATE,GETDATE()) AS DateOnly

To get Time part in

SELECT CONVERT(TIME,GETDATE()) AS HourMinuteSeconds;
SELECT convert(varchar(8),GETDATE(), 108)

Code Collapse and Expand Feature in SQL Server Management Studio 2008

http://blogs.msdn.com/b/buckwoody/archive/2009/07/30/code-collapse-and-expand-feature-in-sql-server-management-studio-2008.aspx

Upload file via input control and empty File Collection in request

when we uplaod files via html input control, sometimes we get Empty file collection on server side, i faced this issue in one of my Sharepoint projects and resolved with adding

Page.Form.Enctype = "multipart/form-data";

in page load.

http://stackoverflow.com/questions/1226612/sharepoint-webpart-upload-file-whitout-using-runat-server