74
Part I: Laying the Foundations
can use table-valued parameters to send multiple rows of data to a T-SQL statement or a
routine, such as a stored procedure or function, without creating a temporary table or
many parameters.There is a SNAC OLEDB provider, which gives much better performance in certain
circumstances; however, it is being deprecated from the SQL Server product in lieu of ODBC
providers instead. For more details on this shift, see the sidebar later in this chapter.If SNAC access is not needed or supported by your organization, disabling the appropriate
network protocols can reduce your security risks (surface area). You can enable and disable
these protocols from the SQL Server Confi guration Manager as shown in Figure 4-2.FIGURE 4-2
The SQL Server Confi guration Manager view for SQL Native Client Confi guration
Client Protocols.SQL Server Native Client Features ..........................................................................
The development community gains access to the new features of SQL Server 2012
through the SQL Server Native Client (SNAC). If the new features are not needed
and managed code is a requirement for data access, ADO.NET can suffi ce. Although a
detailed examination of the features is beyond the scope of this chapter, a summary of
each is provided.ADO.NET is an umbrella label applied to the .NET functionality that supports connections to a variety of data sources.
Classes within this library supply the programmatic capability to create, maintain, dispose of, and execute actions
against a database.c04.indd 74c04.indd 74 7/30/2012 4:12:44 PM7/30/2012 4:12:44 PM
http://www.it-ebooks.info