Rob will 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
SA Innovation Centre, L2 Westpac House
Thursday, February 14, 2008