January 2013 - Posts

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)  

 

Posted by NeilHambly | with no comments
  • Compling a list of the upcoming SQL Server conference's just in the UK, it was Fun and there is PLENTY to tell everyone about

So in order here is the ones I'm privy to currently

  • SQLSaturday #194 - Exeter       8/9th March They firstly have some execllent Pre-con's and the Main event is the FREE Saturday on 8th May
  • SQLBits XI Nottingham              2-4th May    So after thier largest event in London in 2012, also the UK SQL Server 2012 technical launch, SQLBits the biggest UK/European SQL Conference is back
                • Please help choose the session's by voting for the amazing line-up submitted by a whole raft of speakers (UK & international ones), do this @ www.sqlbits.com
                • And for all the local usergroup attendee's, ask you group leader for their groups discount code for SQLBits XI  registration for the event opens soon (no retospective discounting
  • SQLSaturday #202 Edinburgh   7/8th June    With a pre-con by 2 of the SQLSkills team (see below some details on the courses SQLSkills are running in London throughout June 2013)
  • SQL Relay 2013  (8 Locations)  17-27th June - This is essential 8 individual 1-day events in 8 uk locations, each with thier own distinctive style and collobratng with local User groups
    • Glasgow            17th
    • Leeds                18th
    • Birmingham       19th
    • Norwich             20th
    • Cardiff                24th
    • Southampton     25th
    • Reading             26th
    • London              27th

Naturally they is a whole raft of local Usergroup events happening on a monhtly basis, best head over to www.sqlserverfaq.com for the latest and greatest details on those and to register for attending

More events will likely appear through the 1st half of 2013 and also for the 2nd half, so keep an eye out for annoucements

As I already mentioned SQLSkils are back in the UK (London) for the whole of June where they will once again run their Immersion courses, full details of these are on www.sqlskills.com but here is a quick run-down

http://www.sqlskills.com/immersioneventsschedule.asp

IE1: Immersion Event on Internals & Performance London, UK: June 3-7, 2013  Click HERE for registration details.

IE2: Immersion Event on Performance Tuning         London, UK: June 10-14, 2013 Click HERE for registration details.

IE3: Immersion Event on High Availability & Disaster Recovery London, UK: June 17-21, 2013 Click HERE for registration details.

IE4: Immersion Event on Security, PowerShell, & Dev Support   London, UK: June 24-28, 2013 Click HERE for registration details.

They also have Community evenings on each Tuesdays evening during the courses that allows public to come along and get some of the SQLSkills experience, I'll provide more details on those closer to the dates

In Europe I know of 2 other events happening in the 1st half of 2013

For those who were not aware I recently was appointed Technical lead For Confio Software in UK, So if you would like to know more about Ignite how it can tackle performance problems, drop me an email @ NeilHambly@Confio.com

http://www.confio.com/press/confio-expands-internationally-with-uk-office-and-new-executive-team/

Finally a quick Roundup of my upcoming Presentations (Jan/Feb)

  • 9th Jan   Southampton Usergroup http://sqlsoton.sqlpass.org/   my session tackles 'Compression and Partitioning' with demos on just how you can tie it all together and how it can improve performance
  • 17th Jan Maidenhead UserGroup http://sqlserverfaq.com/default.aspx?EVTCTAG=Maidenhead my session is the 'Using Extended Events' one, come along and find out a thing or 2 about extneded events
  • 24th Jan London Usergroup http://sqllondon.sqlpass.org/ This is the group I help run, my session is the 'Using Extended Events' one {again}, come along and find out a thing or 2 about extneded events
  • Then I'm flying out to Miami to go on cruise, but not any old cruise this is a SQLCruise www.sqlcruise.com
    • I'll be doing a 2 hour Deeeeeep Dive on Memory for the attendee's and hopefully imparting some other tidbits of info about SQL in our TL workshops and throughout the whole week
    • And some snorkeling a s well, will see how it comapred to the snorkeling I did in Alaska on my last SQLCruise
  • Bit more time in US visitng my US team, perhaps doing a presentation to a local UG whilst out there as well {fingers crossed}

Once back in UK mid Feb will be looking foward to the 1st SQL Conference being #194 SQLSaturday in Exeter

Posted by NeilHambly | with no comments

Going to make this simple and straight forward this year - Here are my 2013 goals (in addition to another bunch I have specifically for work)

SQL Conferences & Training Events

  • SQLCruise (Miami) - Jan 2013 - I'll be on the cruise ship and doing a 2-Hour Deeeeeep Dive on Memory, Want to learn more then visit www.sqlcruise.com
  • SQL Rally's - Hoping they are happening again and would love to be part of that event again
  • SQLPASS (Charlotte) - No more needs to be said about the 'Main event' of all the SQL Conferences
  • SQLBits XI - Will be there, hoping to present once again @ this awesome event & be a volunteer of course
  • Attend | Present @ 6+ SQL Saturdays (3+ non UK)
  • 6+ Virtual events {match my 2012 tally}
  • Deliver a 1-2 Full-Day training course

SQLFAQ Events

  • SQL London PASS Chapter - to help organize 10-12 events in London, with my co-leader Dave Ballantyne
  • SQLRelay 2013 - this is going to be excellent events, help on organizing these along with other UG leaders
  • SQLSanta II - Hopefully repeat the event we hosted in Dec 2012 once again in Dec 2013

Exams

Pass 6+ exams in 2013, including a non SQL Server one - perhaps one will be an Oracle exam

  • 70-463
  • 70-464 
  • 70-465
  • 70-448 
  • Exam 88 971: SQL Server 2008 Microsoft Certified Master: Lab Exam - looking to pass this on my 2nd attempt
  • Read 6+ SQL Technical Books
  • Pass the MCM SQL Server 2008 in 1st half 2013
  • Perhaps an Oracle or VMWare Exam

Work on compiling my "MCM Study Notes" (OneNote) for MCM Certification" and keep it going throughout the year (min 10 new pages per month added)

http://cid-c2dc5b5a2f112857.office.live.com/view.aspx/SQL%20MCM%20Training/SQL%20MCM%20Training

Writing

  • Work on a SQL Server book or chapters in 2013
  • Write and have plublished 3+ Articles on a major SQL Server site
  • Technical reviewer role – Would like to do a technical reviewer of a book

Community

  • Further the LinkedIn online resources, mine and the UK SQL Server FAQ group
  • Forum Activity (Regular activity) with a target 100+ questions answered
  • Twitter - Regular activity on various SQL Tags build following (target 2000 followers)
  • Blogs (min 25 technical in the year) + add a few non-technical as well
Posted by NeilHambly | with no comments

Before I post my goals for 2013 - Seperate posting I'll be doing on the 2nd {it is a tradition now It appears}

I'm first going to do a speedy review of my Success/Failures on my goals for 2012, Below is the list I had posted 2nd Jan 2012 for my 2012 goals - suspect I was too hungover for doing that on the 1st :-)

So simplicity I will colour them Green (Completed) and Red (failed or not attempted) and I'm going to be strict - Looking for 75% or more of these completed - Let's see how I fare'd

This also does not include any other *Stuff* I acheieved, even if it was instead of a goal here

SQL Conferences & Training Events

  • SQL Master Week # 2 (May 2012) Master Immersion Event on Performance
  • SQLPass Summit (will attend my 2nd Summit - Hopefully once again as a speaker) Yes I was a speaker once again @ the Summit
  • SQLRally (Dallas) 2012 Yes, thankfully was able to make this one and was a speaker @ the event {one of the highest rated ones :-) }
  • SQLRally Europe (if any event is planned) Yes , it was SQL Rally Nordic and I was a speaker @ the event
  • SQLSaturday #105 (Dublin) I will be Presenting @ this event Attended and alsop presented @ this event
  • SQLSaturday hopefully another 1-2 events (Chicago + ????) Presented @ 2 more SQLSaturdays
  • SQL BITS X / XI Events – hoping I will be able to present & attend @ these events Was @ SQLBits X (great event) also a presenter, they only held 1 event this year
  • SQLDay 2012 My 1st Event in Poland (Straight after SQLBits X) Was able to attend this event and presented as well
  • Present a 2-day Training Course (London)  Worked on this and got as far as scheduling some dates, but due to massive change in employment circumstances I moved this one in 2013 Goal

SQLFAQ Events

  • SQL FAQ London (8-10 Events) organize those & also present @ a few of those Acheieved
  • Further presentations @ 4-6 non-London locations, including perhaps a full day event Managed to do 4 Non-London events, sadly not including a Full-day one

Exams

Study & Pass the following 3 remaining Pre-Requisite Exams  Done

  • 70-450 & 70-433 & 70-451 - Planned for Feb/March Done
  • Exam 88 970: SQL Server 2008 Microsoft Certified Master: Knowledge Exam Passed on 1st attempt
  • Exam 88 971: SQL Server 2008 Microsoft Certified Master: Lab Exam Failed on 1st attempt
  • Read 3+ SQL Technical Books Read 4-5 {most of them SQL 2008}
  • Pass the MCM SQL Server 2008 in 1st half 2012 Failing lab exam

Work on compiling my "MCM Study Notes" (OneNote) for MCM Certification" and keep it going throughout the year Sad to say I let this one slip by.. So in 2013 I will get serious about adding a hellva lot more content

http://cid-c2dc5b5a2f112857.office.live.com/view.aspx/SQL%20MCM%20Training/SQL%20MCM%20Training

Writing

  • Complete my chapter as co-author for my SQL Server 2012 book
  • Write and hopefully get published another 2 Articles or contribute to another book
  • Technical reviewer role – hopefully also have a chance to become a technical reviewer

Community

  • LinkedIn online resources, both mine and the UK SQL Server FAQ group Worked on LinkedIN resources some throughout the year
  • Forum Activity (Regular activity) with a target 100+ questions answered Nothing in this category - BIG item to focus on for 2013
  • Twitter - Regular activity on various Tags build following (target 1000 followers) Got to 1000 followers {just} and didn't tout for any
  • Blogs (min 25 technical in the year) + add a few non-technical as well Have to admit I focused on alot of other stuff and bloging was sparse @ best

Based on the following results, I'm giving a massive thumbs up with a 85% success rating on my Goals... Feel free to disagree with my own review if you feel so inclinded :-)

 

Posted by NeilHambly | with no comments
Filed under: