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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

Get some C# ready made code snippets from here . Learn about snippets here .