At the end of the month, I'll be delivering a pre-conference session in Auckland on Friday 31st of next month (August). Would love to see you there. Details are as follows:
Developing SQL Server Applications that Perform
So many SQL Server applications today are so slow, even simple ones, yet the product is capable of amazing performance, even in tier-1 organizations. Greg spends his life working with SQL Server developers (from the smallest startup software houses to many large tier-1 organizations), working with them to get their applications flying.
In this one-day workshop, you'll learn:
* How SQL Server indexes work
* How data type choices affect index performance
* How to design appropriate table structures and indexes
* How indexing issues appear in query plans
* How to use query plans and other tools to find out why your queries aren't performing as expected
* Where columnstores fit into this picture (where you should and shouldn't use them)
* Where in-memory OLTP fits into this picture (where you can and can't use memory-optimized tables and native compilation)
* How to avoid common application performance design mistakes and anti-patterns that I see regularly
This session is for developers, DBAs, and consultants who need to know how to build better SQL Server applications, and to understand why SQL Server applications are slow.
Registration is available here: