Partitioning

One 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(…)

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 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(…)

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(…)

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(…)

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(…)

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(…)

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(…)

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(…)

Please please tell me now…

.. Is there something I should know,  sang Duran Duran many moons ago when I was young and before I knew that query optimization was even a thing.  But,  it is quite a handy little line to keep in mind when you are tuning queries,  giving SQL server a little bit more explicit information about(…)

How Hekaton (XTP) achieves Durability for “Memory Optimised” Tables

“Memory Optimised” tables reside entirely in memory, the operations INSERT, UPDATE and DELETE as well as SELECT are all significantly quicker, but just how is it possible to achieve durability with memory optimised tables while still achieving the significantly higher throughput? Like traditional on-storage tables durability is achieved once the data has been written and hardened off(…)