posted on Wednesday, August 03, 2005 2:05 PM by amachanic

October 22: SQL Server Mini-Code Camp

Just announced on Thom Robbins' blog, I'm doing a SQL Server Mini-Code Camp on October 22 at the Microsoft offices in Waltham, MA. This will be a full day of content.

The morning session will focus on data fundamentals and set-based thinking. This will include a study of First Normal Form and some brief discussion of higher normal forms, a very basic intro to referential integrity, and an introduction to 3-valued logic and NULLs. I'll then proceed into set-based vs. procedural thinking, and show how to write better queries without using loops or cursors.

The afternoon session will be a deep dive into SQL Server 2005 CLR integration. I'll cover primarily how to program--and best practices for using--CLR UDTs, UDFs, aggregates, and stored procedures. I'll also briefly discuss triggers, but honestly I don't see much value in that feature so I'm going to spend very little time discussing them.

I'm very excited to be doing this! Let me know (soon, please) if you have any specific areas you'd like covered and I'll see if I can work it into the content.

You can register here.

Comments

# re: October 22: SQL Server Mini-Code Camp @ Wednesday, August 03, 2005 9:35 PM

Good luck with this. I would love to be there and help you out, but as the cookies have crumbled it's hard for me to get back to Boston.

Aaron Weiker

# re: October 22: SQL Server Mini-Code Camp @ Thursday, August 04, 2005 3:43 PM

Thanks, Aaron! Hopefully you can come next time :)

amachanic