Dave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years, the past 15 of which has been specialising within SQLServer environment.
Dave Ballantyne has submitted 3 sessions for SQLBits 12, although the agenda hasn't been chosen yet. See all submitted sessions
The query optimizer is at the heart of SQLServer. Much of the its' internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags. This session will be a deep dive into the these internals.
This session will be a look at the cardinality estimator changes in SQL Server 2014, comparing and contrasting with SQL2012/2008 to see how they help.
At the heart of SQL Server is the cost based optimizer. This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these.
An overview of some everyday TSQL tuning techniques.
Writing your first SSIS custom components can seem like a very steep learning curve. In this session i shall walk you through a simple skeletal one to start you on your way.
A look at the new TSQL functionality within denali
A high level look at some of the TSQL enhancements added to SQL Server 2012
At the heart of SQL Server is the cost based optimizer. This is driven by estimates and they in turn are driven by statistics.
This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong.