Workshop

for RuBoard

This workshop will help reinforce the concepts covered in today's lesson.

Quiz

1:	What is the significance of SqlClient formulating TDS packets?
A1:	The SqlClient provider creates TDS packets and hands them off to the Net-Library responsible for building network packets and sending them to the server. The significance of this is that SqlClient is directly using the application protocol that SQL Server listens for and so is much faster than first going through an OLE DB provider or ODBC driver. In fact, SqlClient is the fastest way to access SQL Server.
2:	What are some of the benefits of normalization?
A2:	A normalized database eliminates redundant data and therefore reduces the storage required. It also makes the data more maintainable because a single change needn't result in changing rows throughout the table. Normalized schemas also tend to be more flexible with regard to changes.
3:	Why would you use a stored procedure layer in your application design?
A3:	By requiring that all data access be performed through stored procedures, you can abstract the schema from the clients that use it, simplify the API for client developers, increase performance by taking advantage of compilation and reduced network traffic, and increase security by revoking permissions from the underlying tables and views.
4:	Why might you use SQLXML instead of SqlClient to access SQL Server?
A4:	Because SQLXML deals with how SQL Server data is exposed through XML, SQLXML might be a good candidate anytime you need to represent your SQL Server data in a particular schema. For example, if you're working with a trading partner and need to create XML documents from your SQL Server database that conform to an XSD schema they've given you, you can create an XML View with the proper annotations and use it to create the XML document for the partner. Further, you can then allow the partner to query for the documents directly by exposing an XML Template that uses the view through SOAP.

Exercise

Because you didn't work with any ADO.NET code today, there is no exercise.

for RuBoard