SQLAuthority News – Presenting 3 Technical Sessions at Great Indian Developer Summit – May 7, 2013 – Bangalore

I will be presenting once again 3 Technical Sessions on SQL Server and Performance Tuning at Great Indian Developer Summit on May 7, 2013. If you are going to attend the event, you do not want to miss the technical sessions at any cost. Here is the generic theme for every session I will be presenting at Great Indian Developer Summit.

• Each session will have 30% theory and 70% demonstrations
• Attendees will have access to scripts presented in the session
• Location to review the videos and free learning material associated with the session
• Practical Performance Tuning Tips to tune your server

Attendees will be able to learn the knowledge which they will be able to apply as soon as they walk out of the session. Here is the details about the session:

Tips and Tricks for Blazing Fast SQL Server Performance

12:00 PM | May 7, 2013 | Main Hall
60 mins | GIDS.NET | Session

Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how SQL Server has been set up. The session will focus on the ways of identifying problems that slow down SQL Servers, and tricks to fix them. In this session we will cover the common issues related to the Indexes, Statistics, Joins, Conditions as well cover a few of the mistakes developers do when they are rushing to meet deadlines. We will quickly cover SQL Server Worst Practices as well have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally all attendees of the session will have access to learning material presented in the session.

Performance in 60 Seconds – Database Tricks Every SharePoint Developer MUST Know

14:00 PM| May 7, 2013 | SD Hall
60 mins | GIDS.NET | Session

Data and Database is a very important aspect of SharePoint implementations. SharePoint Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the SharePoint Developers who want their server to perform at blazing fast speed but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally all attendees of the session will have access to learning material presented in the session.

Secrets of SQL Server: Database Worst Practices

15:10 PM| May 7, 2013 | SD Hall
60 mins | GIDS.NET | Session

“Oh my God! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. Shedding light on some of these perils and the tricks to avoid them may even save your current job. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally all attendees of the session will have access to learning material presented in the session.

If you are going to be at the event, do not hesitate to stop by Pluralsight booth. I will have something unique for you – do not forget to ask for it.

Reference: Pinal Dave (https://blog.sqlauthority.com)