79
Chapter 4: Client Connectivity
4
gigabytes (GB). This feature allows SQL Server-based applications to store and manipulate
unstructured data, such as images and documents, on the fi le system.Handling Expired Passwords
This feature of SQL Server 2012 enables users to change their expired password at the client
without the intervention of an administrator.A user’s password may be changed in any of the following ways:■ Programmatically changing the password such that both the old and new passwords
are provided in the connection string
■ A prompt via the user interface to change the password prior to expiration■ (^) A prompt via the user interface to change the password after expiration
Best Practice
If the old and new passwords are supplied on the connection string, then ensure that this information has
not been persisted in some external fi le. Instead, build it dynamically to mitigate any security concerns.
Snapshot Isolation
The snapshot isolation feature enhances concurrency and improves performance by avoid-
ing reader-writer blocking.
Snapshot isolation relies on the row versioning feature. A transaction begins when the
BeginTransaction call is made but is not assigned a sequence transaction number until the
fi rst T-SQL statement is executed. The temporary logical copies used to support row version-
ing are stored in tempdb.
If tempdb does not have enough space for the version store, then various features and operations, such as triggers,
MARS, indexing, client executed T-SQL, and row versioning will fail, so ensure that tempdb has more than enough
space for anticipated uses.
Summary
SQL Server Confi guration Manager provides the server and SQL Native Client protocol
management.c04.indd 79c04.indd 79 7/30/2012 4:12:46 PM7/30/2012 4:12:46 PM
http://www.it-ebooks.info