A blog by Jose Barreto, a member of the File Server team at Microsoft.
All messages posted to this blog are provided "AS IS" with no warranties, and confer no rights.
Information on unreleased products are subject to change without notice.
Dates related to unreleased products are estimates and are subject to change without notice.
The content of this site are personal opinions and might not represent the Microsoft Corporation view.
The information contained in this blog represents my view on the issues discussed as of the date of publication.
You should not consider older, out-of-date posts to reflect my current thoughts and opinions.
© Copyright 2004-2012 by Jose Barreto. All rights reserved.
Follow @josebarreto on Twitter for updates on new blog posts.
Here are some notes on "SQL Server 2008 Client Design" I took while attending an advanced class on SQL Server taught by Adam Machanic (http://sqlblog.com/blogs/adam_machanic/default.aspx).
Please note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation :-). Always check your facts on Books Online (I try to provide links when applicable). As with anything else you get from a blog, never use any of this in production before you thoroughly validate it a test environment. Please keep in mind that some of those will be hard to follow without the right pre-requisite knowledge and the right context. Reading the post from top to bottom will help.
Talking about code
Finding a balance
Service Orientated Architecture (SOA)
Mapping Stored Procedures to SOA
Closing the SQLDataReader
DataReader is better than DataTable
DataTable is better than DataReader
ADO.NET is slower SSMS
Parameterization vs. Concatenation
Query Notification Issues
SQLBulkCopy - How
SQLBulkCopy - Details
TVP – How
The Object-Relational Issue
PingBack from http://technology.linkablez.info/2009/03/23/sql-server-2008-client-design/
Thank you for submitting this cool story - Trackback from DotNetShoutout
I took some advanced SQL Server 2008 classes recently and shared my notes in a series of blog posts.