October 2011

OK, so by now you’ve seen that SQL103 is finished! It’s been great building out another class.  I’ll be presenting an hour session covering this same material at SQL Saturday #87, in Louisville, KY.  If you’d like to learn about Database Design in an interactive session, this is the one for you!  I’ll add this…

Read More Announcements

We’re nearing the end of the SQL103 series. We’ve designed tables, relationships, indexes and views. There’s plenty more to learn. Today we’re going to discuss designing stored procedures. When you start designing stored procedures you’re generally trying to build a wrapper around a collection of T-SQL statements that you can then hand off to developers.…

Read More SQL 103-Designing Stored Procedures