I ran across a website that gives you the formats for all of the various connection strings that you may need to make when hooking up a data source within VS. Every time that I have to type in one of these I have to look up the format for it, so this site should help consolidate all of my searching: ConnectionStrings.com

I recently came across a fairly detailed article on MSDN (article link) after a co-worker asked me a question regarding server resources when a query has been executed and you are using a DataReader to fetch one record at a time. The article goes into some of the standard SQL server architecture that I have known for quite some time, but it also points out some interesting details that may come in handy down the line. I am a bit busy right now, so I am marking this here so that I can come back and read the article in detail later.