I have posted the slides for the presentation I gave to the DotNet Columbia User Group.
The talk was called, "Something old, something new, something borrowed,
something blue." Everything for the presentation is there in the notes,
with the exception of the clip I showed from the BlueHat briefings (Something Blue).
As a result, I've also expanded the Truth Solutions site to include an
area for presentations. I'm hoping to do more of them as time goes on.
Presentations at TruthSolutions.com
For those who have used MySQL and are familiar with the world sample database, I have included in the SQL scripts a
build script which takes the world sample database and builds it for
SQL Server. The data in it is copyright Statistics Finland, http://www.stat.fi/worldinfigures. It's a good database which can show the power of an index, which I did in the presentation.
The breakdown of the talk was:
- Something old: How to get an execution plan using QA, SSMS,
and Profiler. The impact using an index can make on performance.
How to think using set-based operations, including with respect to
joins.
- Something new: CTEs for
recursion/hierarchical structures and EXECUTE AS to get around the
dynamic SQL issue in stored procedures under SQL Server 2000.
- Something borrowed: A very brief intro to the CLR in SQL
Server. Basically the Microsoft boilerplate.
- Something blue: 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 |
