Page 11 - DCAP508_DATABASE_ADMINISTRATION

Unit 1: SQL Server RDBMS

Express Notes

SQL Server Express Edition is a scaled down, free edition of SQL Server, which includes the
core database engine. While there are no limitations on the number of databases or users
supported, it is limited to using one processor, 1 GB memory and 4 GB database files (10 GB
database files from SQL Server Express 2008 R2). The entire database is stored in a single .mdf
file, and thus making it suitable for XCOPY deployment. It is intended as a replacement for
MSDE. Two additional editions provide a superset of features not in the original Express
Edition. The first is SQL Server Express with Tools, which includes SQL Server Management
Studio Basic. SQL Server Express with Advanced Services adds full-text search capability and
reporting services.

Specialized Editions

Azure

SQL Azure offers many of the similar means of SQL Server distributed as a cloud service on the
Windows Azure Platform. Dissimilar to other editions of SQL Server, you do not require to
prerequisite hardware for, install or patch SQL Azure; Microsoft sustains the platform for you.
You have to set up a subscription, prerequisite your service, and begin using SQL Azure database.
You also do not require architecting a database installation for scalability, high accessibility or
disaster revival as these traits are offered mechanically by the service. Any application that
accesses SQL Azure must have Internet access so as to connect to the database.

Preferably, applications that utilize SQL Azure Database are constructed for and deployed to the
Windows Azure Platform. This offers the highest performance and dependability for database
connections since all of the communication among the application tier and the data tier occur
within Microsoft data centers and utilize private high speed networks. You can arrange SQL
Azure to sustain connections from applications running on-premise, but the eminence of the
connection will be restricted to the bandwidth and consistency of your internet connection.
Microsoft SQL Azure Database is the cloud-based version of Microsoft SQL Server, presented as
software as a service on Azure Services Platform.

Compact (SQL CE)

The compact edition is an embedded database engine. Unlike the other editions of SQL Server,
the SQL CE engine is based on SQL Mobile (initially designed for use with hand-held devices)
and does not share the same binaries. Due to its small size (1 MB DLL footprint), it has a
markedly reduced feature set compared to the other editions. For example, it supports a subset
of the standard data types, does not support stored procedures or Views or multiple-statement
batches (among other limitations). It is limited to 4 GB maximum database size and cannot be
run as a Windows service, Compact Edition must be hosted by the application using it. The 3.5
version includes supports ADO.NET Synchronization Services. SQL CE does not support ODBC
connectivity, unlike SQL Server proper.

Developer

SQL Server Developer Edition includes the same features as SQL Server Datacenter Edition, but
is limited by the license to be only used as a development and test system, and not as production
server. This edition is available to download by students free of charge as a part of Microsoft’s
DreamSpark program.

LOVELY PROFESSIONAL UNIVERSITY 5