SQL SERVER – TechEd India 2013 Sessions and Relevent Pluralsight Courses

I am presenting at TechEd India 2013 two SQL Server session. You can read about my session in this blog post.

Yesterday I presented on topic SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions. Today I will be presenting on the subject Indexes – The Unsung Hero. If you are at TechEd India you must show up in my session – we will have fun talking about Indexes and performance tuning together. You can read about various details about the session over here.

However, if you are not at TechEd India 2013 and still want to know what I am going to cover in the session here is something you can do it. You can watch the following two of my Pluralsight courses which absolutely covers what I am going to talk about in TechEd India 2013.

SQL Server Performance: Introduction to Query Tuning 

SQL Server performance tuning is an art to master – for developers and DBAs alike. This course takes a systematic approach to planning, analyzing, debugging and troubleshooting common query-related performance problems. This includes an introduction to understanding execution plans inside SQL Server.

In this almost four hour course we cover following important concepts.

  • Introduction 10:22
  • Execution Plan Basics 45:59
  • Essential Indexing Techniques 20:19
  • Query Design for Performance 50:16
  • Performance Tuning Tools 01:15:14
  • Tips and Tricks 25:53
  • Checklist: Performance Tuning 07:13

The duration of each module is mentioned besides the name of the module.

SQL Server Performance: Indexing Basics

This course teaches you how to master the art of performance tuning SQL Server by better understanding indexes.

In this almost two hour course we cover following important concepts.

  • Introduction 02:03
  • Fundamentals of Indexing 22:21
  • Practical Indexing Implementation Techniques 37:25
  • Index Maintenance 16:33
  • Introduction to ColumnstoreIndex 08:06
  • Indexing Practical Performance Tips and Tricks 24:56
  • Checklist : Index and Performance 07:29

The duration of each module is mentioned besides the name of the module. You will have to login to watch above courses. 

So if you are going to miss my session at TechEd India, you still have a chance to catch up on what I am going to present by watching the Pluralsight courses listed above.

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

About these ads

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 – Introduction to ColdFusion – Video Tutorial on Pluralsight

I recently released a Introduction to ColdFusion video course on Pluralsight. The course is very well received and I have received a quite a lot of good feedback about it. However, one of the questions keeps on showing up in my email box is that users had no idea that I have worked with programming language ColdFusion and I am still a hands-on expert on this subject. In response to the most asked question – I have decided to write this blog post where I explain -

History of Pinal Dave and ColdFusion

Everybody starts their learning from somewhere. I started in my early career doing a lot of different things. It is hard to forget what someone learns during their early career. When I was in college, I have worked 9 months at Juice (Smoothies) center. I still remember every single recipe of the juices. In my current trip to USA, I have surprised the Juice Maker (I do not know the technical word for anyone who prepares the juice – for coffee I know it is Barista), with my knowledge of the juice recipes.

History – ColdFusion and I

When I started my career in 2004, I was not the database developer. The matter of the fact, I was not allowed to take courses of Database in my graduate study stating the reason that I do not have all the prerequisites to take the database courses. The pre-requisite to take database course was the course called “Introduction to Programming”.  As I was electrical engineering student, I did not take any programming courses and hence no database courses. When I graduated I got very first opportunity to work as a System Administrator. The word system administrator is very nice as I was actually just doing installation of Windows on the machine. One month in the job, I learned that besides Windows, I have to learn to install ColdFusion to the system as the shop where I worked was using the programming language ColdFusion.

History – ColdFusion Books and Cleaning Week

I always felt the name ColdFusion is very exotic as it sounds like nuclear processes. During annual “tidy up” week, where every desk owner had to clean up and remove useless stuff from the desk, there were many ColdFusion books of the earlier version in the garbage area. Out of curiosity, I picked up all the books and brought home. Few books were in the very shape and I had to process them properly using them.

History – Beginning ColdFusion

Now I had a total of 8 ColdFusion books of earlier versions. I installed ColdFusion on my machine and started to practice it. It was indeed fun language and I picked up quite a lot every day. Later in the office whenever I started to have free time, I started to practice various tricks and tips of ColdFusion. Very quickly I had moved from beginner to advanced beginner stage. Our organization has grown and we had few freezers in the organization. Now the situation was a bit changed, they were beginner and I was advanced beginner. Whenever Freshers faced any issue with ColdFusion they started to ask me a question . I loved it, it was a great pleasure for me to help them and gradually I started to spend more and more time helping people learn ColdFusion.

History – ColdFusion Certification and India Trip

During this period of the time, I was working in the USA. It had been almost 2 years since I visited India. It costed around USD 1000 to visit India in the year 2004. During this year, our organization had announced that whoever, who will pass the ColdFusion exam they will get USD 3000 as a salary increase. Remember this is salary increase and not one time bonus. It was quite a big deal at that time. I decided to take the ColdFusion certification exam and if I pass I decided to use the money to travel to India.

I passed the ColdFusion exam with Advanced status in very first attempt and visited India within 3 months from the time from the award money which I received as a part of my salary.

This is how my journey with ColdFusion started. 

Present – ColdFusion and Present Day

I am big fan of ColdFusion Technology – it is very easy to learn and it helps build the application at a rapid pace. Adobe has recently released its latest version 10. When I saw that Adobe has released the latest version and the next version is in the pipeline I look around for any books or tutorial and very quickly found out that there is not much educational material available for the latest version. There are many quality books on version 9, but not the latest version 10.

I have been keeping myself updated with this latest technology and have been helping users world-wide when they face issues with the technology. Later I decided to build a video tutorial which gives the user’s fundamentals of the language.

Now – Introduction to ColdFusion – Video Tutorial

I have build an over 2 hours of video on ColdFusion Programming Technology. I explained in detail how ColdFusion works and how quickly you can get going with ColdFusion Technology. If you are interested in ColdFusion technology, I suggest that you check out this video course. If you are not into ColdFusion, this may be still interesting course to go over. I have few free access code to watch the course. If you are interested in watching this course, I suggest you send me an email.

Here is the outline of the course. This is just a basic course to get users going on this subject. There may be advanced courses in the future where it covers more advanced concepts.

  • Introduction
  • Introduction to ColdFusion Markup Language
  • Conditional Processing with CFML
  • SQL Operations with CFML
  • Building First Data Driven Pages
  • Summary and Resources

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