Category Archives: Education

SQL University

Jorge Segarra is onto something pretty cool. Head on over to SQL University and check it out. I’m going to run through it myself in the coming weeks because everyone should be trying to polish up on the SQL.

SQL Server Tacklebox

I know I’m a little late posting this as I’m sure you’ve already downloaded the free Ebook and read through it, but if you haven’t be sure to go grab a copy. It’s got some good stuff in it.

24 hours of free SQL training

From the site: 24 Hours of PASS is a series of live one-hour webcasts broadcast over a 24-hour period that focus on a host of SQL Server topics. The 24 one-hour presentations will begin at 00:00 GMT (UTC) on September 2, 2009 Be sure to take into account the whole GMT issue. Since I’m on [...]

Comparison of database tools

Props to Brent Ozar for sending me this link for a comparison of Database tools. If nothing else it’s a good reference.

Visual SQL Joins

Came across a twitter post that made me remember how useful these things could be. For the visual learner it can go a long way in understanding how a join works. I’m linking to the one from the twitter post as well as. For the visual learner: http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx http://www.codinghorror.com/blog/archives/000976.html http://www.khankennels.com/blog/index.php/archives/2007/04/20/getting-joins/

Learn SQL on your bike

I’m really going to have to check into this one.  Aaron Alton has a neat idea that might help you retain all that SQL Syntax while you’re studying. All I have is a treadmill so that should be interesting.

SQL Server RSS Feeds

I came accross a blog entry by Jason Massie regarding SQL RSS feeds and I decided it would be a good time to check out the RSS Reader in Outlook 2007. Fortunately, Outlook will let you import a list of feeds from an xml or opml file. I took the list from Jason and plugged [...]

Ebooks, Twitter, and Contacts

I was checking out a new contact I made on Twitter, which I was convinced I should use by Brent Ozar, and Marlon’s post on a free eBook made me think back to some other great finds that I’ve seen on Red Gate. If someone thinks of any others please feel free to post. Best [...]