Neil Hambly is the Founder/CIO/Consult @ DataMovements Limited (Gold Data Analytics, Training & PowerBI Partner), previous roles @ ABN AMRO, Accenture, ASOS, BBC, Confio Software with 20+ years using SQL Server.

Presented 300+ events, including 50 PASS Summit/24HOP/Rally/SQL Saturday, 20 European events (12 countries), 50 + UK (SQLBits, SQLRelay)  Leader of PASS London (UK) & Professional Development VC, Melissa Data MVP (2015)

SQL Cruise Technical Lead, Likes Guinness, Loves Whisky, Dancing

Neil Hambly has submitted 3 sessions for SQLBits 2019, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Would having a good understanding of all the different versions, editions, OS Builds, CPU & Memory and database details in a single reporting place be useful? Many of my previous clients have found that just to be the case…. FREE PowerBI Report
Database security is one of those topics that too many misunderstand; haven’t learned it to the right depth, or just not sure how to approach designing a database security strategy. During this session we will examine the Security landscape
Performance troubleshooting can be a complex subject, often involving many factors which need to be taken into consideration when finding SQL statements with below-par performance, tackling the important questions we need to ask when troubleshooting.

Sessions

Previous Sessions

DAC(Data Tier Applications) a new feature introduced in SQL Server 2008 R2, learn how this new feature can fit into your database deployment lifecycle strategies, monitor the health & performance of your DAC applications using Utility Explorer
Not to be confused with the Rugby / Football ditties, but actually an in-depth look @ "Waits" Side of the well-known "Waits & Queues" methodology With focus in this session on interpreting the information in the (DMV) sys.dm_os_wait_stats
This session was first given @ SQLBits 8, with the upcoming Denali release we can not only revisit this topic once more, but add to it further showing techniques and enhancements to the "Waits" analysis now possible with the latest SQL release
The Enterprise only feature "Compression" can make a HUGE difference to your storage requirements and we will examine this feature in detail, integrate this into your strategies, finding objects which your should use this one
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, discover all these important changes
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
Understanding how SQL Server performs under various Load scenarios, requires controlled testing of a SQL Server instance whilst capturing key metrics using tools like Distributed Replay Controller can make this challenging task easier
We all know that correct indexing is king when it comes to achieving high levels of performance in SQL Server. When indexing combines with the enterprise features partitioning and compression, you can find substantial performance gains.
Building effective PowerBI reports and dashboards requires a well-designed data model with the right relationships and measures, this session tackles those challenges your encounter during the design phase and where to get training required for this.
Neil_Hambly250818.jpg