Busy start to my SQL Events 2013 Calendar

Here is a quick run down on the events I'm presenting @ over the coming 4 weeks

I've more events lined up for later this year and some just being confirmed and awaiting outcome of my session submissions to a number of events

Southampton 9th Jan (Today) I'll be delivering the following session, their website has the full event details http://sqlsoton.sqlpass.org/Events/Meetings.aspx

'Effective Index Partitioning & Compression Strategies'
We all know that ‘Indexing' is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the
Enterprise features: Partitioning & Compression, we can often see substantial gains. 

Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even
greater effect.

Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.

 

Maidenhead 17th Jan I'll be delivering the following session, further details on http://sqlserverfaq.com/default.aspx?EVTCTAG=Maidenhead

"Using Extended Events"

Extended Events in SQL Server is the new tool for event tracing inside SQL Server introduced in the 2008 release, replacing it predecessor ‘SQL Profiler', this session will focus
on the ‘HOW' to create effective Extended Event sessions, interpreting that information gathered to understand the events that are occurring inside SQL Server and aid in solving many DBA issues.

 

London 24th Jan I'll be delivering the following session, further details on http://sqlserverfaq.com/default.aspx?item=event&itemid=463

 "Using Extended Events"

Extended Events in SQL Server is the new tool for event tracing inside SQL Server introduced in the 2008 release, replacing it predecessor ‘SQL Profiler', this session will focus
on the ‘HOW' to create effective Extended Event sessions, interpreting that information gathered to understand the events that are occurring inside SQL Server and aid in solving many DBA issues.
 

SQLCruise Miami I'm very fortunate to also be one the Technical leader on the cruise, I'll be delivering a 2 hour Deep-Dive session into the depths of SQL Server Memory

SQL Server 2012 Memory Management

SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory allocators, which have now been merged into one allocator (Any page size). And that’s just the beginning of the changes for SQL Server memory. This session will dive into SQL Server 2012′s new memory architecture. We’ll see how to diagnose memory performance issues and gain insight into memory pressure issues. We’ll also cover the settings to adjust memory configuration levels and their impact.

This session is packed with Demo’s; in fact more than half this session is spent demonstrating so as to provide great opportunities to delve deep into memory clerks and SQLOS and use Resource governor and other techniques to ensure good memory utilization. Time is dedicated to discuss real-world experiences of consolidating multiple SQL Systems onto new equipment, how to configure servers with large amounts of RAM (512GB). The session concludes with discussions on LPIM, large pages and memory trace flags

For more details on this whole SQLCruise experience visit the website http://sqlcruise.com/2013-training/


Boulder SQL Usergroup 5th Feb - these UG events are regularly held oat our Confio Office in Boulder, complete with Beer keg's in the beautiful state of Colorado www.Bouldersql.org

SQL Server 2012 Memory Management

SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory managers, which have now been merged into one. And that’s just the beginning of the changes for SQL Server memory. This session will dive into SQL Server 2012′s new memory architecture. We’ll see how to diagnose memory performance issues and gain insight into memory pressure issues. We’ll also cover the settings to adjust memory configuration levels and their impact.

This session is packed with Demo’s; in fact more than half this session is spent demonstrating so as to provide great opportunities to delve deep into memory clerks and SQLOS and use Resource governor and other techniques to ensure good memory utilization. Time is dedicated to discuss real-world experiences of consolidating multiple SQL Systems onto new equipment, how to configure servers with large amounts of RAM (512GB). The session concludes with discussions on LPIM, large pages and memory trace flags

 

These 5 Events should get me nicely warmed up for the 2013 Year ahead - it will likely be a record year for me @ SQL Server events

I'll also be attending Oracle events as part of my role as a DBA for Confio Software  (likely 60+ events combined during this year)  

 

Published 09 January 2013 11:10 by NeilHambly

Comments

No Comments