with 4 tracks to choose from it was difficult deciding on my personal agenda for the day. In the event i went for:
9:30 Transactions and Exception Handling – Eric Allsopp
Using T-SQL transactions to manage the behaviour of queries is always a balance between data integrity and client concurrency. In order to build high performance, well behaving data logic layers it is important that we understand this topic. In this session we will look at isolation levels (including the row versioning levels), locking and deadlocking. We’ll also look at the exception handling capabilities in 2005 and how they can be used to manage transactions in stored procedures.
10:50 Identifying Performance Problems with SQL 2005 Profiler – Martin Bell
How to use Perfmon, Visual Studio Team Edition, SQL Profiler, DTA, Analysing Trace Output and ClearTrace to identify poor performance areas in your system.
Well there was a time when you could almost rescue a project single handedly by introducing the other members of the team to Perfmon and SQL profiler. Nowadays most developers are clued up about these tools but it was interesting to hear about some of the other options in this area.
12:10 77 SQL Server Myths – Simon Sabin
Recently the SQL MVPs put together their list of myths about SQL Server. If you think you know everything about SQL then come along and see if you’re right.
An interesting talk although when every myth was introduced it was immediately obvious that it was indeed a myth (by virtue of its inclusion!) never the less an interesting discussion followed – check out the presentation at www.sqlbits.com!
14:30 Daves Top 10 SQL Keywords – Dave McMahon
‘Top of the Pops’ might be dead, but Dave will give you his own countdown of his 10 most useful/favorite SQL keywords. No secrets to giveaway here, suffice to say that you will know some of them (but maybe not used this way) and some may be unfamiliar to you. The whole ‘Countdown’ will be demoed and Dave will explain why they make his top 10. This is a session for people who use SQL regularly as Developers, know the standard DML but maybe never had the chance to peek around the corner to see what else was there! Both SQL 2000 and SQL 2005 syntax will feature, so this is stuff you can take away and use today …
Dave gave a memorable performance donning wig and cassette player in hand to give us an old fasioned TOTP run down of his top 10 keywords. check out the presentation at www.sqlbits.com to find out what was no 1!
Unit Testing in SQL Server – Richard Fennel
Test driven development is one of the current hot topics in software development, but how far can these principles be applied in the world of SQL? In this session I will look at the principles of TDD and other testing options using both freeware tools and Microsoft’s Visual Studio Datadude.
Richard is clearly a bit of a testing geek (nothing wrong with that) and was able to effortlessly impart some pearls of wisdom relating to the less well nkown business of unit tresting in SQL Server. Nice intro to NSQL (nunit clone for T-SQL) and the Visual Studio edition aimed at DBAs ("Data Dude")