Database Reference
In-Depth Information
Name
Alias
Default Value
Allowed Values
Description
Integrated Security Trusted_Connection false
true
,
false
,
yes
,
no
,
sspi
Authentication mode
Network Library
Net
dbmssocn
Dbnmpntw
dbmsrpcn
dbmsadsn
dbmsgnet
dbmslpcn
dbmsspxn
dbmssocn
Network
.dll
Packet Size
8192
Multiple of 512 Network packet size in
bytes
Password PWD
None
Any string
Password if not using
Windows Authentication
Persist Security
Info
false
true
,
false
,
yes
,
no
Whether sensitive
information should be
passed back after
connecting
User ID
UID
None
User name if not using
Windows Authentication
Workstation ID
Local computer
name
Any string
Workstation connecting
to SQL Server
The Alias column in Table 12-2 gives alternate parameter names. For example, you can specify the
server using any of the following:
data source = .\<sql instance name>
server = .\ <sql instance name>
address = .\ <sql instance name>
addr = .\ <sql instance name>
network address = .\ <sql instance name>
Connection Pooling
One low-level detail that's worth noting—even though you shouldn't change it—is
connection pooling.
Recall that creating connections is expensive in terms of memory and time. With pooling, a closed
connection isn't immediately destroyed but is kept in memory in a pool of unused connections. If a new
connection request comes in that matches the properties of one of the unused connections in the pool,
the unused connection is used for the new database session.
Creating a totally new connection over the network can take seconds, whereas reusing a pooled
connection can happen in milliseconds; it's much faster to use pooled connections. The connection
string has parameters that can change the size of the connection pool or even turn off connection
