SQLAuthority News – A Successful Performance Tuning Seminar at Pune – Dec 4-5, 2010

This is report to my third of very successful seminar event on SQL Server Performance Tuning.

SQL Server Performance Tuning Seminar in Colombo was oversubscribed with total of 35 attendees. You can read the details over hereSQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010.

SQL Server Performance Tuning Seminar in Hyderabad was oversubscribed with total of 25 attendees. You can read the details over here SQL SERVER – A Successful Performance Tuning Seminar – Hyderabad – Nov 27-28, 2010.

The same Seminar was offered in Pune on December 4,-5, 2010. We had another successful seminar with lots of performance talk. This seminar was attended by 30 attendees.

The best part of the seminar was that along with the our agenda, we have talked about following very interesting concepts.

  • Deadlocks Detection and Removal
  • Dynamic SQL and Inline Code SQL Optimizations
  • Multiple OR conditions and performance tuning
  • Dynamic Search Condition Building and Improvement
  • Memory Cache and Improvement
  • Bottleneck Detections – Memory, CPU and IO
  • Beginning Performance Tuning on Production
  • Parametrization
  • Improving already Super Fast Queries
  • Convenience vs. Performance
  • Proper way to create Indexes
  • Hints and Disadvantages

I had great time doing the seminar and sharing my performance tricks with all. The highlight of this seminar was I have explained the attendees, how I begin doing performance tuning when I go for Performance Tuning Consultations.

Pinal Dave at SQL Performance Tuning Seminar

Pinal Dave at SQL Performance Tuning Seminar

SQL Server Performance Tuning Seminar

SQL Server Performance Tuning Seminar

Pinal Dave at SQL Performance Tuning Seminar

Pinal Dave at SQL Performance Tuning Seminar

Pinal Dave at SQL Performance Tuning Seminar

Pinal Dave at SQL Performance Tuning Seminar

SQL Server Performance Tuning Seminar

SQL Server Performance Tuning Seminar

SQL Server Performance Tuning Seminar

SQL Server Performance Tuning Seminar

This seminar series are 100% demo oriented and no usual PowerPoint talk. They are created from my experiences of various organizations for performance tuning.

I am not planning any more seminar this year as it was great but I am booked currently for next 60 days at various performance tuning engagements.

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

SQL SERVER – A Successful Performance Tuning Seminar – Hyderabad – Nov 27-28, 2010 – Next Pune

My recent SQL Server Performance Tuning Seminar in Colombo was oversubscribed with total of 35 attendees. You can read the details over here SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010. I had recently completed another seminar in Hyderabad which was again blazing success. We had 25 attendees to the seminar and had wonderful time together.

There is one thing very different between usual class room training and this seminar series. In this seminar series we go 100% demo oriented and real world scenario deep down. We do not talk usual theory talk-talk. The goal of this seminar to give anybody who attends a jump start and deep dive on the performance tuning subject. I will share many different examples and scenarios from my years of experience of performance tuning.

The beginning of the second day is always interesting as I take attendees the server as example of the talk, and together we will attempt to identify the bottleneck and see if we can resolve the same. So far I have got excellent feedback on this unique session, where we pick database of the attendees and address the issues. I plan to do the same again in next sessions.

The next Seminar is in Pune.I am very excited for the same.

Date and Time: December 4-5, 2010. 10 AM to 6 PM

The Pride Hotel
05, University Road,
Shivaji Nagar,
Pune – 411 005
Tel: 020 255 34567

Click here for the agenda of the seminar.

Instead of writing more details, I will let the photos do the talk for latest Hyderabad Seminar.

Hotel Amrutha Castle

Hotel Amrutha Castle

King Arthur's Court

King Arthur's Court

Pinal Presenting Seminar

Pinal Presenting Seminar

Pinal Presenting Seminar

Pinal Presenting Seminar

Seminar Attendees

Seminar Attendees

Pinal Presenting Seminar

Pinal Presenting Seminar

Group Photo of Hyderabad Seminar Attendees

Group Photo of Hyderabad Seminar Attendees

Seminar Support Staff - Nupur and Shaivi

Seminar Support Staff - Nupur and Shaivi

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010

I have been on world tour on SQL Server Performance Optimizations Seminar. The latest seminar was conducted in Colombo, Sri Lanka on Oct 4 – Oct 5. I had previously written about this event over SQLAuthority News – SQL Server Seminar at Colombo Full. This event was oversubscribed and we could not accommodate the last few nominations due to the restrictions of the place. We had total of 35 attendees and the event offered lots of fun. The attendees were a perfect combination – all had few years of experience and many of them were responsible for performance for their server. There were few attendees who were just there to know if SQL Server can deliver performance and what are its tricks.

Colombo Beach

Colombo Beach

Warm Welcome

The event was very much welcomed and I received a lot of good feedback. In this event, only few slides were presented – the rule of thumb I had was that I will show only one slide per hour and remaining time I will spend with attendees with real world scenarios and examples. During the two day sessions, we went through many examples, nearly 30 different performance tuning tricks, and tools and understood how performance is often misunderstood with scalability.

SQL Server Seminar Group Photo

SQL Server Seminar Group Photo

What really caught my attention is that many of the attendees thought creating Indexes is the way to improve performance. I had fun time to bust the myth of indexes, and later on, we learned the real trick of how we can improve the performance using indexes.

SQL Horoscope

As attendees were really interested in their current scenario, we did something very interesting during the training. I provided them a couple of queries on the very first day. On the second day, they brought the query results back to me. Based on these query results, we tried to play game where I told them what their server’s bottleneck is and what is it used as. The game went for nearly 10 minutes and we had fun time talking to attendees regarding their server.

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar

Real World Scenario

The real world is often quite different from the theoretical world. The issues which we learn in classroom are not the same when we deal with the live production server. I focused on real world scenario and asked attendees to bring their valuable queries and configurations. Together, we discussed about their server and tried to help them out with the next logical steps to improve their server. This was a learning experience for me as well. Every server is new and every server has its own tale to share.

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar

Excellent Participants

No matter how good sessions are, without proper interactive conversations and questions, any session can become boring. As I said earlier, the attendees were very much interested in the subject itself and they really wanted to learn the tricks. Well, I wanted to share my tricks too. It was perfect match – which lead to overall great feedback of the event. I received many emails after the session, I would like to share one here.

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar

Feedback

Here are some of the feedbacks received on my training in Sri Lanka.

“Many thanks for the email – your seminar was one of the best sessions I attended in my life. You made it so attractive and kept us at the edge of the seat every minute.”

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar

“A BIG THANKS to your training, we all are at office and just experienced the first great benefit of your training right now. There was a major issue for almost a month which we discussed with you yesterday where the Java program and the SP tried to access the same table and Java program get stuck. Based on your training we have done some changes to Index & where clause and the problem is sorted out now. Juts now, we have completed. No more table lock and the Java program works fine. Once again thank you very much.”

Well, what else I can say, I am overwhelmed with this interest.

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar

Next Seminar

My next seminar will be conducted in Hyderabad on Nov 27 to Nov 28 (Saturday, Sunday). The location of the seminar is at Best Western Amrutha Castle, 5-9-16, Opp. Secretriat, Saifabad, Khairatabad, Hyderabad. The fee for attending the seminar is Rs. 5,000. If you specify the code ‘SQLAuthority.com,‘ you will quality for 20% discount. Send email to indiainfo@solidq.com and pinal ‘at’ sqlauthority.com to register for the seminar.

You can click here to read more details about seminar.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server

healthcheck SQLAuthority News – SQL Server Health Check Service – Speed UP SQL ServerIn my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically man of the performance tuning. I love to tune servers and I love to speed up queries. I often get queries what do I do when I go to performance tuning. Here I am listing my complete service descriptions.

This whole exercise can be done remotely as well on site. The advantage of on site is that I am more involved with local DBAs and the training part is much more enjoyable. I have often got very good relations with the local DBA and we still talk when they have issues with server. There is no replacement of the human connections. The advantage of the remote is there is no travel involved and can be economic when the location is very remote or there is urgent need of performance.

Please read more about this service over here

SQL Server Health Check Service

SQL Server Health Check is a very challenging subject that requires expertise in Database Administration and Database Development. Solid Quality Mentors provides specialized health check service where we dive deep into your SQL Server configurations and potential issues and propose solutions to resolve your issues. We also provide maintenance scripts and train your team on few of the key areas in order to empower them to understand and tune the systems in the future. We also provide Hands-On sessions for tuning your queries and propose solutions for your deadlock situations.

Download the HealthCheck PDF details from here

If you need this service drop me an email at pinal “at” SQLAuthority.com and IndiaInfo “at” SolidQ.com. If you specify SQLAuthority.com in Title, you will avail special discount in overall rates.

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

SQLAuthority News – SQL Server Performance Optimization – Seminar Series

I am very glad that I will be presenting my very first seminar training series worldwide. This event is called the Solid Quality DIRECTIONS Seminar Series. I am very fortunate that I am given this opportunity to work under prestigious organizations. I have been with Solid Quality Mentors for more than a year now. I have learned a lot and I have grown a lot through this group. While working for Solid Quality, I have conducted many training events and various consultations projects. I can say that I have collected and kept with me all the wisdom and knowledge related to my passion, SQL. In one of my recent conversations with Rushabh Mehta (Solid Quality India CEO), I realized that I have a chance to share with everybody this wisdom I have learned. For the very same reason, I will present all the things I learned throughout these many years and  compress them into this one major seminar.

The quick schedule for registering here is listed below:

The very first seminar will occur in Chennai. The detailed agenda of this event you can find over here.

The venue for the first training is as follows:

SAVERA HOTEL
146, Dr. Radhakrishnan Road,
Chennai – 600004, India
Phone: +91-44-2811-4700

Agenda of the event

This 2-day seminar will cover the best of the best concepts and practices from popular courses offered by Solid Quality Mentors. Instead of learning theory only, the seminar focuses on providing real world experience by using demos and scenarios derived from customer engagements. The seminar is uniquely structured and well-thought-out. Sessions are discussion- based and are designed to be an interactive gateway between the instructor and the participants for an optimal learning experience. The seminar is intended to be immersion-based where participants will have plenty of opportunities to get deeply involved in the concepts presented by the instructor. The best participants will receive special educational materials from the instructor, as well as further follow ups.

3 Free Registrations

Solid Quality India has announced three free give-away registrations for the first event. To win the free registrations, you have to write a blog post or comment on social media (facebook, twitter etc) as to why you should win the free registrations. If your entry is chosen to be the best one, you will win the free registrations. Once you write your blog post or spread the word in social networking, please leave a comment with the name of the city where you want to win free registrations.

To join the seminars, please drop me an email. My email address is pinal “at” SQLAuthority.com and IndiaInfo “at” SolidQ.com. If you specify SQLAuthority.com in the Title of your email, you will avail a special discount in overall rates on specified price. Yes, a more than 20%, I promise.

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

SQLAuthority News – I am Microsoft Certified Trainer (MCT)

I am a Microsoft Certified Trainer and I am very much proud of it. Because I am a MCT, I have the support of great community leaders and trainers who help me constantly to improve in what I do. I have many Microsoft Certifications and I constantly try to take more of these. Every time, a new certification is announced, I make sure to add it to my list of existing ones. This post is written to make the community aware that how sometimes strict bureaucracy guidelines can create issues and a very well-confirmed project can crash.

Those who know me and read my blog know that I make my living by doing the following:

  • SQL Server Consultation (Primary Domain – Performance Tuning and Query Optimizations)
  • SQL Server Training (Wide Ranges of classes – Primary Subject – Performance Tuning and Query Optimizations)

If I have empty weekend, I usually travel anywhere in Asia-Pacific to deliver an SQL Session and I absolutely make NO Money there. However, by God’s grace, my SQL Sessions and travels for sure have gave me a good name in local community, and it gives me great satisfaction that I am able to help people as many people have helped me.

Everybody always look for an experienced person as a trainer or consultant. As I have written on SQLAuthority.com for almost 4 years, many people also know me from this blog as well.

Before committing for any consultancy project or training, I usually talk to project leader or technical head. These conversations are very helpful and help me to understand the project requirements early on hand.

Recently, I came across a strange situation, which showed me that a good reputation doesn’t count every time. I had already talked to the project manager and project was all finalized. They wanted a custom training course for the first one week, followed by consultation in the second week and a live project with the client. The client had already delivered advance payment, and my travel agent had made the flight and hotel booking as well. Just an hour before my flight, I received a phone call from the HR person, who said that they have a strict requirement that every trainer who comes to their organization must be a Microsoft Certified Trainer. The HR person also told me that they overlooked this detail during their initial process, and because of this, they are willing to pay my cancellation charges if I am unable to produce my MCT certification.

In fact, I was a bit taken aback by this phone call as I have never had such an experience before. I have tremendous respect for Microsoft Certifications, and I do have many of them. However, I was never asked in my entire career – or at least after establishing myself in this career – to prove that I am a certified trainer. I politely told the HR person that I do have a MCT certification, but it will take a time for me to find it as I have kept it somewhere safe and I have only one hour to leave for the airport. The HR person again insisted that without the proof of my certification, they will not be allowing me to conduct training.

MCT SQLAuthority News   I am Microsoft Certified Trainer (MCT)

Thanks to my wife Nupur, I could find the certification in few minutes, and additionally, I had proof that I was teaching a 500 level course at the University of Southern California to PhD students. The HR person was glad after receiving the scanned copies of the same and finally gave me the green signal to fly to the client’s office.

This whole experience made me think how important these certifications are to a trainer and consultant. Maybe I should have made a loud announcement earlier, but I think it is still not late: I am MCT and really take pride in being one!

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days

Today’s blog post is not technical as usual. Here, I present a real story, and I also invite you all to share your thoughts or opinions on this post.

I am a professional SQL Server Trainer; I also do consultation in the area of the Performance Tuning and Query Optimizations. In any month, I like the mix of both in my schedule. I prefer to do training for one week, and then commit the next week for some consultation work. Due to the advancement in technology, for most of the consultation works, there is no client location visit or first time visit for understanding the project.

Usually, I conduct high-end training sessions or 400 level training, and these training sessions are very intensive most of the time. Always after completing the training for 5 days straight away at 400 level, I make sure to take out some time to cool down and relax. During this time, I prefer to work on optimization projects. Consultancy is great as it keeps me updated regarding what is going on in the real world. As we all know, all those trainers who have real world experience are always considered to be the best trainers. My learning is immense during my consultations with the real client and while resolving real problems. I share the same with my students the very next week when I go for training sessions. For the same reason, every class is different from the previous ones. An experience trainer would tell you that the class is best if it is driven by Students the way instructor wants!

The best scenario is as described above; but you won’t get the best scenario all the time. I was on road for nearly 25 days out of the last 30 days and involved in doing various SQL Server-related trainings. Here is what I have done in the last 30 days. I have gathered the following details from my expenditure reports, which are maintained by my wife. There are few points related to my personal expenses and few other related to business. I maintain a separate list for each of these expenses, but here I have aggregated them.

Last 30 days –

  • Training 23 days –
    • 4 – two days training classes – 8 days of training
    • 3 – five days training classes – 15 days of training
    • 1 – one day training classes – 2 days of training
  • Flights 18 flights –
    • 8 – Kingfisher
    • 6 – Spicejet
    • 2 – Jet light
    • 2 – Jet connect
  • Stay in different cities
    • Hyderabad – 16 days
    • Chennai – 6 days
    • Bangalore – 2 days
    • Ahmedabad – 6 days (Hometown)
  • Meals – 54 (Averaging less than 2 per day)
    • Room Services – 16 times
    • Training Campuses – 20 times
    • Restaurants – 6 times
    • Home – 12 times
  • Taxi/Cabs – 64 times (Averaging more than 2 per day)
    • Hotel Cab – 34 times
    • Meru Cab – 8 times
    • Easy Cabs – 10 times
    • Auto Rickshaw – 2 times

Looking at the above statistics, I can see that I have eaten less than what I should have, which is not good, and traveled in taxi more than what I should have. Also the temperatures in different cities were very different, not to mention the humidity as well. I missed my family, especially my little girl (9 months). When I was at home, I used to have a proper healthy meal every single day; however, when I was traveling, the food was something I had to compromise on.

I have previously written about my travel experience with different airlines, my opinion is still same about them. Well, I have question to all of you road warriors, how do you manage your health and enthusiasm during situations I am going through. I have couple of time stomach upset as well sour throat. I drink lots of water and do my best to keep up. Any idea?

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization and Performance Tuning Training

Last 3 days to register for the courses. This is one time offer with big discount. The deadline for the course registration is 5th May, 2010.

There are two different courses are offered by Solid Quality Mentors

1) Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning – Pinal Dave
Date: May 12-14, 2010
Price: Rs. 14,000/person for 3 days
Discount Code: ‘SQLAuthority.com’
Effective Price: Rs. 11,000/person for 3 days

2) SharePoint 2010 – Joy Rathnayake
Date: May 10-11, 2010
Price: Rs. 11,000/person for 3 days
Discount Code: ‘SQLAuthority.com’
Effective Price: Rs. 8,000/person for 2 days

Download the complete PDF brochure.

To register, either send an email to IndiaInfo@SolidQ.com or call +91 95940 43399. Feel free to drop me an email at pinal “at” SQLAuthority.com for any additional information and clarification.

Training Venue:
Abridge Solutions, #90/B/C/3/1,
Ganesh GHR & MSY Plaza,
Vittalrao Nagar,
Near Image Hospital,
Madhapur, Hyderabad – 500 081.

Additionally there is special program of SolidQ India Insider. This is only available to first few registrants of the courses only.

Read more details about the course here.

Read my TechEd India 2010 experience here.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – SQL and 10-11 May SharePoint

There were lots of request about providing more details for the blog post through email address specified in the article SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning. Here is the complete brochure of the course.

There are two different courses are offered by Solid Quality Mentors

1) Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning – Pinal Dave
Date: May 12-14, 2010
Price: Rs. 14,000/person for 3 days
Discount Code: ‘SQLAuthority.com
Effective Price: Rs. 11,000/person for 3 days

2) SharePoint 2010 – Joy Rathnayake
Date: May 10-11, 2010
Price: Rs. 11,000/person for 3 days
Discount Code: ‘SQLAuthority.com’
Effective Price: Rs. 8,000/person for 2 days

Download the complete PDF brochure.

Additionally there is special program of SolidQ India Insider. I will provide the details for the same very soon.

Please do send me email if you need any additional details.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning

After successfully delivering many corporate trainings as well as the private training Solid Quality Mentors, India is launching the Public Training in Hyderabad for SQL Server 2008 and SharePoint 2010. This is going to be one of the most unique and one-of-a-kind events in India where Solid Quality Mentors are offering public classes. I will be leading the training on Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning. This intensive, 3-day course intends to give attendees an in-depth look at Query Optimization and Performance Tuning in SQL Server 2005 and 2008. Designed to prepare SQL Server developers and administrators for a transition into SQL Server 2005 or 2008, the course covers the best practices for a variety of essential tasks in order to maximize the performance. At the end of the course, there would be daily discussions about your real-world problems and find appropriate solutions.

Note: Scroll down for course fees, discount, dates and location. Do not forget to take advantage of Discount code ‘SQLAuthority‘.

The training premises are very well-equipped as they will be having 1:1 computers. Every participant will be provided with printed course materials. I will pick up your entire lunch tab and we will have lots of SQL talk together. The best participant will receive a special gift at the end of the course.

Even though the quality of the material to be delivered together with the course will be of extremely high standard, the course fees are set at a very moderate rate.

The fee for the course is INR 14,000/person for the whole 3-day convention. At the rate of 1 USD = 44 INR, this fee converts to less than USD 300. At this rate, it is totally possible to fly from anywhere from the world to India and take the training and still save handsome pocket money. It would be even better if you register using the discount code “SQLAuthority“, for you will instantly get an INR 3000 discount, reducing the total cost of the training to INR 11,000/person for whole 3 days course. This is a onetime offer and will not be available in the future. Please note that there will be a 10.3% service tax on course fees.

To register, either send an email to IndiaInfo@SolidQ.com or call +91 95940 43399. Feel free to drop me an email at pinal “at” SQLAuthority.com for any additional information and clarification.

Training Date and Time: May 12-14, 2010 10 AM- 6 PM.
Training Venue:
Abridge Solutions, #90/B/C/3/1,
Ganesh GHR & MSY Plaza,
Vittalrao Nagar,
Near Image Hospital,
Madhapur, Hyderabad – 500 081.

The details of the course is as listed below.

Day 1 : Strengthen the basics along with SQL Server 2005/2008 New Features

Module 01: Subqueries, Ranking Functions, Joins and Set Operations
Module 02: Table Expressions
Module 03: TOP and APPLY
Module 04: SQL Server 2008 Enhancements

Day 2: Query Optimization & Performance Tuning 1

Module 05: Logical Query Processing
Module 06: Query Tuning
Module 07:  Introduction to the Query Processor
Module 08:  Review of common query coding which causes poor performance

Day 3: Query Optimization & Performance Tuning 2

Module 09:  SQL Server Indexing and index maintenance
Module 10:  Plan Guides, query hints, UDFs, and Computed Columns
Module 11:  Understanding SQL Server Execution Plans
Module 12: Real World Index and Optimization Tips

Public Training 001 HYD Page 01 SQLAuthority News   Public Training Classes In Hyderabad 12 14 May   Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning

Download the complete PDF brochure.

We are also going to have SharePoint 2010 training by Joy Rathnayake on 10-11 May. All the details for discount applies to the same as well.

Reference : Pinal Dave (http://blog.SQLAuthority.com)