Wednesday, June 27, 2012

DataSet Vs DataReader


Dataset Vs DataReader



DataReader

1. DataReader is like a forward only recordset.
2. It fetches one row at a time so very less network cost compare to DataSet(Fethces all the rows at a  time).
3. DataReader is readonly so we can't do any transaction on them.
4. DataReader will be the best choice where we need to show the data to the user which requires no transaction. 
5. As DataReader is forward only so we can't fetch data randomly. .NET Data Providers optimizes the  DataReader to handle huge amount of data.

DataSet


1. DataSet is an in memory representation of a collection of Database objects including tables of a          relational database schemas.
2. DataSet is always a bulky object that requires a lot of memory space compared to DataReader. We can say that the DataSet is a small database because it stores the schema and data in the application memory area.
3. DataSet fetches all data from the datasource at a time to its memory area.
4. We can traverse through the object to get the required data like querying database.


Thursday, June 21, 2012

Role-Based Security with Forms Authentication


Introduction


Forms Authentication in ASP.NET can be a powerful feature. With very little code and effort, you can have a simple authentication system that is platform-agnostic. If your needs are more complex, however, and require more efficient controls over assets, you need the flexibility of groups. Windows Authentication gives you this flexibility, but it is not compatible with anything but Internet Explorer since it uses NTLM, Microsoft's proprietary authentication system. Now you must choose how to manage your assets: provide multiple login pages / areas and force users to register for each, or assign groups to users and limit access to pages / areas to particular groups. Obviously, you must choose the latter.

JQuery


JQuery is a new kind of JavaScript Library.jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development. jQuery is designed to change the way that you write JavaScript.


jQuery is free, open source software, dual-licensed under the MIT License or the GNU General Public License. jQuery's syntax is designed to make it easier to navigate a document, select DOM elements, create animations, handle events, and develop Ajax applications. jQuery also provides capabilities for developers to create plug-ins on top of the JavaScript library. This enables developers to create abstractions for low-level interaction and animation, advanced effects and high-level, theme-able widgets. The modular approach to the jQuery library allows the creation of powerful dynamic web pages and web applications.

SQL SERVER - ColumnStore Index - Batch Mode vs Row Mode

Ratan Tata Retirement

When long-serving employees retire, companies present them with mementos or gold watches as a form of gratitude and in recognition of services rendered.

But what should a company do when its boss, or sort-of owner, is about to hang up his boots?

Tata Consultancy Services (TCS), India’s largest infotech company, is facing just such a question. It has probably answered it the wrong way.

It’s superboss, Ratan Tata, is about to walk off into the sunset in the next six months, and TCS has decided that Rs 5 crore is a fitting reward for his “long-standing contribution to the sustained growth and success” of the company, according to a report in Business Standard.

Is the company honouring or diminishing Ratan Tata, India’s tallest businessman by far, by putting a price of Rs 5 crore on his life-long efforts to put TCS on the global map? Getty Images

Is the company honouring or diminishing Ratan Tata, India’s tallest businessman by far, by putting a price of Rs 5 crore on his life-long efforts to put TCS on the global map? This, when the formal compensation Tata will receive in 2011-12 will exceed Rs 8 crore.

There’s no question Ratan Tata, who retires this December when he turns 75 as per group policy, has rendered invaluable services to every part of the Tata group and to business, in general, both in India and abroad. If Indian business has a reputation abroad, it owes much to Ratan Tata and his group.

TCS, as the crown jewel in the Tata group, has taken in the lead in recognising Tata’s contribution to its own growth and that of the group.

But there are several reasons to think it is not doing the right thing by trying to put a monetary value to Tata’s contribution – even though this may not be the intention behind the TCS gift.

First, listed companies should not be singling out individual directors for special compensation when there are already board and AGM resolutions that specify what Tata should be paid for his work.

Second, when an exception is supposed to be made to this rule, it is the minority shareholders who should vote on it – not all shareholders. As owner of the vast majority of TCS shares (nearly 74 percent), any such resolution is going to pass, especially since Tata Sons, the main holder of TCS shares, is also run by Ratan Tata. The TCS management is thus putting Tata in the embarrassing position of being the promoter who votes on his own retirement bonus.

Third, since it is fairly certain that almost all Tata companies will also be bidding farewell to their larger-than-life promoter, they could all fall into the TCS trap of saying it not with roses, but cash. The TCS example, if followed by other Tata group companies, will be no different from the political spectacles we see where leaders are weighed in gold or garlanded with cash for services rendered.

We think a Mayawati being received with a garland of Rs 1,000 notes is gross, but a Tata being gifted a Rs 5 crore cheque is somehow sane and sensible. The difference is only in the optics: one looks gross, and the other doesn’t because it happens out of public view.

The point is simple: if Ratan Tata’s services have been priceless and invaluable (which they demonstrably are), why try and show gratitude by trying to do precisely the opposite – by indicating a price and putting a monetary value on what is inestimable?

The Tata Group should not bring down Ratan Tata to the level of our crass political class. They should say it with roses.