SQLAuthority News – Presented Technical Session at DevReach 2013, Sofia, Bulgaria – Oct 1, 2013

Earlier this month, I had a fantastic time presenting at DevReach 2013, in Sofia, Bulgaria on Oct 1, 2013. DevReach strives to be the premier developer conference in Central and Eastern Europe. It is organized annually in Sofia, Bulgaria. The 8th edition of the conference is moving to a new and bigger venue: Sofia Event Center.

In my career, I have presented over 9 different countries (India, USA, Canada, Singapore, Hong Kong, Malaysia, Sri Lanka, Nepal, Thailand), this was the first time for me to present in Europe. DevReach was perfect places to start my journey in Europe as an evangelist. The event was one of the most organized event I have ever come across in my life. The DevRech organization team had perfected every minute detail of the event to perfection. After the event was over I had the opportunity to see Sofia for one day.

I presented with one of my most favorite Database Worst Practices Session.

Pinal presenting at DevReach 2013, Sofia, Bulgaria

DevReach 2013

DevReach 2013

DevReach 2013

Pinal presenting at DevReach 2013, Sofia, Bulgaria

Pinal presenting at DevReach 2013, Sofia, Bulgaria

Pinal Dave and Stephen Forte at Pluralsight Booth at DevReach 2013, Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Session Title: Secrets of SQL Server: Database Worst Practices

Abstract: “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.

Thanks to Team Telerik for making this one of the best event in my life.

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

About these ads

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 (http://blog.sqlauthority.com)

SQLAuthority News – Women in SQL – Youngest SQL Speaker – Bangalore SQL User Group Event on April 20, 2013

It was a great day today as at a SQL Bangalore User Group we had an event “Women in SQL” day. This event was one of the milestone event as in India there was no UG in my knowledge had done an event where we appreciated “Women Power”. We had a very strong line up of the speakers and around 100+ people were there to appreciate the knowledge and presentation.

Shaivi Dave and Pinal Dave

SQL Bangalore is the most active SQL User Group in Bangalore and we have a vibrant and active community here. Here is the Facebook page where we are extremely active and here is the official website. Here was the agenda of the event. A big thank you to Pluralsight for offering USD 500 worth annual plus subscription to one of the winners of the event.

Shaivi Dave and Pinal Dave

  • Introduction to SSDT by Deepthi Anantharam – Microsoft
  • Usage of SQL Server 2012 express LocalDB by Chaitra Nagaraj – MVP ASP.NET
  • Working with SQL Server Maintenance Plans by Prabhjot and Shraddha – Microsoft
  • Migrating from Reporting Services 2008 to 2012 by Jaishree Karira (Independent Consultant)

Excellent participation of Technology Enthusiast

One of the surprise element which organizers were discussing ways to bring in the younger SQL Speaker to the stage and deliver some wisdom. We looked around and finally found a speaker who can talk a bit about SQL Server. The speaker we found was only 3 years and 7 months old and she was familiar with big data, SQL Server and basic syntax of the SQL Server. She also owns SQL Queries Books and learns SQL from Pluralsight. If you have not yet figured out by my narration she is my daughter – Shaivi Dave.

Women Power

It was indeed a matter of a proud for me as my own daughter was standing with me on stage and talking brief words on SQL Server in front of 100+ technology enthusiast with confidence. It was her debut stage appearance and I believe there will be many more in future. At this young age she likes to do everything what a young kid like to do but have a deep interest in SQL and Big Data. Here is a quick video which we had recorded during last month.

Shaivi Dave and Pinal Dave

Here are few of the photographs of the event.

Pluralsight Raffle Winner with all the rockstar speakers

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

SQLAuthority News – Excellent Experience at TechEd India 2013 Bangalore and Pune – Photo Journey

TechEd is the premier event from Microsoft and it is always pleasure to be part of the TechEd. This year I attended my fifth TechEd and I had presented at this event 4th time in the row. Presenting at TechEd is fun as there is a totally different level of pressure when presenting at this event. This year TechEd India was in two cities and it was double the fun.

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

TechEd Bangalore was on 18-19 March, 2013 and TechEd Pune was on March 25-26, 2013. I had presented 2 sessions at both the cities, total 4 presentation in TechEd India 2013.

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

Here is the title and abstract of the sessions I presented.

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions

Audience at TechEd India 2013

Audience at TechEd India 2013

Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. The truth is that art has evolved with the time and there are more tools and techniques to overcome ancient troublesome scenarios. There three major resource when bottlenecked creates performance problem: CPU, IO, and Memory. In this session we will focus on High CPU scenarios detection and their resolutions. If time permits we will cover other performance related tips and tricks. At the end of the session attendee will have clear ideas and action items regarding what to do in when facing any of the above resource intensive scenarios.

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

SQL Server Indexes – The Unsung Hero

Audience at TechEd India 2013

Audience at TechEd India 2013

Pluralsight Team Present at TechEd India 2013

Pluralsight Team Present at TechEd India 2013

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 Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Pluralsight Famiy - Pinal, Nupur, Shaivi and Aaron Skonnard

Pluralsight Famiy – Pinal, Nupur, Shaivi and Aaron Skonnard

There are three major reasons I like to go to any events – 1) Community 2) Education 3) Friends. Just like every year I had a great time attending this year’s TechEd India 2013 event and I was able to meet many of my friends and engage with the community at large. I hope you enjoy the list this photo journey.

SQL Friends - Vinod, Balmukund and Pinal

SQL Friends – Vinod, Balmukund and Pinal

SQL Friends - Vinod, Pinal and Deepthi

SQL Friends – Vinod, Pinal and Deepthi

Additionally, my employer Pluralsight had a booth in the exhibition hall and I had a great time standing at the booth and engaging with community. Thanks to everyone who attended my session as well stopped by Pluralsight booth. It was a great event and I had a great time.

SQLAuthority Family - Pinal, Shaivi and Nupur

SQLAuthority Family – Pinal, Shaivi and Nupur

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

SQLAuthority News – Excellent Learning Experience at SQLskills Immersion Events

As many of you know, I attended the Immersion Event at SQLskills learning center in early Feb. I consider myself a SQL professional, but there is no age limit for being a student. One can learn forever, there is always something new to pick up – particularly when you go to a SQLskills event. They are going to teach you something fantastic, something you didn’t know before. It is quite possible to know a lot about a concept, but when we learn about the right ways and wrong ways to do things, and see all the mistakes we made without knowing it, we will learn how to do our jobs better.

The quality of learning at a SQLskills event is amazing. The instructors for Immersion 1 were Paul and Kimberly, and for Immersion 2 there was Paul, Kimberly, Jonathan and Joseph. They take turns teaching, and at every interval there is a new instructor with a new style and new material. It is both stimulating and relaxing, because you are constantly learning, constantly challenged, and there is a new instructor always coming up next. You never get bored. It was also highly interactive with the audience as well.

At both Immersions, questions are encouraged, and the instructors are not shy about answering any and all questions. They encourage feedback and engage with the students. There is always plenty of time allowed for questions and answers, so the sessions are not rushed. The instructor comes at breakfast and stays the whole day, even through lunch. They make sure everyone has had a chance to ask questions and get answers, and they don’t leave the room until the job is done.

The attention to detail is amazing. Each session is right on time, nothing is delayed, nothing is late, there are frequent breaks and meals are right on time. You are totally immersed in learning. They even pay special attention to dietary restrictions. For example, I am a vegetarian and they always made sure I was provided with the correct meals and that those around me with other dietary requirements were also served probably. I was especially a big fan of the desserts, which were served every day at 4 o’clock. They were served closer to dinner time because lunches were so filling no one had room for desert! There were also plenty of drinks, munchies, and coffee available at all times, so that if your stomach growling was getting in the way of your learning, you didn’t have to worry, there was a snack available.

Immersion Event Completion Certification

The best part was that the instructors never tried to hide their information. Sometimes at training events the trainer is reluctant to share slides or give handouts. However, at SQLskills, every slide, demo and diagram were delivered to the students. Before you leave you are sent an email with all the details. I had a great time, those 15 days were tremendous. I will never forget them. If you love SQL you need to attend an event at least once – you can’t afford NOT to.

Additionally, if you are a Pluralsight subscriber, you can also watch the SQL courses authored by SQLskills trainers.

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

SQLAuthority News – Truly Amazing Experience at Pluralsight Author Summit February 2013

February was very good for me because I got to attend PluralSight’s Author Summit. The Author Summit was held in Salt Lake City, Utah and was open to all PluralSight’s authors.

Pluralsight Authors

Most of the authors attended the conference, held at the PluralSight headquarters.  It was a three day event that was packed full of various activities.

Dan Wahlin and Pinal Dave

There were lots of things to do all day and every evening.  There were plenty of opportunities to network, meet people, learn, and share common experiences.

Pinal Dave and John Papa

What all the PluralSight authors have in common is that we love to share knowledge.  We were able to share what works, what doesn’t work, what people like to attend, what users read and learn.  We learned a lot from each other.

Aaron Sknonnard explaining Pluralsight Vision for 2013

Even though every PluralSight author is excellent, we can learn something from each person’s particular talent’s, like how to present, how to make videos better. There were many tips about how to make the sound in your videos better.  It was all very interesting to learn, especially about how to make our interactive courses.

Lynn Langit, Pinal Dave and Michelle

The evenings were also fantastic, with lots of opportunities to network and delicious dinners.

Julie Lerman and Pinal Dave

The PluralSight management team was available to network, talk with the authors, and engage with everyone. I got to talk to each of them, and I learned from them all.  They also presented about the future of PluralSight, where it is going, how authors can be part of their success – to share the vision, and succeed together.

Aaron Skonnard and Pinal Dave at Snow Basin

The last day was especially fantastic, because we spent it at a ski resort.  I could go on and on about the Author Summit, but the best recap is probably the photographs.  I had a great time with each of the PluralSight authors, and am definitely looking forward to next year’s Author Summit.

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

SQLAuthority News – Presenting at Sarasota IT Pro Camp, Florida on February 16, 2013

I am traveling the entire month of February 2013 in USA. First 18 days I am Florida and later part I am heading to another part of the country. When I am in India, every weekend I make a point to attend one of the User Group Meeting in the city. However, the same becomes a bit difficult when I am traveling across the globe. Well, it does not matter where I am and what position I am – if there is a community event, I am going to be there.

Tomorrow on February 16, 2013 Saturday, I am going to present at Sarasota IT Pro Camp, Florida. Special thanks to Jose Chinchilla (Twitter|Blog) for making everything possible for the event. Here are the details about the event:

Location:
Keiser University
6151 Lake Osprey Drive
Sarasota, FL 34240

Date & Time:
9:00 AM February 16, 2013 Saturday

Session Details:
Tips and Tricks for Blazing Fast SQL Server Performance
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. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Hope to see you there soon!

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