Aug 18

Partitioning

SQL_XOne of my favourite features I’ve been recently presenting on covers the practical usage of partitioning

“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.

SQLBits XII Telford  (Jul 2014)

SQLBITSXII_Effectiveindexpartitioningcompression_title

 

 

 

 

 

Video {Stream | Download} Video Effective Index Partitioning Compression Strategy

PDF Presentation Effective Index Partitioning & Compression Strategies PDF (Telford SQLBits 12)

I’ve also presented this partitioning-compression session @ these other events

  • SQLSaturday #269 Exeter (Mar 2014)
  • SQLSaturday #208 Madison (Apr 2013)

This session was originally 2 separate sessions on partitioning & compression

“Effective Data Management Using Data Compression”

  • SQL-in-the-City London (Jul 2011)
  • SQLSaturday #105 Dublin (Mar 2013)
  • SQLSaturday #115 Portugal (Mar 2013)

DataCompression_title

DataCompression_Redgate_title

 

 

 

 

 

 

Aug 18

SQL Relay 2014

SQLRelay 2014 – Unlock insights on any data

We’re bringing SQL Server to a town near you Join us for our analytics focused, FREE all-day conference UK-Map

With some of the best speakers in the world!

With a track dedicated to the SQL Server engine we’re helping you ensure maximum stability, availability and potential for your data. Our other track will focus on getting that data and turning it into something meaningful.

Visit the website www.sqlrelay.co.uk to register, as you can see spaces are going fast, don’t delay register today while spaces are still available

Event Date Day Spaces left1 Register
Reading 13/10/14 Mon 116 (58%) Register
Southampton 14/10/14 Tue 74 (74%) Register
Bristol 15/10/14 Wed 17 (19%) Register
Cardiff 16/10/14 Thu 30 (40%) Register
Newcastle 27/10/14 Mon 55 (61%) Register
Leeds 28/10/14 Tue 109 (55%) Register
Birmingham 29/10/14 Wed 58 (39%) Register
London 30/10/14 Thu Sold Out (Wait List) Register

 

 

 

 

 

 

 

SQLRelay2014Organising3 I’m the Lead for the Reading event this time around

SQLRelay2014Speaking3  I’ll be delivering some sessions again at some events

SQLRelay2014Going3  I’ll be attending as many of the events as I can

Aug 17

BA Conference

MDS and DQS – Beyond the TLAs to Data Quality

Many three-letter acronyms (TLAs) adorn our database world. This session focuses on two recent additions – MDS (Master Data Services) and DQS (Data Quality Services) – explaining what the new features are and exploring how to leverage them to improve your data quality. High data quality is fundamental to any business analytics system. In this session, we’ll begin with an overview of data quality and the latest Microsoft tools available, and then demonstrate MDS and DQS and how to use them together for continuously improving data quality. We’ll also look at how to integrate them into your existing data-quality strategies. Data quality is everyone’s responsibility – but we can still lead the way forward. Join this session to see how.

PASS BA Conference Chicago (Apr 2013)

MDSDQS_title

Aside from the Summit I have presented this MDS/DQS intro session @ these other events

  • SQLSaturday #281 Edinburgh (Jun 2014)
  • SQLSaturday #237 Charlotte (Oct 2013)
Aug 17

Summit 2013

Load Testing with SQL Server Tools

It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels.

Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.

PASS Summit Charlotte (Nov 2013)

This will be my 3rd consecutive year attending a PASS Summit, this one is a little different as we are in a different city, this year we are on the east coast in the lovely city of Charlotte (North Carolina) the home of NASCAR and we have some friends there as well, as it is also home to SQL Sentry

LoadTestingwithSQLServerTools_title

PDF Presentation PASS 2013_NeilHambly_LoadTestingSQLServer

Aside from the Summit I have presented this Load Testing with SQL Server Tools session @ these other events

  • SQL Relay 2013R2 Norwich (Nov 2013)
  • PASS DBA Virtual Chapter Virtual (Dec 2013)
Aug 17

Summit 2012

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.

PASS Summit  Seattle (Nov 2012)

This was my 2nd year @ the Summit as well as my 2nd time presenting a summit session, this time around it would be a regular 75 minute session on Memory Management with a special focus on the changes in how memory is managed with the SQL Server 2012 release

MemoryMgmt2012_title MemoryMgmt24HOP_title

Video link http://www.sqlpass.org/SessionResources/Stream.aspx?sid=3158  & Download Material

PDF Presentation  DBA-312 SQL Server 2012 Memory Management PDF

Aside from the Summit I have presented this Memory Management session @ these other events

I’ve was also able to present a special Deep-Dive 2-Hour version (Jan 2013) of this session at quite an unusual conference location, as this was aboard a Cruise ship  Really! YES, Really! I’m talking of course about the acclaimed SQL Cruise experience http://sqlcruise.com/ Sqlcruise_title

It was my 2nd SQL Cruise experience, having already been a ‘cruiser’ on the Alsaka SQLCruise in 2011, the term ‘Washy Washy’ will always be with me, maybe you should also ask Tim Ford about the Oreo challenge (it’s harder than it looks) This 2013 Miami SQL Cruise I was also fortunate enough to be chosen as one of their technical leads, I was indeed in good company as this listing shows http://sqlcruise.com/2013-trainers/

2014-Tee-Shirt-Front-500x181

SQL CRUISE LEARN. NETWORK. RELAX. GROW… JUST ADD WATER
Aug 17

Summit 2011

Why are we Waiting..  

PASS Summit  Seattle (Oct 2011)

This was my 1st PASS Summit session and one I have presented it elsewhere as well, it is primarily focused on explaining performance issues via the analysis of the Wait Stats sys.dm_os_wait_stats DMV, we use the DMV to identify performance issues and discover WHY the queries are waiting and on what type of resource

Whyarewewaiting_title

Slides PDF  DBA_320_Why_are_we_Waiting_NeilHambly

Video link http://softconference.com/pass/sessionDetail.asp?SID=274928  sync’d with presentation. Duration: 75 minutes  – Think most should be able to access this now if your a PASS member and have logged in, this is of course just one of the sessions from the 2011 Summit, you have access to the others as well – which is just awesome

With 310 attendees (full double room) this was a quite a step up in # attendees from my previous largest audience so far with ~100 being the largest I had ever had presented before this, incidentally that was my 1st ever presentation (London March 2010) If I recall correctly

I’ve also presented this wait-stats session (or some variation of it) @ these other events

Aug 16

Summit 2014

In November for the 4th consecutive year I’ll be excitably flying across the pond to Seattle in order to attend the Summit, where I’m also lucky enough to be one of this years presenters, I’ll be delivering my 4th PASS Summit session, and this year I have the honour of delivering one of 8 longer 1/2 day (3 Hour) sessions, my session will be on focused on DMVs and how to use them to do performance troubleshooting

Performance Troubleshooting Using DMVs http://www.sqlpass.org/summit/2014/Sessions/Details.aspx?sid=6819

Performance troubleshooting is a complex subject with many factors under consideration when you find poorly performing SQL statements, using proven methodologies, and evaluating performance data available in the Dynamic Management Views and Functions. In this session, we’ll go over a foundation of how and which DMVs to use to identify those problematic statements for versions of SQL Server from 2005 – 2014.

We’ll be demonstrating using practical examples, including code that can be taken away and used on attendees’ own SQL Servers. We’ll also discuss how to identify common causes of performance issues, and learn how to quickly review and understand the wealth of performance data available.

PASS-Summit-2014-Speaking-Badge_250x250

So perhaps I might even see you in my audience for that or elsewhere @ the conference @ one of the watering holes we are known to frequent during that week, especially if you are a whisky lover like me

If we haven’t as yet meet and you’ll be @ this years summit, I have my profile link below which may be of some help, so you know a little about who I am and what I look like

 

 

I do look forward to meeting lots of new friends perhaps that includes you, alongside those I already know from past events http://www.sqlpass.org/summit/2014/Speakers/Details.aspx?spid=282

 

Aug 15

Neil’s Presentations

I have been presenting for quite a while now and have not made all my presentations available for users to download PDF of the sessions and scripts, so it’s about time I did something about that and got myself organised and upload these for everyone to access

Over the coming few days I’m going to work on creating a page for each of the presentations available and where these have been presented in the flesh {or online}

Hope this helps anyone interested in the materials and feedback on these are always welcome, the 1st batch of these will be posted over the weekend

Neil