29/01/2008 10:32:06 PM
SQL Server 2008 introduces a variety of new language enhancements, designed to simplify coding tasks that can be annoyingly difficult with earlier / current versions of SQL Server. In this session, SQL Sever MVP Rob Farley introduces a number of these new language features including MERGE, Table Valued Parameters, Row Constructors & +=. Have you ever been frustrated by not being able to pass a table into a stored procedure? Or how about having to SELECT to determine whether rows exist prior to performing an INSERT? The new language features solve these problems and more. Rob will instruct us on their finer points!
Rob will also demonstrate SQL Server 2008's new "Resource Governor" feature which allows developers or DBAs to declaratively or interactively escalate or lower priority for specific processes, queries, user groups (not us silly!). Developers might consider escalating priority of critical transactions whilst lowering priority of reporting queries. DBAs might assign higher priority to certain groups of users or even to databases (control freaks!).
Rob Farley, a mentor/trainer with Solid Quality Learning, has been consulting in IT since completing a Computer Science degree with first class honours in 1997. He lives in Adelaide, where he heads up the Adelaide SQL Server User Group and sits on the South Australian Branch Executive Committee of the Australian Computer Society. He holds several Microsoft certifications including MCSD, MCDBA, MCTS, MCPD and MCITP. He is a Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server. He blogs at http://msmvps.com/blogs/robfarley
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:30 pm finish |
On: Tuesday, 19 February 2008