Are you tired of dealing with slow running queries and performance issues in your SQL Server database? Look no further! In this blog post, we will discuss some valuable tips and tricks to improve the performance of your SQL Server database.

Session 1: SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions

Date: March 18, 2013 – Bangalore

Date: March 25, 2013 – Pune

Time: 2:45 – 3:45 PM

In this session, we will explore the art of performance tuning and troubleshooting in SQL Server. Many believe that this art has been lost in time, but the truth is that it has evolved with the advancements in technology. We will focus on detecting and resolving high CPU scenarios, which is one of the major resources that can bottleneck performance. Additionally, we will cover other performance-related tips and tricks. By the end of this session, you will have clear ideas and action items to tackle resource-intensive scenarios in your production server.

Session 2: Indexes – The Unsung Hero

Date: March 19, 2013 – Bangalore

Date: March 26, 2013 – Pune

Time: 2:45 – 3:45 PM

Slow running queries are a common problem faced by developers when working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, the issue often lies in the way queries have been written and how indexes have been set up. In this session, we will focus on identifying problems that slow down SQL Server and provide indexing tricks to fix them. You will walk away with scripts and knowledge that can be immediately applied to your servers.

Don’t miss out on this opportunity to enhance your SQL Server skills and improve the performance of your database. We look forward to seeing you at TechEd India!

Pluralsight will be sponsoring the TechEd India event, so make sure to stop by their booth for some goodies and a chance to meet the Pluralsight executives.