4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Benjamin Nevarez

Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals”. With more than 20 years of experience in relational databases, Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits. Benjamin’s blog can be found at http://www.benjaminnevarez.com and he can also be reached by e-mail at admin at benjaminnevarez dot com and on twitter at @BenjaminNevarez.

http://www.benjaminnevarez.com/ http://feeds.feedburner.com/BenjaminNevarez
Benjamin Nevarez has submitted 3 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine.
Learn about the new SQL Server 2014 cardinality estimator and how both the new and the old cardinality estimator work, what their differences are and how to detect, troubleshoot and fix plan regressions.
This session will show you how the query optimizer has been updated to work with the new SQL Server 2014 features and to provide better performance to existing ones. Topics include Hekaton, the new cardinality estimator and incremental statistics.

Previous Sessions

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization.
This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well.

Blog posts RSS

SQL Server 2014 Query Tuning & Optimization Book Code 16 Dec 2014
Today I was finally able to finish extracting the code of my new book Microsoft SQL Server 2014 Query Tuning & Optimization after a few readers requested it recently but I had been busy with some traveling in the last few weeks. The book contains a large number of SQL queries, all of which are ...

PASS Summit and Other Speaking Engagements 18 Sep 2014
It is almost that time of the year again when we are all headed to attend the largest SQL Server conference in the world, the PASS Summit, hosted again in Seattle. In my particular case I will also be attending some other SQL Server events where I will be given probably more than a dozen […]

Speaking at SQLBits and the PASS Summit 10 Jul 2014
I am really excited that this weekend I will be flying to the UK to participate in my first European SQL Server conference, SQLBits XII, where I am scheduled to present 2 sessions. SQLBits XII, the largest SQL Server conference in Europe, will be held at The International Centre in Telford, UK from ...

New Book: SQL Server 2014 Query Tuning & Optimization 21 Apr 2014
  It looks like my blog has been very quiet for a while once again. Yes, I’ve been busy working on some other SQL Server projects since last year. One of those projects was working on Kalen Delaney’s new book SQL Server 2012 Internals where I co-authored two chapters, “Special Databases” and ...

Speaking at the PASS Summit 2013 09 Oct 2013
In just a few days I will be headed to Charlotte, NC to attend my eleventh PASS Summit. Yes, I’ve been attending this, the largest SQL Server and BI conference in the world, every year since 2003. I am also honored to be speaking at the conference again making this my sixth year as a […]