My First Timer Experience at PASS

With the 50 days to One DMV a Day series, I have completed my first PASS Summit journey today. Well the series still continues. I had been bragging about a PASS experience blog post since last week. I had been saving all the excitement till I end the Summit before I share anything. So here is a brief journey of my last week.

It all started with the Emirates Business Class experience. The Mercedes Benz pickup, the Business lounge, the actual in-flight business class experience. And to add to all of this a blog that I posted while I was in the flight. That’s just the beginning to the whole week. And yes, we should be afraid of polar ice caps melting.

Polar Icecaps

I landed in Seattle for the first time. The place where the company which created the wonderful Database product called SQL Server, has its strong roots. It was Sunday afternoon and the flight landed a couple of hours late than scheduled time. Again a limo pickup to drop off at the hotel, I loved it. And you know what I loved more? The view from my room. Off course, I never enjoyed it in the next five days.


Day 1 – Monday, 3rd Nov:

I meet one of the SQL Rock stars, Brent Ozar. I attended his class “How to make your Apps Faster” in the Big Picture Theatre. It was completely different experience listening to the whole BrentOzar Unlimited group live. BrentJeremiah, Kendra and Doug were best at what they do. You will be even more amazed to believe that when you hear them live.

PassExp Brent Ozar

Day 2 – Tuesday, 4th Nov:

I couldn’t not go to the second day of the Brent’s class. I have chosen to get the knowledge out from the guys who does it the best way. Tim Chapman, Senior PFE and Denzil Riberio, Principal PFE from Microsoft. Complete 8 hours of their session reminded me of my ramp-up sessions I had when I joined Microsoft.


After the pre-con session it was time for the first timers’ orientation. A round robin introduction to few more first timers was fun. And now comes the Welcome reception. To know what I did, just see the below pics. Paul Randal, Kimberley Tripp, Kelen Delaney, Sean and Jen McCown, Tim Radney are few whom I captured. If only my battery did not die.

Day 1

Day 3, 4 and 5 – Wednesday, Thursday and Friday – 5th, 6th and 7th Nov:

Yes, I cannot say what I did different on all the three days. The first day I walk in and guess who I meet in the hallway? Bob Ward and Ajay Jagannath. Bob recognizes me and I can’t say how overwhelmed I was. It all started well and It was more like a single day with few power naps. I don’t know when I slept and when I was in a session. In between it was all about learning the tools and innovation in databases. Meeting people, networking, sharing solutions and ideas. Few more glimpses from what I have been doing.

Summit days

One famous thought which few of my friends used to discuss. What if we are all single threaded programs with lot of context switching of emotions running in a zillion core processor system? Awesome thought right? I was doing a lot of context switching since the last 3 three days and it’s time for me to go into sleep mode for the weekend.


Follow me on Twitter
Follow me on FaceBook
Connect with me on Linked In

Blogging in the sky – Emirates Business Class Experience

Hi friends. And yes as the title suggests, I am blogging at an altitude of 10,300 m and at a speed of 910 kmph. And I am writing this under the lights of stars inside the flight. Welcome to the Emirates business class experience. If you have followed my Tweet and posts on LinkedIn and Facebook you would know where I am travelling.

Blogging in the sky Blogging in the sky

If you haven’t already known, I am going to PASS Summit 2014. This is my first time to PASS Summit. For that matter I never attended a PASS event. So what are my plans for the next week? I am not going to stop the One DMV a Day series for sure. No matter where I am and what I am doing, I will make sure to get the daily dose to all the SQL geeks.

Well I am in travel for next 20 hours. Thanks to WordPress, I have scheduled the next DMV blog for 9:30 AM IST. I will land in Seattle at 12:00 noon PST on 2nd Nov. So if you are around for PASS or near Seattle, just drop a word and I will get connected with you.

For the next whole week I will be talking, breathing, learning and living SQL Server. Let’s spread the knowledge of SQL Server. Throughout the week I will be spending at various events of SQL PASS. They range from SQL Run, pre-con sessions, karaoke, networking dinner, table top games all with my fellow SQL folks around the world.

Finally, I want to convey my Thanks to my company who has sent me to such a wonderful event of SQL Server.

Vice President

Follow me on Twitter
Follow me on FaceBook
Connect with me on Linked In

My journey with SQL Server

Today is a special day for me as the news came out last night. And I thank SQL Server Geeks for providing such a great platform. This has encouraged me to write blogs, speak at the in-person events. The enthusiasm continues with the news like below.

SQL Server Geeks is made up of great people with their passion towards the great product. They are always ready to share their knowledge and make the SQL community bigger and wider. Thank you all who are the part of this great community. And special thanks to the core team and Amit Bansal for making SQL Server Geeks such a great platform.

My journey with SQL Server

In this post I wanted to tell the tale of my journey with SQL Server and thank every individual who helped me to be what I am today. In 2007 August I got placed in a company when I was in college. When I completed college I was lucky enough to join Sierra Atlantic before my results were out. I, Aditya Badramraju and Kanchan Bharati were invited to join for an immediate requirement to start a new SQL DBA team. Thanks to Sreedhar Kantae for selecting us. He was a great manager and his first words when we joined were “Love your job. Not your company.” Companies give you opportunities but as long as you love your job and respect it opportunities keep coming.

After two years of learning SQL Server with great exposure and freedom to learn what we want my journey ended with Sierra Atlantic. I thank my next manager in Sierra Atlantic, Chiranjeevi Galla. The SQL guru who thought us most basics of SQL Server, Ragesh Gadeela and our mentor, Phaneendra Annadanam. And even though we worked together for a short time Sudiendra Suddautam was the one who thought us how to work in a corporate world.

In 2010 December I quitted Sierra Atlantic and in 2011 January I joined the dream company for almost every SQL enthusiast. Yes, I joined Microsoft GTSC. This division is well known as PSS team, CSS team, CAT team, etc. to the outside world. After working 2 years I got almost two months training on SQL Server core concepts in Microsoft. I was amazed to know that I hardly knew anything about SLQ Server till then. It’s a whole new level of troubleshooting at Microsoft. My journey was very short with Microsoft. I would thank all the great heads at MS and special thanks to my technical lead, Pradeep M M and team manager Pranav Soral.

I left Microsoft in Oct 2011 and joined Arthur J Gallagher. AJG was my client when I was working with Sierra Atlantic. I was hired to start up a new team to do what we were doing in Sierra Atlantic. I got married after I joined this company. It was great working for this company. I got to explore the ETL and DW world here. Their systems handle large insurance data and very time critical. I learnt a lot on automation, monitoring and applied my MS knowledge in their Data Centre migration project. Again it would not have been a great work if it was not for my manager Ananda Kumar. I also would like to thank Ram Bheemarasetti, Vijay Balan and Philip Irby for creating such a wonderful working culture around.

Since last two years from Dec 2012 I am working for S&P Capital IQ. My current employer and a great knowledge center. I felt the knowledge bank here in my interview. The best minds on SQL Server and other data and storage technologies are here. I enjoy working with great minds like Lakshmana Kothapalli, AdithyaKalyan Sundaragiri, Saradhi Yelmella and many more. If I list out all names it would be a book to read. And I enjoy working with my dear friend and an SQL freak Aditya Badramraju. He and I started our career at Sierra Atlantic learnt a lot on different paths and now working together at S&P Capital IQ.

The big part of my journey is when I got introduced to SQL Server Geeks. I was with AJG and met Sarabpreet for the first time at the September 2012 SQL Server Day event. I conveyed my interest in blogging. I got my blog space in January 2013 and started blogging with SQLServerGeeks since then. Rest of the story can be found in my last post. Today I am what I am due to the help and encouragement of all the people I have met through my career. And a SPECIAL THANKS to the SQL community.

And a last snippet for the post. I got to spend a day with Amit Bansal on 4th October. We attanded the Bob Wards event of SQL Talks together. Later in the evening we had high tea and evening snacks at his place. Thanks to the wonderful host, Amit Bansal and family.

Amit Bansal

Have a nice day,

Manohar Punna
Vice President
SQL Server Geeks

Follow me on Twitter
Follow me on FaceBook
Connect with me on Linked In

One DMV a Day – 31 Days and it continues

Hello friends. I generally used to start all my blogs with “Hello Geeks” and it sounds different writing my experiences and starting them with “Hello friends”. Change is good and the only thing constant in this world. So it is always good to do something different. And there is a popular question on self-realization on living life. “When is the last time you did something for the first time in your life?” Well for me I have been doing many new things for the first time since last few months.

One of them is to start my One DMV a Day blog series on SQL Server Geeks. I have been an author on SQL Server Geeks since January 2013 and have been very infrequent in writing blogs. In fact I used to blog once in 2 months. Since January 2013 I have blogged only 12 blogs till Sep 2014. And not even single blog since March 2014. We got the SQL Server Geeks site revamped and the change ignited something in me.

The new site is so welcoming for me to start with a series of blogs. And as I started writing it has become a routine now. Today I have reached the milestone very few have achieved by writing a series with daily frequency. 31 DAYS. Yes, I have written more blogs in last month than I have ever written since I started blogging.

I wanted to put up this blog so that I can encourage my friends who are interested to give something back to the SQL Community. All it takes is dedication and time management. As it looks the blogs may take 10-15 min to skim through and a good 30 min – 1 hour to try the demos in them. But to put up such content for any blogger would take at least 2-3 hours at the bare minimum. This includes the content preparation, research, editing, formatting, posting, etc. This is not an easy job when you do it daily.

To write up a deep technical blog the efforts put into the research and time spent will be more than few days in some cases. The fuel which keeps a blogger going is the encouragement from the community. The acknowledgement from the readers who get benefitted one or other way from the blog.

The happiest day for me would be when I receive an advice on my blog. That shows experts are reading my blog. We are working as a community to give back the knowledge we have. A learning curve is built on constructive feedback. Advices like that are always welcome as it increases the scope of my learning. This in turn helps me provide better content for the readers.

Finally I would like to conclude by thanking the core team of SQL Server Geeks and Amit Bansal for encouraging us bloggers to do what we are doing. And a big THANK YOU to the SQL community which has given so much to us and made us what we are today.

P.S: This is not the end to my DMV series. It will still continue…


Follow me on Twitter
Follow me on FaceBook
Connect with me on Linked In


A day with SQL Gurus and a Legend

Welcome to This is my first post on MY site. I will start with a timeline blog related to my passion, SQL Server. On October 4th, 2014 in Bangalore there was session planned on SQL Server, SQL Talks. The event was hosted by the SQL Bangalore user group at Microsoft, Signature building, Embassy Golf Links, Domlur. The most exciting factor which got my interest was the show stopper of this show. None other than the legend, known for his deep SQL sessions, Bob Ward.

It was exciting to know that Bob Ward is in India and delivering a session. To add to the excitement there were sessions from Arvind Shyamsunder (the first MCM in India), Tejas Shas and Pradeep.M.M on Performance troubleshooting, Kane Conway on Power BI and predictive analysis and Balmukund and Vinod on SSMS Tips and Tricks. I would not miss that for anything in the world. It is a long weekend. The buses are jam packed. Luckily I got the tickets and booked the hotel. I was afraid of anything that may go wrong for me to attend this event.

As I thought the first hurdle started the day before the event. I cannot make an early checkin without paying an additional days charges. So I called up few of my friends and everyone is on vacation on the long weekend. Finally I called up Amit Bansal for any suggestions and he asked me to come over. I will write a separate blog on the time I spent with Amit and his great host role. 🙂

So we (I and my wife, a weekend getaway for her 🙂 ) arrive in Bangalore. I and Amit make it on time to the event. The first thing we do entering the conference room is walk straight to Bob and greet him. And the next person I meet is Tejas Shah welcoming with his ever smiling face. We got the best view seats and got ready got the cruise of SQL knowledge from the legend. The first session starts as Bob takes us through the memory lane of SQL Server with all his expertise. Its amazing that a person with that much knowledge can just amaze you with his memory on SQL Memory Architecture. 😉

Bob Ward

The second session was drive through the case scenarios by Tejas Shas and Pradeep.M.M. I go back with these gurus when I worked for Microsoft IGTSC. Pradeep was my Technical Lead and I have taken Tejas’ help on couple of cases when working at Microsoft. It is always good to meet people from past. I revisited my old days with Microsoft and the troubleshooting techniques used there. They talked about few cases that were dealt by Microsoft and the depth of troubleshooting involved. It was a pure learning experience.

PradeepMM Tejas Shah

After lunch we had Arving Shyamsunder to talk about development and few cool features in Visual Studio online. How you can control issues before deploying into production. Working on data model to identify certain code bust and build bust before pushing them to any environments. A lot of takeaways from this sessions and only a man with his experience can deliver such great session and make it look so easy.

Arvind Shyamsunder

It was Bob Ward again and you would never get a thought of post lunch sleep when there is so much excitement. This time Bob tells you what you can do before reaching to Microsoft for help. Yes, he explains the best steps that you can do before you call the support. The demos involve solving issues for high case volume that come to Microsoft. The top ones on the list are Backup Restores, data corruption, Performance issues, Assertion dumps to name few. So the tips are always valuable from the expert and the legend himself.

Bob Ward

We had the next session from Balmukund and Vinod on the simple and efficient tips and tricks with SSMS and few very useful tools like tablediff. And towards the end of the day the energy these experts bring to the attendees is awesome. You will experience only when you listen from them. Fun and learning. 🙂


Kane has his way with Power BI and predictive analysis. A good way to prove our point in many cases as a DBA is to use effective reports with the data we have. Kane’s session is all about that.

Kane Conway

Over all the event was a wonderful time spent with the experts and their knowledge flow. Its our bandwidth to accept the flow of knowledge and use it efficiently. Last but not the least the group which has made this happen… THANK YOU.



Follow me on Twitter
Follow me on FaceBook
Connect with me on Linked In