- Something old: Best practices for writing efficient
queries. Basically, understanding how indexes work, thinking in
set-based operations to avoid cursors and make use of joins, and
learning how to read execution plans and understand what they are
about. I won't be able to do this anywhere near as well as Bill
Graziano does in "What I Wish Developers Knew About SQL Server" but hopefully it'll be acceptable.
- Something new: Some of the new features in SQL Server 2005 which make some tasks easier. For instance, Common Table Expressions (CTEs), user-schema separation, etc.
- Something borrowed: A very brief intro to the CLR in SQL Server. I won't spend a lot of time on this one because this topic deserves its own presentations. However, the CLR isn't something DBAs should be afraid of as long as certain practices are followed. I'm basically going to parrot the Microsoft party line on this one as to what kind of assemblies to accept, how to manage them, etc..
- Something blue: I'll conclude on an excerpt from the BlueHat videos that was on Channel 9. It is a reminder of just how powerful relational database systems can be and how that works both for and against us. The excerpt is the one of the security PMs for WinFS (while it was still alive) discussing what he had seen.
IT Security, MySQL, Perl, SQL Server, and Windows technologies.
I'll be presenting at the DotNet Columbia SC User Group on August 8th. My presentation is tentatively titled, "Something old, something new, something borrowed, something blue," in honor of two friends of mine who have just recently married to each other. The concepts behind the title: