Default Database roles and there permissions in MS SQL

Default Database roles and there permissions in MS SQL   Database roles: Each database has a set of fixed database roles, to which database users can be added. These fixed database roles are unique within the database. While the permissions of fixed database roles cannot be altered, new database roles can be created. Here are the fixed database roles and their associated permissions in SQL Server: Fixed...

Transport level security VS message level security in WCF

Transport level security VS message level security in WCF   Advantages of Transport level security Does not need any extra coding as protocol inherent security is used. Performance is better as we can use hardware accelerators to enhance performance. There is lot of interoperability support and communicating clients do not need to understand WS security as it’s built in the protocol itself. Disadvantages...

Features of Apple – iPad

Features of Apple iPad – New tablet from Apple.   Video The large, high-resolution screen makes iPad perfect for watching any kind of video: from HD movies and TV shows, to podcasts and music videos. You can also easily move between wide-screen and full-screen with a double-tap. And because it’s essentially one big screen, with no buttons or anything to distract you, the picture fills your...

First Videos of Apple iPad

First Videos of Apple iPad – New tablet from Apple Can the new Apple Tablet live up to the hype? Here are some video’s of apple’s new tablet, iPad. By these feature videos you can decide whether to buy Apple iPad or not.

WCF Security modes provided in .NET

WCF Security modes provided in .NET Across all service bindings there are five possible security modes: None. Turns security off. Transport. Uses transport security for mutual authentication and message protection. Message. Uses message security for mutual authentication and message protection. Both. Allows you to supply settings for transport and message-level security (only MSMQ supports this). TransportWithMessageCredential....

Default types of WCF bindings in .NET

Default types of WCF bindings in .NET   Within the Windows Communication Foundation programming model, bindings are represented by the System.ServiceModel.Channels.Binding class. All binding classes must derive from this base class. Following are the different bindings provided by WCF by default: 1. BasicHttpBinding 2. WSHttpBinding 3. WSDualHttpBinding 4. WSFederationHttpBinding 5. NetTcpBinding...

Apple’s tablet iPad launch

Apple Tablet launch, iPad launch, iSlate launch The most awaited Apple Tablet-iPad going to launch today. There are lots of new features which will be showcase in Apple Tablet launch. Hope Apple iPad will be the next successful product of Apple Be connected to see more news on it.

Query Optimization in SQLite

Query Optimization in SQLite   This document provides a terse overview of how the query optimizer for SQLite works. This is not a tutorial. The reader is likely to need some prior knowledge of how database engines operate in order to fully understand this text. 1.0 WHERE clause analysis The WHERE clause on a query is broken up into "terms" where each term is separated from the others...

Default MS SQL Server roles and their permissions

Default MS SQL Server roles and their permissions   These are default role available in MS sql sever. Logins can be added to these roles to gain the associated administrative permissions of the role. Fixed server roles cannot be altered and new server roles cannot be created. Here are the fixed server roles and their associated permissions in SQL Server: Fixed server role Description sysadmin Can...

SQLite Database Architecture

SQLite Database Architecture   Block Diagram Of SQLite   This document describes the architecture of the SQLite library. The information here is useful to those who want to understand or modify the inner workings of SQLite. A block diagram showing the main components of SQLite and how they interrelate is shown at the right. The text that follows will provide a quick overview of each of...

Hyper-V | Windows Server Virtualization

Windows Server Virtualization (WSV) being included with the release of Windows Server 2008 RC0, which was previously codenamed “Viridian”. Windows Server 2008 Hyper-V, the next-generation hypervisor-based server virtualization technology, allows you to make the best use of your server hardware investments by consolidating multiple server roles as separate virtual machines (VMs) running on a single...

Enable SQL encryption in ASP.NET

Database Encryption is ASP.NET   If you are using the ADO.NET SQL Server managed data provider and a SqlConnection object to connect to SQL Server, then you can enable encryption by adding the encrypt=true parameter to the connection string as shown here. <configuration>    <connectionStrings>       <add name="MyDbConn"       ...

How to restrict user to access database in MS SQL

RESTRICTED_USER in MS SQL RESTRICTED_USER allows for only members of the db_owner fixed database role and dbcreator and sysadmin fixed server roles to connect to the database, but does not limit their number. All connections to the database are disconnected in the timeframe specified by the termination clause of the ALTER DATABASE statement. After the database has transitioned to the RESTRICTED_USER...

Client Credential Type in WCF

Different Client Credential Type provided in WCF – Windows communication foundation   The choice of client credential type depends on the security mode in place. For transport security you can require a Windows credential or certificate-and there are variations on how Windows credentials are passed via TCP, HTTP and MSMQ. Message security supports any of the following settings for clientCredentialType: None...

Features of Curl programming – RIA development

Features of Curl programming – RIA development   The Curl Rich Internet Application Platform is the most powerful environment for rapidly developing complex, industrial-strength Web applications. Using Curl, organizations can create a new class of Web-based applications that provide all of the rich interactivity, functionality and performance of client-server applications. Unlike tools such...

SQLite Component in V3

Different component in SQLite Version 3   Following are the some sqlite v3 components Objects:     * sqlite3     * sqlite3_int64     * sqlite3_uint64     * sqlite_int64     * sqlite_uint64     * sqlite3_file     * sqlite3_io_methods     * sqlite3_mutex...

Scrum : Agile Software development Methodology

What is Scrum : Agile Software development Methodology   Software development is a complex process. Some complexities of software development include – managing rapidly changing requirements and unrealistic estimates of time, cost, and product quality. To overcome these complexities, Scrum comes into process. Scrum is a most perplexing and paradoxical process for managing complex projects....

What is Microsoft DreamSpark?

What is Microsoft DreamSpark? Microsoft DreamSpark enables students to download Microsoft developer and design tools at no charge. Free Microsoft Office 2007 Free Microsoft Office 2007 Full Version Free Microsoft Visual Sudio 2008 Free Microsoft Visual Sudio 2008 Proffesional edition Free Microsoft Visual Sudio 2008 Express edition Free Microsoft SQL Server 2008 Now, for the first time, Microsoft...

Modules in IIS 7 and their functionality

IIS 7.0 modules and their functionality   Following are the modules which are available in IIS 7 by default.   Module name Description HTTP modules   CustomErrorModule Sends default and configured HTTP error messages when an error status code is set on a response HttpRedirectionModule Supports configurable redirection for HTTP requests OptionsVerbModule...

What Is Message level Security in WCF?

What Is Message level Security in WCF?   Message security uses the WS-Security specification to secure messages. The specification describes enhancements to SOAP messaging to ensure confidentiality, integrity, and authentication at the SOAP message level (instead of the transport level). In brief, message security differs from transport security by encapsulating the security credentials and claims...