SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Presenting at Columbia, SC DotNet User Group

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:
  • 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.
Technorati Tags: | | | | | |

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.


No comments.

Leave a Comment

Please register or log in to leave a comment.