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: DATABASE |
SQL |
T-SQL |
