Scottish Area User Group Meeting looking at "SQL Server 2008 R2 :: the X factor for DBA's life" with Satya Shyam K Jayanty and "What's in your procedure cache?" with Rob Carrol
Scottish Area SQL Server User Group Meeting, Edinburgh - Thursday 3rd February
We will also have the usual food and prize draws!
18:00 - 18:30 - Introduction and Networking
18:30 - 19:30 – SQL Server 2008 R2 :: the X factor for DBA's life - Satya Shyam K Jayanty
By now you know about what's new in SQL Server 2008 R2, this session we will overview on highlights of how SQL Server 2008 R2 manageability features can help DBAs day-to-day life with an eX-tra factor.
Satya Shyam K Jayanty Knowledge is the power and you will gain by sharing it;
Solutions Architect and Consultant for database solutions with over 18+ years of experience in Software Engineering and Database applications using industry famous technologies & software, having awarded MVP since the year 2006. Active member, Contributing Editor & Moderator for MSDN and other popular SQL Server related forums, in addition to regular participation as a Speaker & Subject-Matter-Expert in the major events such as Microsoft Tech-Ed, SQLBits, SQLPASS and other European based conferences. Founder & Writer of www.sqlserver-qa.net [knowledge sharing network] and writer for sqlblogcasts.com/blogs/ssqanet/default.aspx site.
19:30 - 19:50 - Break and Food
19:50 - 20:50 – What's in your procedure cache? - Rob Carrol
Do you know what's in your procedure cache? This presentation will look at the procedure cache, what is in it, how it is used and what can effect it. It will show you how to use DMVs to determine the cache usage, how programming techniques effect how the cache is used, how plans in the cache can be re-used, and how query plan use can be optimized. It will also investigate the new "opimize for adhic workloads" option in SQL Server 2008.
Rob Carrol has been working with SQL Server since 1999, initially as a web developer, but primarily in a DBA and consultancy capacity. He joined Microsoft in 2008 as a SQL Server Premier Field Engineer, working with some of Microsoft's largest clients in the UK and Europe. Rob lives in South Ayrshire, Scotland and he's married with 2 daughters. When he's not working with SQL Server you'll usually find him playing his Xbox and hiding from his kids!
20:50 - 21:00 - Close
Microsoft Office at Waverley Gate
Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.