Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Tech Crumbs collected along the way ...
Power of LINQ!
I had some data in Access DB and wanted to convert it to XML. Data in Access was in one table called...
Date: 06/16/2009
Push or Pull Replication
A study conducted by MSCOM ops team found 1 GB of data took 110 Minute to push and 12.5 minutes to...
Date: 03/11/2009
Log Parser and SQL
I thought everyone who wants to know how to put the windows events or IIS Logs to SQL already know...
Date: 02/27/2009
How to partition Cube - using C#
There are many different ways you can partition a cube. Here I am talking about – how you can use C#...
Date: 02/10/2009
Life saver Queries.
These queries can save your life. Query to find the query using the most CPU: select...
Date: 01/16/2009
Column Dependencies
Often it happens, that we want to play with a column value of a table. Not knowing the ramification...
Date: 04/11/2007
Guidance Explorer web edition
One of the most useful tool from the Patterns and Practice. Patterns & practices Guidance...
Date: 01/14/2007
Performance Tips - SQL
We had an application which was not performing fast enough for our satisfaction. The application...
Date: 12/11/2006
E = COM+
Before I explain this equation, I should explain how I reached to it. I work for the company which...
Date: 12/10/2006
Replication - Enterprise SOA Anti pattern
Too much of the good thing – Replication. Nice article in ‘The Architecture Journal’, Whenever you...
Date: 08/01/2006
Scope_Identity() and OUTPUT
I seen couple of articles talking about OUTPUT Clause of SQL 2005, but no one is warning the side...
Date: 07/21/2006
connection string
So what is the OLE DB connection string for Excel or Exchange? Finally, all this on one page...
Date: 07/21/2006
Divide by Zero
What will be the out put of the following code: try{ double k = 19; double m = 0; k = k / m;...
Date: 07/20/2006
Code snippets - be smart, Type less.
Get some C# ready made code snippets from here. Learn about snippets here.
Date: 02/02/2006