Published on

March 1, 2013

SQL Server Concepts: Performance Tuning and Indexing

Are you struggling with slow running queries and performance issues in your SQL Server environment? If so, you’re not alone. Many developers face these challenges on a daily basis. But fear not, because I have some exciting news for you!

I am thrilled to announce that I will be presenting two sessions on Performance Tuning and Indexing at the upcoming TechEd India event. This event is a great opportunity for you to gain valuable insights and practical tips that you can implement right away in your daily job.

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

Date: March 18, 2013 (Bangalore) | March 25, 2013 (Pune)

Time: 2:45 – 3:45 PM

In this session, we will explore the art of Performance Tuning and Troubleshooting, which has evolved over time with the introduction of new tools and techniques. We will focus on one of the most common performance bottlenecks – High CPU scenarios. You will learn how to detect these scenarios and implement effective resolutions. If time permits, we will also cover other performance-related tips and tricks. By the end of this session, you will have a clear understanding of how to tackle resource-intensive scenarios involving CPU, IO, and Memory.

Session 2: Indexes – The Unsung Hero

Date: March 19, 2013 (Bangalore) | March 26, 2013 (Pune)

Time: 2:45 – 3:45 PM

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

But wait, there’s more! If you attend my sessions, you will have a chance to win my brand new SQL Server 2012 book combo set worth RS 4000. I will be giving away two sets of the combo sets during the sessions. Additionally, I will also have a few copies of my SQL Server Interview Questions and Answers book available.

Don’t miss out on this incredible opportunity to enhance your SQL Server skills and improve the performance of your databases. Mark your calendars and join me at TechEd India for these informative sessions. I look forward to seeing you there!

Click to rate this post!
[Total: 0 Average: 0]

Let's work together

Send us a message or book free introductory meeting with us using button below.