30/05/2008 12:17:12 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, users, etc. 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.
Rob Farley, a mentor/trainer with Solid Quality Learning Pty Ltd, 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 and is in Brisbane teaching fundamental and advanced T-SQL courses.
Venue: Microsoft Brisbane Office, Level 9, Waterfront Place, 1 Eagle Street |
Duration Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM) |
On: Thursday, 26 June 2008