SQL SERVER – #TechEdIn – Presenting Tomorrow on Speed Up! – Parallel Processes and Unparalleled Performance at TechEd India 2012

Performance tuning is always a very hot topic when it is about SQL Server. SQL Server Performance Tuning is a very challenging subject that requires expertise in Database Administration and Database Development. I always have enjoyed talking about SQL Server Performance tuning subject. However, in India, it’s actually the very first time someone is presenting on this interesting subject, so this time I had the biggest challenge to present this session.

Frequently enough, we get these two kind of questions:

  1. How to turn off parallelism as it is reducing performance?
  2. How to turn on parallelism as I want more performance?

The reality is that not everyone knows what exactly is needed by their system. In this session, I have attempted to answer this very question. I’ve decided to provide a balanced view but stay away from theory, which leads us to say “It depends”. The session will have a clear message about this towards its end.

Deck Details

  • Slides: 45+
  • Demos: 7+ Bonus
  • Quiz: 5
  • Images: 10+
  • Session delivery time: 52 Mins + 8 Mins of Q & A

I have presented this session a couple of times to my friends and so far have received good feedback. Oftentimes, when people hear that I am going to present 45 slides, they all say it is too much to cover. However, when I am done with the session the usual reaction is that I truly gave justice to those slides.

Action Item

Here are a few of the action items for all of those who are going to attend this session:

If you want to attend the session, just come early. There’s a good chance that you may not get a seat because right before me, there is a session from SQL Guru Vinod Kumar. He performs a powerful delivery of million concepts in just a little time.

Quiz. I will be asking few questions during the session as well as before the session starts. If you get the correct answer, I will give unique learning material for you. You may not want to miss this learning opportunity at any cosst.

Session Details

Title: Speed Up! – Parallel Processes and Unparalleled Performance (Add to Calendar)

Abstract: “More CPU, More Performance” – A  very common understanding is that usage of multiple CPUs can improve the performance of the query. To get a maximum performance out of any query, one has to master various aspects of the parallel processes. In this deep-dive session, we will explore this complex subject with a very simple interactive demo. Attendees will walk away with proper understanding of CX_PACKET wait types, MAXDOP, parallelism threshold and various other concepts.

Date and Time: March 23, 2012, 12:15 to 13:15

Location: Hotel Lalit Ashok – Kumara Krupa High Grounds, Bengaluru – 560001, Karnataka, India.

Add to Calendar

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

About these ads

SQL SERVER – #TechEdIn – Presenting Tomorrow on SQL Server Misconception and Resolution with Vinod Kumar at TechEd India 2012

I am excited AND nervous at the same time. I am going to present a very interesting topic tomorrow at an SQL Server track in India. This will be my fourth time presenting at TechEd India. So far, I have received so much feedback about this one session. It seems like every single person out there has their own wishes and requests. I am sure that it is going to very challenging experience to satisfy everyone who attends the event through my presentation.

Surprise Element

Here is the good news: I am going to co-present this session with Vinod Kumar, my long time friend and co-worker. We have known each other for almost four years now, but this is the very first time that we are going to present together on the big stage of TechEd.  When there are more than two presenters, the usual trick is to practice the session multiple times and know exactly what each other is going to present and talk about. However, there’s a catch – we decided to make it different this time and have shared nothing to each other regarding what exactly we are going to present. This makes everything extremely interesting as each of us will be as clueless as the audience when other person is going to talk.

Action Item

Here are a few of the action items for all of those who are going to attend this session. Vinod and I will be present at the venue 15 minutes before the session. Do come in early and talk with us. We would be glad to talk with you and see if either of us can accommodate your suggestion in our session. If we do, we will give a surprise gift for you.

As discussed, this session is going to be a unique two-presenter session. You will have chance to take a side with one speaker and stump the other speaker. Come early to decide which speaker you want to cheer during the session.

Quiz and Goodies

By now, you must have figured out that this session is going to be an extremely interactive session. We need your support through your active participation. We will have some really brain-twisting quiz line up just for you. You will have to take part and win surprises from us! Trust me. If you get it right, we will give you something which can help you learn more!

We will have a quiz on Twitter as well. We will ask a question in person and you will be able to participate on Twitter.

10 – Demos

As I said, both of us do not know what each other is going to present, but there are few things which we know very well. We have 10 demos and 6 slides. I think this is going to be an exciting demo marathon. Trust me, you will love it and the taste of this session will be in your mouth till the next TechEd.

Session Details

Title: SQL Server Misconceptions and Resolution – A Practical Perspective (Add to Calendar)

Abstract:

“The earth is flat”! – An ancient common misconception, which has been proven incorrect as we progressed in modern times. In this session, we will see various database misconceptions prevailing and their resolutions with the aid of the demos. In this unique session, the audience will be a part of the conversation and resolution.

Date and Time: March 21, 2012, 15:15 to 16:15

Location:
 Hotel Lalit Ashok – Kumara Krupa High Grounds, Bengaluru – 560001, Karnataka, India.

Add to Calendar

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

SQL SERVER – SQL Server Misconceptions and Resolution – A Practical Perspective – TechEd 2012 India

TechEd India 2012 is just around the corner and I will be presenting there in two different sessions. On the very first day of this event, my presentation will be all about SQL Server Misconceptions and Resolution – A Practical Perspective.

The dictionary tells us that a “misconception” means a view or opinion that is incorrect and is based on faulty thinking or understanding. In SQL Server, there are so many misconceptions. In fact, when I hear some of these misconceptions, I feel like fainting at that very moment! Seriously, at one time, I came across the scenario where instead of using INSERT INTO…SELECT, the developer used CURSOR believing that cursor is faster (duh!). Here is the link the blog post related to this.

Pinal and Vinod in 2009

I have been presenting in TechEd India for last three years. This is my fourth opportunity to present a technical session on SQL Server. Just like the previous years, I decided to present something different. Here is a novelty of this year: I will be presenting this session with Vinod Kumar. Vinod Kumar and I have a great synergy when we work together. So far, we have written one SQL Server Interview Questions and Answers book and 2 video courses: (1) SQL Server Questions and Answers (2) SQL Server Performance: Indexing Basics.

Pinal and Vinod in 2011

When we sat together and started building an outline for this course, we had many options in mind for this tango session. However, we have decided that we will make this session as lively as possible while keeping it natural at the same time. We know our flow and we know our conversation highlight, but we do not know what exactly each of us is going to present. We have decided to challenge each other on stage and push each other’s knowledge to the verge. We promise that the session will be entertaining with lots of SQL Server trivia, tips and tricks.

Here are the challenges that I’ll take on:

  • I will puzzle Vinod with my difficult questions
  • I will present such misconception that Vinod will have no resolution for it.

I need your help.  Will you help me stump Vinod? If yes, come and attend our session and join me to prove that together we are superior (a friendly brain clash, but we must win!).

SQL Server enthusiasts and SQL Server fans are going to have gala time at #TechEdIn as we have a very solid lineup of the speaker and extremely interesting sessions at TechEdIn. Read the complete blog post of Vinod.

Session Details

Title: SQL Server Misconceptions and Resolution – A Practical Perspective (Add to Calendar)

Abstract:

“Earth is flat”! – An ancient common misconception, which has been proven incorrect as we progressed in modern times. In this session we will see various database misconceptions prevailing and their resolution with the aid of the demos. In this unique session audience will be part of the conversation and resolution.

Date and Time: March 21, 2012, 15:15 to 16:15

Location:
 Hotel Lalit Ashok – Kumara Krupa High Grounds, Bengaluru – 560001, Karnataka, India.

Add to Calendar

Please submit your questions in the comments area and I will be for sure discussing them during my session. If I pick your question to discuss during my session, here is your gift I commit right now – SQL Server Interview Questions and Answers Book.

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

SQL SERVER – An Inspiring Personal Story – Movie from The Book – Video Course – SQL Server Questions and Answers – Pluralsight

Nov 3, 2011 – Visit to Grandma

When our SQL Server Interview Questions and Answers book got published I ran to my grandma with a copy of the book for her blessings. Well, just like every grandma, she loves me, her grandson, unconditionally. She is not into the technology domain (obviously), but she loved the book. She read the first few pages where I was mentioned and read about my co-author Vinod Kumar. After reading the introduction she looked at me and said “When I was young we used to read books, now all those good books are converted into the movies, when do you think this book will be converted into a movie?

Silence. A very long silence.

I just could not answer her right away.  As a matter of fact, I went into a deep thought. I never thought that she could actually ask me such question. It may be a very simple question, but I felt that it was very important to me. I was just stunned and speechless. I returned home from my grandma’s place, with her blessings and an interesting thought of a “Movie from the Book”. I just could not get this out of my mind.

Jan 24, 2012 – Movie from Book

I talked to my grandma very often, but since the last conversation my wife called her often and I did not talk to her at all. There was no reason to talk to her maybe because I constantly felt that she is with me. Her blessings were with me. I could not get her question out of my mind, still. I was extremely motivated and inspired from my last conversation with her. I called her early morning on January 24. Her very first questions were how I was doing and how was her great granddaughter. I told her that regarding our last conversation, there is actually a movie which is inspired from the book. Her very first reaction was that she knew this would happen as she was confident that my book would reach milestones. We talked for long hours.

Today – Fast Forward

Well, the book was an inspiration for the course, but the video course was developed using totally different angle. We made sure that we’d take the broader idea from the book but wanted present something unique and novel. Vinod Kumar and I thought about it for a long time. We wanted to decide on the format of our course. We spent hours talking about the course – how we could make it unique and give a different experience to every attendee. We wanted to keep the subject light enough to digest, yet deep enough to satisfy everyone’s learning eagerness. After spending some days and efforts for the preparation of the unique content and exceptional demos, the course has become a reality for us.

SQL Server Questions and Answers

This course is designed to help you have a better understanding on how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works. This course is for anyone who works in SQL Server databases, and basically for those who want to improve their knowledge and understanding of this complex platform.

In this course, each topic starts with a question and ends with an answer which is supplemented with a demo. Every question has an exercise file and a demo associated with it. Additionally, in the very last session, we have covered lots of SSMS tips and tricks. Here are the topics we have covered in this course:

  • Introduction
  • Retrieving IDENTITY value using @@IDENTITY
  • Concepts Related to Identity Values
  • Difference between WHERE and HAVING
  • Order in WHERE clause
  • Concepts Around Temporary Tables and Table Variables
  • Are stored procedures pre-compiled?
  • UNIQUE INDEX and NULLs problem
  • DELETE VS TRUNCATE
  • Locks and Duration of Transactions
  • Nested Transaction and Rollback
  • Understanding Date/Time Datatypes
  • Differences between VARCHAR and NVARCHAR datatypes
  • Precedence of DENY and GRANT security permissions
  • Identify Blocking Process
  • NULLS usage with Dynamic SQL
  • Appendix Tips and Tricks with Tools

Today we are very happy that our course is out. The journey from the book to the Training Course took 80 days and the experience was wonderful. In a future post, I will share the experience of writing book and building the training course.

In the end, we just want to thank YOU, our dear reader, who made this experience possible.

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

SQL SERVER – What is Slowly Changing Dimension – Quiz – Puzzle – 31 of 31

SQL Server Interview Questions and Answers
Print Book Available (207 Pages) | Sample Chapters

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

Reporting and analytics cannot be achieved without a very good data model at the background. And using Analysis services for reporting requirement is always something very common architecture to this. But getting data from relational engine and keeping data for analysis up to date is the challenge. Having these in mind, what is the concept of Slowly Changing Dimension? And what is a Hybrid Slowly Changing Dimension?

Link to participate in SQL Quiz

Notes of Vinod Kumar

Modeling can be a tricky activity. The way to load a SCD  can be achieved interestingly via the SSIS route. Though the basics of SCD can be a larger discussion, tell us more about a thing or two on what you have learned so far in loading SCD.

Notes of Pinal Dave

Let us talk about a product in a shop. Let us assume the product is newly launched. The price of the product is very high and it is put in the ‘newly arrived products’ section. After. a while the book becomes best seller and it is moved to the ‘best seller’ section. As time progresses, the rate of sales of the book declines, leading to it getting moved off the best sellers’ group to the ‘regular items’ section. Eventually, the same book is moved to the bargain section and with a very low price value. Well, this product life process is slow changing. If we consider the price of the book as well as the duration it spent in particular section, it is very much comparable to a slowly changing dimension in SQL Server. Now that you know this simple comparison, the quiz should be easier for you.

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#179-180

Prize

There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

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

SQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 of 31

SQL Server Interview Questions and Answers
Print Book Available (207 Pages) | Sample Chapters

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

As databases volumes become bigger and bigger, the best way to optimize would be to take the huge problem and break it up into smaller chunks. During a large server deployment, a DBA used this advice; he suggested implementing an extensive partitioning for our transaction tables. In line with this, what are the basics of creating, managing and deploying SQL Server partitioning?

Link to participate in SQL Quiz

Notes of Vinod Kumar

There are several options when it comes to using partitioning concepts inside SQL Server. Here’s a hint: choose and explain what SQL Server introduced and what has been enhanced in SQL Server 2008 version.  In relation to this, can you tellm at Aligned Indexes are when it comes to partitioning?

Notes of Pinal Dave

Partitioning is a very old concept, yet it has always been implemented indirectly. I remember durinv my very early career years, we used to create partitioning using the work around. When any table gets very huge and has an enormous amount of data into the table, we used to create new table by means of appending it with _1 or _2 value. After doing that, we created the view on the top of this table and selected the data from it. This way, we had to change a few parts of our code and we had to implement the concept of partitioning right away. Now, in SQL Server, we get the partitioning feature as a native feature, as well as means of getting a cool syntax to populate and remove data.

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#168-170
Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
White Paper – Partitioned Table and Index Strategies Using SQL Server 2008

Prize

There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

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

SQL SERVER – Data Collector Usage – Quiz – Puzzle – 29 of 31

SQL Server Interview Questions and Answers
Print Book Available (207 Pages) | Sample Chapters

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

From Perfmon to SQL Profiler to other third Party tools, there are a good number of performance troubleshooting tools which a DBA can use inside SQL Server. One of the hidden features of most troubleshooting tools is the Data Collector inside SQL Server. What is a Data Collector, anyway? What are the predefined collectors inside SQL Server which can be used?

Link to participate in SQL Quiz

Notes of Vinod Kumar

Data Collector is truly a hidden gem in SQL Server. Data Collector is a great tool to track what is happening inside the SQL Server. Are you using the Data Collector? Have you extended it by any chance? Let us hear your stories and how would you have implemented the same in SQL Server 2005 versions?

Notes of Pinal Dave

Data Collection is our old habit. Isn’t that the very reason why we have reached this far? I think we might have started to count because we wanted to remember how much inventory we have (may be not – but you got the point). Now, collection of the data is not really helpful unless they are arranged, filtered, cleaned up and put together in a nice algorithm. These can make data start talking and reveal its various intelligence. Data Collector is a very important subject, but I often see it not getting the proper exposure as it deserves.

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#144

Prize

There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

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