If you are going to at SQLPASS 2015, Seattle, I am looking forward to meet you. I will be there and presenting two technology sessions.
Here are the details of my sessions. I will be very happy if you are at SQLPASS and attend my session. If you see me at SQLPASS, just do not hesitate to stop me as I would for sure like to talk to you and shake your hands.
During this event, I will be actively tweeting about where exactly I am and how can you reach me. Do not forget to follow me on twitter.
42 Tips to Performance Tuning, Optimization, and Everything
Monday, Oct 26, 2015 08:30 AM- 04:30 PM
This demo-oriented, full-day pre-conference session answers the questions that database administrators (DBAs) and developers often have about performance tuning and query optimization. Some problems have straightforward answers, but others are often invisible or need attention without even a problem statement. This session is divided into these three major components:
– Identify common patterns and antipatterns for database performance tuning; for example, slow-running queries, I/O-intensive operations, CPU bottlenecks, memory optimizations, tempdb contention, and more
– Resolve optimization hindrances and issues proactively; for example, indexing strategies, file growths, server deployment best practices, statistics, wait stats and queues, and more
– Avoid query performance surprises when upgraded to the most recent version of SQL Server 2014; for example, new cardinality engine, ColumnStore indexes best practices, live plans, Azure enhancements, in-memory online transaction processing (OLTP) optimizations, and more
We discuss 42 tips, tricks, and scripts in this session. Every attendee will have those scripts handy upon completion of the session.
Secrets of SQL Server: Database Worst Practices
Wednesday, Oct 28, 2015 10:15 AM – 11:30 AM
“Oh no–what have I done?” Chances are you have heard, or even uttered, these words. This demo-oriented session shows many examples in which database pros have been dumbfounded by their own mistakes. It might even bring back memories of your own early DBA days. This session exposes the small details that can be dangerous to the production environment and SQL Server as a whole and talks about worst practices and how to avoid them. The session focuses on common errors and their resolution. Developers will walk out with scripts and knowledge that they can immediately apply to their own servers.
Reference: Pinal Dave (https://blog.sqlauthority.com)