1.Difference between Database Mail and SQL Mail
S.No Database Mail SQL Mail 1Based on SMTP (Simple Mail Transfer Protocol).Based on MAPI (Messaging Application Programming Interface). 2Introduced in Sql Server 2005.Used prior versions of Sql Server 2005. 3No need to install Outlook.Require Outlook to be installed. 4More secure than Sql mail.Less secure than Database mail.
S.No Azure Table storage SQL Azure 1It is built on top of the Azure Storage platform.It is an SQL Server that has been configured to be hosted on top
of the Windows Azure in a high availability mode.
2It comprises flexible or schema-less entities. No referential integrity between the tables, and no custom indexes.It comprises standard SQL Tables with indexes and referential integrity. 3It can scale massive amounts of data due to the partition key.It may not scale as far as Azure Table storage. 4Can be thought as single spreadsheet.Look familiar to any .Net developer who has used Sql server 2008 prior.
S.No DBMS RDBMS 1Stands for DataBase Management SystemStands for Relational DataBase Management System 2In dbms no relationship conceptIt is used to establish the relationship concept between two database objects, i.e, tables 3It supports Single User onlyIt supports multiple users 4It treats Data as Files internallyIt treats data as Tables internally 5It supports 3 rules of E.F.CODD out off 12 rulesIt supports minimum 6 rules of E.F.CODD 6It requires low Software and Hardware Requirements.It requires High software and hardware requirements. 7DBMS is used for simpler business applicationsRDBMS is used for more complex applications. 8DBMS does not impose any constraints or security with regard to data manipulationRDBMS defines the integrity constraint for the purpose of holding ACID PROPERTY 9In DBMS Normalization process will not be presentIn RDBMS, normalization process will be present to check the database table consistency 10There is no enforcement to use foreign key concept compulsorily in DBMSAlthough the foreign key concept is supported by both DBMS and RDBMS but its only RDBMS that enforces the rules 11FoxPro, IMS are ExamplesSQL Server, Oracle are examples
S.No SQL Server 2000 SQL Server 2005 1Query Analyser and Enterprise manager are separate.Both are combined as SSMS(Sql Server management Studio). 2No XML datatype is used..XML datatype is introduced. 3We can create maximum of 65,535 databases.We can create 2(pow(20))-1 databases. 4Exception Handling mechanism is not availableException Handling mechanism is available 5There is no Varchar(Max) data type is not availableVarchar(Max) data type is introduced. 6DDL Triggers is not availableDDL Triggers is introduced 7DataBase Mirroring facility is not availableDataBase Mirroring facility is introduced 8RowNumber function for paging is not availableRowNumber function for paging is introduced 9Table fragmentation facility is not availableTable fragmentation facility is introduced 10Full Text Search facility is not availableFull Text Search facility is introduced 11Bulk Copy Update facility is not availableBulk Copy Update facility is introduced 12Data Encryption concept is not introduced 13Cannot compress the tables and indexes.Can Compress tables and indexes.(Introduced in 2005 SP2) 14No varchar(max) or varbinary(max) is available.Varchar(max) and varbinary(max) is used. 15Data Transformation Services(DTS) is used as ETL toolSQL Server Integration Services(SSIS) is started using from this SQL Server version and which is used as ETL tool