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 ‘Words’, with the following columns: Word, Meaning, Synonyms, Antonyms, Example etc. I wanted to convert this data in XML as follows: <Dictionary>    <Word Spelling=”Munificent”>       <Meaning>very generous</Meaning>       <Synonyms />       <Antonyms />       <Example />   …


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 Pull across the continents. Furthermore SQL 2008 with Windows Server 2008 made a huge difference over SQL 2005 and Windows Server 2003.   Push subscription replication of character data with SQL Server 2008 running…


Log Parser and SQL

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 it is  …


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# to partition a cube from a DTS package? Using  Microsoft.AnalysisServices  Object API, you can travel the whole Hierarchy of objects  and completely administer an Analysis Service Instance. From the connection Object you can get…


Life saver Queries.

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. from      (select top 10          qs.plan_handle,          qs.total_worker_time     from          sys.dm_exec_query_stats qs     order by qs.total_worker_time desc) as highest_cpu_queries     cross apply sys.dm_exec_sql_text(plan_handle)…


Top 3 for every group

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 then you may…


Column Dependencies

 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 list of stored procedures depended on the table. Go…


Guidance Explorer web edition

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 guidance types including checklists and guidelines covering design, implementation and deployment topics.   Check the Guidance Explorer…


Performance Tips – SQL

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 the changes we made were very simple and well known, but as it happens often…


E = COM+

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 a way to keep up with these smart people….