To understand server roles we take a little example of a company. In a company owner of the company can have authority to go anywhere anytime. But accountant, operator and other employees have their limited area, means they are not allowed to go anywhere with the permission. Just like these sql server have seven servers role from which it can assign users. The following list display the highest leve of access granted.
Sysadmin: Members of these roles have authority to perform anything means any task in sql server. So the user whom allowed these roles has good knowledge because little unfair steps can create a big problem. This role is only for DBA (Database Administrators).
Serveradmin: We can say these are the assistant of DBAs members. These user has authority to handle server side configuration means how much memory can sql server holds and how much information send over the network in one single frame.
Setupadmin: these members have power to install replication and manage extended store procedure. This is also act as assistant DBA’s as well.
Security admin: these users manage security issue like create users delete users granting access to users, to create database. These are also for assistant DBA.
Process admin: Sql server is capable of doing multitask at one time. It can do more then one task at sever time. A member of this process admin can kill a job in sql servers. This is also known as assistant role of DBA or a developer. Killing of process can be in middle of the process is also possible.
Dbcreator: these types of users also known as assistant of DBA. The users can changes to the database. Just like some one creating faulty database.
Diskadmin: these types of user manage files. These contain mirroring database and adding backup devices.
These fixed servers role are add users at the time of creating them. This is done on the server roles tab in enterprise managers.
To know more about ADO Net Dataset visit dotnetquestion.info
Projects In Dot Net
Interoperabilitysupport (Interop)
Migrating to .NET from existing languages and platforms hasbeen made much easier; Especially if that environment is COM or Java. COM,Interop is built into the framework, and C# will be very familiar for thosedeveloping in Java currently. In fact, Microsoft has a migration utility toautomatically migrate existing Java source code into C#.
Common languageruntime (CLR)
This is the engine that is shared among all languagessupported in .NET, including C#, VB.NET, Managed C++, J#, and others to come.
With the help of the CLR, the developer can write base classes in VB.NET, childclasses in C#, and aggregate this tree from Managed C++ (this is just oneexample). You choose the language during implementation.
Base class library(BCL)
What makes Java so appealing besides the managed environmentand cross-platform support is its class library. The .NET framework takes theclass library concept a step further by supporting it across any language andextensible for future platform variances. Now BCL-supported features such asremoting, string manipulation, exception handling, and collection managementconstruct is the same from any language conforming to the CLI.
Common type system(CTS)
This addresses the supported data types within the frameworkand how they are represented in metadata format. Each supported .NET languageneed only support a subset of the total data type set. Typically, it will bethose types used most frequently (e.g., integer, short, long, string, char,boolean, object, interface, struct, etc.)
Simplified deployment
Say goodbye to DLL hell and the nightmare of Windowsregistration. Applications can now be deployed by a simple XCOPY of theassemblies, ASP.net files, and configuration files.
Full Web service andSOAP support
Complexities are optionally hidden for building Web serviceproviders and consumers in .NET. Details of the syntax and protocol surroundingXML Web services can be fully customized if needed, however. It is truly thebest of both worlds.
XML at the core
Serialization, streaming, parsing, transforming, and schemasupport are only some of the ?baked-in? XML features of the .NET runtime.
Object-orientedASP.NET
Use script for your clients, not your server-based code!Leverage your existing OO framework from ASP.NET and enjoy improved Webapplication performance due to compiled server code.
Both Adam Sturo & Jignesh are contributors for EditorialToday. The above articles have been edited for relevancy and timeliness. All write-ups, reviews, tips and guides published by EditorialToday.com and its partners or affiliates are for informational purposes only. They should not be used for any legal or any other type of advice. We do not endorse any author, contributor, writer or article posted by our team.
Adam Sturo has sinced written about articles on various topics from Family Travel, Architecture and Interview Questions. Know more about and learn more on. Adam Sturo's top article generates over 49500 views. to your Favourites.
Jignesh has sinced written about articles on various topics from Architecture, Investments and Software. Spec India is Custom Software Development Company that offers , Software Development Solutions,. Jignesh's top article generates over 880 views. to your Favourites.
After Hours Tuxedo Rental The staff at your choice of tuxedo rental store can help you choose an appropriate tie style