Tuesday, July 16, 2013

SQL Server : Generate Scripts for DB objects having text


Generate Scripts for DB objects having text. Implies objects which have text body, like procedures, TVF's
etc.

Monday, July 23, 2012

Wednesday, May 2, 2012

IE 9 support for HTML5 and CSS3

IE 9 support for HTML5 and CSS3.
Shared useful links for more info.
It does not feel very nice as it took more than what like 2 years for IE9 from IE 8.
And HTML 5 support is not to the mark as expected.


Tuesday, April 3, 2012

WCF Beginners : Starting with Web Services

This is first post in the series of post I will be writing for WCF.
You will find plenty of material on this subject, I feel writing about it, just to note down key points required to be known, at one place. I may have made some mistakes as I am no expert in this topic, would appreciate your feedback, so I can correct mistakes if any.

WCF..a part of the .NET Framework that provides a unified programming model for rapidly building service-oriented applications that communicate across the web and the enterprise

Thursday, February 2, 2012

SQL Server 2005 : Change templates for SP's, Functions, Tables Scripts etc




Following post tells how you can customize templates for SP's and Functions and other DB objects.
Following post written for SQL SERVER 2005, 32 bit Window7 Enterprise to be precise.

Tuesday, December 27, 2011

LINQ : Left Outer, Inner Join on DataTable


Apply Inner joins and Outer joins using LINQ on Datatables.
Using Extension method.
Handling null values in LINQ expn while applying joins.

Wednesday, November 23, 2011

IEnumerable Tricks 1 : DataTable and DataColumn


Tricks of TSQL type subqueries with IEnymerable extention methods OfType and Cast 
and using String function Join().
Simplify logic, to use sub queries in business layer's managed code your component
over Datatables  and datasets.