Rafat Sarosh

Tech Crumbs collected along the way ...

Blog - About

About Rafat Sarosh

Some people think having a blog is like scratching your name on a bench of a bus stop. A meek ’me too’  concept, a lame attempt to be famous. However, today my life is made better by others blogs, my hours of arduous struggle is reduced to five minutes of search because of some generous person who took time to share his learning. 

This is my humble effort to give back. I will try my best to not add to the internet noise and post only entries which will help people save few minutes of their time.

This blog contains only technical posts,  they are result of my knowledge, I gleaned  from books, articles, blogs and learning’s from my day job, my day job presented me with opportunity to learn from some very bright people; This blog is build on  the shoulder of giants. Hence, I don’t consider this blog to be a product of my original thoughts, my original thoughts are here.

Contact me @ rsarosh@hotmail.com

  • Rafat Sarosh

    Power of LINQ!

    • 2 Comments
    I had some data in Access DB and wanted to convert it to XML. Data in Access was in one table called ‘Words’, with the following columns: Word, Meaning, Synonyms, Antonyms, Example etc. I wanted to convert this data in XML as follows: < Dictionary...
  • Rafat Sarosh

    Push or Pull Replication

    • 0 Comments
    A study conducted by MSCOM ops team found 1 GB of data took 110 Minute to push and 12.5 minutes to Pull across the continents. Furthermore SQL 2008 with Windows Server 2008 made a huge difference over SQL 2005 and Windows Server 2003. Push subscription...
  • Rafat Sarosh

    Log Parser and SQL

    • 0 Comments
    I thought everyone who wants to know how to put the windows events or IIS Logs to SQL already know about it. But for my amazement it is not the case. Quick search on the web did not turned up a short tutorial. So how to move my window events to SQL? Here...
  • Rafat Sarosh

    How to partition Cube - using C#

    • 0 Comments
    There are many different ways you can partition a cube. Here I am talking about – how you can use C# to partition a cube from a DTS package? Using Microsoft.AnalysisServices Object API, you can travel the whole Hierarchy of objects and completely administer...
  • Rafat Sarosh

    Life saver Queries.

    • 1 Comments
    These queries can save your life. Query to find the query using the most CPU: select highest_cpu_queries . plan_handle , highest_cpu_queries . total_worker_time , q . dbid , q . objectid , q . number , q . encrypted , q . [text...
  • Rafat Sarosh

    Top 3 for every group

    • 2 Comments
    I have a table, which keeps the country, Referer URL and their counts. I need to find out the top 2 URL’s for every country. So, you see this is not a straight top two order by problem. If you know the solution then it is very simple, if not...
  • Rafat Sarosh

    Column Dependencies

    • 5 Comments
    Often it happens, that we want to play with a column value of a table. Not knowing the ramification of the column value, we have to resort to the back breaking manual process of finding the dependency on the column. Using the management studio, get the...
  • Rafat Sarosh

    Guidance Explorer web edition

    • 1 Comments
    One of the most useful tool from the Patterns and Practice. Patterns & practices Guidance Explorer is a tool that enables discovery, composition and consumption of high quality development guidance. The guidance library contains a variety of...
  • Rafat Sarosh

    Performance Tips - SQL

    • 1 Comments
    We had an application which was not performing fast enough for our satisfaction. The application updates various tables with millions of records. We tweaked few things in our SQL and suddenly the speed of application improved to our target level. All...
  • Rafat Sarosh

    E = COM+

    • 1 Comments
    Before I explain this equation, I should explain how I reached to it. I work for the company which employ scary smart and insanely intelligent people. It is very hard to keep pace with them. However, as a man of average intelligence, I have to device...
  • Rafat Sarosh

    Replication - Enterprise SOA Anti pattern

    • 0 Comments
    Too much of the good thing – Replication. Nice article in ‘ The Architecture Journal ’, Whenever you see a replication happening in your enterprise, cast a doubtful eye on it, this can signal an Enterprise SOA Anti pattern . It is true to the dots, I...
  • Rafat Sarosh

    Scope_Identity() and OUTPUT

    • 2 Comments
    I seen couple of articles talking about OUTPUT Clause of SQL 2005, but no one is warning the side affect of it on the scope_Identity() function. Let me explain with an example: You have a Table T1, and would like to save the auditing data from T1 to...
  • Rafat Sarosh

    connection string

    • 0 Comments
    So what is the OLE DB connection string for Excel or Exchange? Finally, all this on one page http://www.connectionstrings.com/ .
  • Rafat Sarosh

    Divide by Zero

    • 4 Comments
    What will be the out put of the following code: try { double k = 19; double m = 0; k = k / m; Console .WriteLine( Convert .ToString(k)); Console .Read(); } catch ( Exception ex) { Console .WriteLine(ex.Message); } Different data type behave differently...
  • Rafat Sarosh

    Code snippets - be smart, Type less.

    • 1 Comments
    Get some C# ready made code snippets from here . Learn about snippets here .
Page 1 of 1 (15 items)