Monthly Archives: November 2008

Ananth Ramasamy Meenachi – My Profile

  TODO:

Posted in General | Leave a comment

SQL SERVER – 2005: List of all Tables of Database

Ananth Ramasamy Meenachi – http://www.msarm.com To get all the tables in the database, we can just query with system table (sys.Tables) USE DBName GO SELECT * FROM sys.Tables GO Returns all the tables in the database which user have created.

Posted in SQL Server 2005/2008 | Leave a comment

SQL SERVER – 2005: List of all the Databases *

Ananth Ramasamy Meenachi – http://www.msarm.com To get all the databases on a server instance, you can use the simplest query as below. USE Master GO SELECT * FROM sys.Databases GO sp_helpdb * for the current instance and for which you … Continue reading

Posted in SQL Server 2005/2008 | Leave a comment

The Microsoft Health Common User Interface (CUI)

Ananth Ramasamy Meenachi – http://www.msarm.com The Microsoft Health Common User Interface (CUI) provides Design Guidance and Toolkit controls which allow a new generation of safer, more usable and compelling health applications to be quickly and easily created. It is aimed … Continue reading

Posted in Life Sciences | Leave a comment

Get all zero columns in a data table:

Ananth Ramasamy Meenachi – http://www.msarm.com I got an interesting requirement and all that I need to do show is only all non-zero columns in a report. For the below data: Expected result: Solution: Need to find all zero columns list. … Continue reading

Posted in ASP.Net 2.0 | Leave a comment

My first blog in www.msarm.com ! – Ananth Ramasamy Meenachi

  Yes, I thought of expanding my era through blogging to a wider community by sharing knowledge, information and my experience. In this blog I would be sharing my technical experience related to Asp.net, Ajax, SQL Server, Linq, Silverlight, CSS, … Continue reading

Posted in General | Leave a comment