What’s new in SQL Server 2008 R2 and What’s in your procedure Cache

The SQL Server User Group will be running an upcoming event in Edinburgh on 3rd February discussing the new features in SQL Server 2008 R2 and finding out what is in your procedure cache.



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 “optimize for ad hoc 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.


More information and to sign up here: http://sqlserverfaq.com/events/260/Scottish-Area-User-Group-Meeting-looking-at-SQL-Server-2008-R2-the-X-factor-for-DBAs-life-with-Satya-Shyam-K-Jayanty-and-Whats-in-your-procedure-cache-with-Rob-Carrol.aspx

About Colin Angus Mackay
I blog at ColinMackay.scot. I help run Scottish Developers which is a user group for software developers in Scotland.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

You are commenting using your Twitter account. Log Out / Change )

You are commenting using your Facebook account. Log Out / Change )

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 35 other followers

%d bloggers like this: