Hello

Today we received the PASS Connector emails, with the announcements of the 7 Candidates running in this BoD election, as you can see there are a total of 7 of us who made it through to the final stages

Announcing the PASS Board of Directors Candidates


The PASS Board of Directors has ratified the official slate for the upcoming Board elections, which begin this week. Three seats are up for election for the 2014-2015 term, including two regional seats: one representing EMEA and one representing the US/Canada; the third seat is an open seat with no regional restrictions.

Here are the candidates, listed in the order of their Nomination Committee ranking, and the seats for which they are eligible:

Allen Kinsel

US/Canada and Open

Tim Ford

US/Canada and Open

Amy Lewis

US/Canada and Open

Richard Douglas

EMEA and Open

Neil Hambly

EMEA and Open

Jen Stirrup

EMEA and Open

Ami Levin

US/Canada and Open

Voting will open end of day Pacific Time Sept. 25 and close at noon Pacific Time Sept. 30. Ballots will be sent to all PASS members in good standing as of June 13, 2013.

Before you cast your ballot, please review the process for awarding seats.

 

I'm sure you will have read a few if not all of the other blogs form the other candidates for their election campaigns and mine is no different in this regard

I want to elaborate on my particular brand of skills, experience and ideas I could bring to the PASS organization as board member, but surely first I would want to tell you how well 'suited' I would be for this role and how wonderful I would be as serving as a PASS BoD, though in total honestly I haven't held a board position before, I can really only speculate to you how my performance would be if I was given this important opportunity, with that said I would bring with me a ton of commitment for my time, energies and skills as well as multiple years of experience in the SQL Community
I would take the responsibility very seriously and do my utmost in any scenario I was given

Also for me and I'm sure for you, we'd like to know that who ever was elected they possessed @ least some of the traits that would make them a valuable and productive BoD member

Here are some of these traits I would look if I was looking to select someone who could be suitable for serving on the BoD

  • Can they review the facts presented, listening to all opinions and still can make the 'right decisions' when the time comes
  • Do they have 'Clear Vision' and belief in their own ideas, but can still make changes to these when it's needed to make them successful
  • Can the LISTEN and absorb and evaluate ideas and feedback from the members, and construct a plan to incorporate these elements as best can be provided
  • Be able to take ownership of the success or failure of teams work
  • Able to provide clear communication of ideas and projects in a coherent & concise manner to others, providing clarity of objectives and success criteria
  • Delegation of tasks, project management to deadlines and within assigned budgets when needed
  • Reporting of progress to PASS teams, tackling any issues that arise with calmness and appropriate allocation of resources when needed
  • Strong passion for growth of PASS and encouraging members engagement in PASS events
  • Be a respected member within the community, driven from long term on-going commitments to SQL Community
  • Experience of taking ownership of projects and teams to successful completion

I'm sure I could write a lot more of these traits, the question I would like to ask the members who are voting is what are the KEY issue or areas they wish to see addressed
Based on the information provided by the candidates, who could best provide those qualities for you and vote accordingly

The goals I would like to see are as follows 

Membership Engagement: I believe we can improve considerably within this area by focusing on the grassroots levels and developing our leadership programs to identify and encourage new leaders. We can also better promote existing events and increase the number of local and regional events to create a variety of in-person and virtual events to supplement and complement other PASS events (Summit, SQLRally, and SQLSaturday) and reach more database professionals throughout the world.

 

Languages: We have many existing and potential members whose primary language is not English. We need to hold events and have other resources available in local languages to fully engage these members. While this is already starting to happen, I would like to see these efforts enhanced. If we want to engage a more diverse cultural membership, we need to do it on their terms. This can include promoting multilingual communications about PASS events (in English and local languages), increasing the number of language-specific Virtual Chapters, and creating a more language-oriented PASS website.

 

New Presenters program: Becoming a PASS presenter can be a very rewarding experience. However, it can be challenging for new speakers, in the early days, to find opportunities to develop their presenting skills. I would like to see a program specially devised to help nurture these new presenters, help them find more opportunities to present, and ultimately help them become our future experienced presenters.

LinkedIn profile

Neil's BoD application.

Thanks

Neil Hambly

 


 

 

Posted by NeilHambly | with no comments

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:

Like a lot of us, I had set myself some goals @ the start of the year, and I did not make them all that easy

I had set myself the goal to become Microsoft certified in SQL Server 2008 & 2012 {the details on what exactly where the 2012 certifications where not clear when the goal was initially set}

I duly spent the best part of the 1st half of the year, in studies for and taking the 4 exams to become an MCITP 2008 SQL Server for both Database Administrator & Developer

  • Exam 70-432 This was already in the bag from last year (Sept 24th 2011)
  • Exam 70-450 Taken and passed on June 9th

So @ this point I had achieved the 1st of my MCITP certifications SQL Server 2008 Database Administrator

  • Exam 70-433 Taken and passed on June 29th
  • Exam 70-451 Taken and passed on July 22nd

So now I had achieved the 2nd of my MCITP certifications SQL Server 2008 Database Developer

 

Also I had the opportunity to take a SQL 2012 Beta exam when they became available, due to my schedule I was only able to take just one of these - so I choose the new Query based one

  • Exam 70-461 After waiting for the beta results, I found I had indeed passed it April 12th
  • Exam 70-462 Taken and passed this on Aug 26th
  • Exam 70-463 not as yet scheduled, I will be likely attempt that in next few weeks

When I do pass the 70-463 I will have the achieved the newly minted SQL Server 2012 MCSA certification as detailed in http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

  • MCSA: SQL Server 2012

Once{When} I do pass and have the MSCA cert, I can progress onto the next level which is the MCSE: Data Platform this requires 2 more exams

  • Exam 70-464 Developing Microsoft SQL Server 2012 Databases
  • Exam 70-465 Designing Database Solutions for SQL Server 2012

I will also probably look @ taking another exam, So I can get the MCSA in 2008 as well

  • Exam 70-448 Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

As this would then earn me the following certification MCSA: SQL Server 2008

 

This is all good progress, however the main certification goal I had set myself was this advanced certification one Microsoft Certified Master (MCM) in SQL Server 2008

http://www.microsoft.com/learning/en/us/certification/master-sql-path.aspx

To achieve this difficult goal, I first needed to gain those 2 pre-requisite MCITP Certifications SQL Server 2008 Database Administrator & SQL Server 2008 Database Developer {these was duly achieved on July 22nd}

So now I had both of the pre-requisites, I could attempt the 2 exams for the MCM SQL 2008 certification

  • Exam 88-970 SQL Server 2008 Microsoft Certified Master: Knowledge Exam, Taken and passed on Aug 13th
  • Exam 99-971 SQL Server 2008 Microsoft Certified Master: Lab Exam, Currently awaiting a date in Sept or Oct when I can attempt this one

I'm in final study mode now for the Lab, I think that there are somewhere around 100-120 people certified @ this advanced level {about 40-50% of those working @ Microsoft}

 

So even as my goals are nearing completion, I do think I will likely achieve them before the year ends,  my learning will continue into next year and well beyond

So with 3 or 4 more 90-xxx exams and a 88-971 Lab to complete - I've no time yet to relax

Right it is time I got back to my studies, perhaps I will see you @ one of the conferences I'll be presenting @ in the remainder of 2012

  • SQL Saturday #162 - Cambridge, UK
  • SQL Rally Nordic - Copenhagen, Denmark
  • SQL PASS Summit - Seattle, US

 

Posted by NeilHambly | with no comments
Filed under:

At times I often want to know what is happening inside my SQL Servers, there are of course a multitude of ways I could "peek" into the activity that has been happening,

Sometimes I just need to get a quick summary of those facts, maybe just to know if anything unusal has happened I'm not yet aware of, an easy way I can do that is to query the DMV sys.dm_os_performance_counters,

As there are tons of blog posts already out there on using the data from this DMV, I'm not going to focus on that but I wanted to share a simple approach I sometime use with this and some other DMVs and that is to PIVOT the data for "Easy Viewing"

I do like to sometimes to retrun my results in the "Pivoted" fashion for easy viewer and the results from this DMV often lend themselves well to this approach -  What I'm I talking about, well let me show you a few examples to illustrate the point

NEW in SQL Server 2012 are the counters for ”Batch Resp Statistics”

SELECT [counter_name],"CPU Time:Total(ms)","CPU Time:Requests","Elapsed Time:Total(ms)","Elapsed Time:Requests"

FROM (SELECT [counter_name],[instance_name],[cntr_value] FROM sys.dm_os_performance_counters WHERE OBJECT_NAME LIKE '%Batch Resp Statistics%') os_pc

PIVOT (AVG([cntr_value]) FOR [instance_name]

IN ("CPU Time:Total(ms)","CPU Time:Requests","Elapsed Time:Total(ms)","Elapsed Time:Requests") ) AS Pvt;

Can give you something like the following output

 

Another is reviewing locks

SELECT [counter_name],"OibTrackTbl","AllocUnit","HoBT","Metadata","Application","RID","Extent","Key","Page","Object","File","Database","_Total"

FROM (SELECT [counter_name],[instance_name],[cntr_value] FROM sys.dm_os_performance_counters WHERE OBJECT_NAME LIKE '%:Locks%') os_pc

PIVOT (AVG([cntr_value]) FOR [instance_name] IN ("OibTrackTbl","AllocUnit","HoBT","Metadata","Application","RID","Extent","Key","Page","Object","File","Database","_Total")) AS Pvt;

 

The final one I'll show you is the "Waits" in progress me system not much to see)

SELECT [counter_name],"Average wait time (ms)","Waits in progress","Waits started per second","Cumulative wait time (ms) per second"

FROM (SELECT [counter_name],[instance_name],[cntr_value] FROM sys.dm_os_performance_counters WHERE OBJECT_NAME LIKE '%Wait Statistics%') os_pc

PIVOT (AVG([cntr_value]) FOR [instance_name]

IN ("Average wait time (ms)","Waits in progress","Waits started per second","Cumulative wait time (ms) per second")) AS Pvt

WHERE "Average wait time (ms)" > 0;

Not much to see in this one as it is my Home system

 

The examples Queries as you can see are straight forward to compose, I know you can make a few of your own using the same pattern

Your challenge will be figuring out the steps to take to "Solve the performance hurdles" these type of Queries can reveal

Posted by NeilHambly | with no comments

Hello

With the remaining quarter of the year, promising to be as manic as the rest, having already done the following events

SQLBits 10, SQL Relay 2012, 24HOP (SQL Server 2012), SQLRally 2012 Dallas, TechEd AMS {PASS Ambassador} & 3 SQLSaturday's (Portugal, Dublin, Johannesburg), as well as
SQLDay in Poland, virtual event for Perth UG {Australian}  and not to mention a host of events for my own SQL London PASS Chapter, as the 1st UG event in Belfast {Good luck Ryan with the next one}

I still have the following scheduled events {and a few more potentially in the pipeline before the year is out}

  • 21st August UK SQL London User group, hosted @ Hitachi Office
  • 25th August (Live Meeting) Nepal User Group - Session on Wait Statistics "Why are we Waiting.." {same as my Summit 2011 session)

Sept

Extended Events - New Age of Profiling

Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions,

So we need to understand the differences it has to profiler "old guard" and why we should be using this new feature for this purpose I'll take you on a Guided tour of the
key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectively

So follow me to the "new age" of understanding your systems activity 


Session's agenda listed here http://www.sqlpass.org/sqlrally/2012/nordic/Agenda.aspx

My session will essentially be the also the same as I'll be presenting @ this year's Summit Nov 6th - 9th SQL PASS Summit

  • I'm excited to be attending my 2nd Summit, I was @ last year’s Summit and where I also did a regular session on Wait Statistics "Why are We Waiting.." I had 310 Attendees showed up for that, it was an amazing event :-)
  • This year I'm doubly excited to again presenting a regular Session, this time on SQL Server 2012 Memory

SQL Server 2012 Memory Management [DBA-312]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration & Deployment
Speaker(s): Neil Hambly

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.

http://www.sqlpass.org/summit/2012/Sessions/SpeakerDetails.aspx?spid=282

Note: There is the Voting Rounds for Lightning Talks for the Summit for just 1 week (20th - 24th Aug) So please make a vote for those you'd like to see <wink wink>

 

2013 - SQL Cruise {Jan 26th - 2nd Feb 2013} Miami and Eastern Caribbean

Although not 2012 event.. But as it is very exciting and it does set sail in Jan 2013, so I thought I'd tag it on @ the end of the post

I'll be attending and also presenting on the following SQLCruise - Jan 26th - 2nd Feb 2013 - Miami and Eastern Caribbean

Interested and want to know more? Here is the best place to find out about these amazing SQL Cruises http://sqlcruise.com/2013-cruises/

My session will a "Deep Dive" 2-Hour special on SQL Server 2012 Memory Management as detailed below

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.

Does anyone think I was lacking badges in this post ! 

Posted by NeilHambly | with no comments

I have some wonderful and exciting news to share

I've been fortunate to become one of an amazing line-up of "Technical Leaders" for the 2013 SQL Cruises http://sqlcruise.com/2013-trainers/

So I'm very pleased to announce I'll be presenting a 2-Hour session on "SQL Server 2012 Memory Management" on the Miami SQL Cruise http://sqlcruise.com/2013-training/

I'm going to be working hard on honing those precious 120 minutes into an intense DEEP Dive on SQL 2012 Memory

Want to know how well that memory is being utilized then this session is tailored made for you, the session will be DEMO heavy (in addition to background & reference materials),the sessions focus will be on identifying techniques to troubleshoot & resolve Memory related issues and performance

If you want to see this session first hand and receive the outstanding training that is available on the Cruises, then simply make a BOOKING for one of those in-demand seats, they are limited and have always filled fast on
previous cruises - Don't miss out by delaying your decision

As a previous cruiser I can attest first-hand how being immersed for a full week with the expertise of the SQL Cruise Technical Leaders along with the other SQL Cruisers can make a HUGE difference to your SQL
careers, do you have a SQL problem you need to get insight into, here is your opportunity to find some answers

I'm hoping to have become a SQL Server 2008 MCM by the time the cruise start and perhaps even on the way to becoming a 2012 MCSA as well

I'm also looking forward to doing some scuba diving - may have to get certified before I go to take full advantage of the diving opportunities, and would love to swim with some dolphins as well





Posted by NeilHambly | with no comments

Today is 19th June and after nearly busting @ the seams for a week or so, I can along with many others now annouce the news that I had a selected Abstract and will therefore be speaking @ this years PASS Summit...

I do feel special to have been chosen and I know a number of VERY talented and experienced speaker that where less fortunate.. So I have to pull oput all the stops to make this the BEST session I have ever given

My session is a longer version (= more Demo's) and somewhat different version than I give @ the last 24HOP- So I hope if you are @ the Summit you come along and say Hi and attend this session

I'm thinking on how to fit ~ 4K of you in a room for this session.. maybe I'm aiming a little too high on attendance numbers - but my last one @ PASS Summit had 310 attendee's, so let's try to double that @ least !

SQL Server 2012 Memory Management
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration & Deployment
Speaker(s): Neil Hambly

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.
 
Also Congrats to all the Summit 2012 Speakers, especially those based in the UK
 
 
Other News
Next Week I'm  going to be enjoying my 1st TechEd in Amsterdam (I'm not as speaker - hmm maybe next year) but helping represent PASS, so please come by the Booth and say Hello
 
We have  a number of UK events coming up.. this Thursday we have our 2nd SQL Relay Day in London
Still a few seats available for that
 
SQL London PASS Chapter has the website http://sqllondon.sqlpass.org/ up and running for the events we have in London
 Next dates of the events are
  • 19th July {rescheduled from the 21st June)
  • 21st August
  • 19th Sept

We are helping to arrange a NEW Belfast Usergroup event in August on 9th (Speaker Neil Hambly & Alex Whittles)

http://sqlserverfaq.com/events/423/Belfast-SQL-UserGroup-9th-August-2012-with-Neil-Hambly-Alex-Whittles.aspx

I'll be @ Dev4Good the weekend of the 7th & 8th August  ... Should be a lot of fun http://dev4good.net/events

 

     
 
 
 
 
 
 
Posted by NeilHambly | with no comments
More Posts Next page »