Rafat Sarosh
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...
Author: rafats 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...
Author: rafats 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...
Author: rafats 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#...
Author: rafats Date: 02/10/2009
Life saver Queries.
These queries can save your life. Query to find the query using the most CPU: select...
Author: rafats 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...
Author: rafats Date: 04/11/2007
Guidance Explorer web edition
One of the most useful tool from the Patterns and Practice. Patterns & practices Guidance...
Author: rafats Date: 01/14/2007
Performance Tips - SQL
We had an application which was not performing fast enough for our satisfaction. The application...
Author: rafats 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...
Author: rafats Date: 12/10/2006
Replication - Enterprise SOA Anti pattern
Too much of the good thing – Replication. Nice article in ‘The Architecture Journal’, Whenever you...
Author: rafats 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...
Author: rafats Date: 07/21/2006
connection string
So what is the OLE DB connection string for Excel or Exchange? Finally, all this on one page...
Author: rafats 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;...
Author: rafats Date: 07/20/2006
Code snippets - be smart, Type less.
Get some C# ready made code snippets from here. Learn about snippets here.
Author: rafats Date: 02/02/2006