Vote for my session at SQLBits

Hello friends,

Hope you are enjoying my blogs. After the recent technical ride of One DMV a Day series I have been exploring more ways to get involved with the community. One good news is we are going to start soon with the SQL Server Day events in India. Adding to it I have submitted a session at SQLBits XIV. But for it to get selected I need your vote. Below is the session I submitted.

Deep Dive into Delayed Durability

Submit a session for SQLBits

 

All you need to do is vote for my session on the sessions page. You have to join and login to vote which is FREE. Please vote, even if you are not voting for my session your vote will get the valuable sessions to the conference.

Note: Search with the session name as there are hundreds of sessions and it is hard to scroll the list. 🙂

Thank You,
Manu

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

One DMV a Day – The 80 day sprint

Hello friends,

I have been posting about my experiences till 3 weeks back but had took a break for the last three weeks. I had been trying to find my time to write the blog here but have been holding myself till I finish the 80 day blog series of One DMV a Day. I have a story as I have in every other blog post on this site. 🙂

When the SQL Server Geeks site was revamped in late August I had blogged about SQL Server Replication Log Reader Why and How latency occurs. Then I had started thinking about writing more frequently for SQL Server Geeks. Then my dear friend and the SQL Server Master, Amit Bansal has suggested to start a one day series. It sounded good and I thought of writing a 31 day series. There were many other 30 and 31 day series out on the net/web. So I said to myself, why to limit myself? So I did not know how many I am going to write and just started the series.

The initial days was hard as I was never used to writing blogs so frequently. 1, 2, 3, 5, 10, 15… Then I had been to Bob Ward’s SQL Talks in Bangalore.  It was an encouragement to meet people who know me by my blogs. So I decided to write till I am exhausted of time, energy or DMVs. 🙂

The great moment to attend PASS Summit added to my excitement. I pre-blogged and scheduled all the posts for the one week trip of PASS. This definitely took extra time everyday and a toll on my sleep. I hardly slept and wrote almost 4-5 hours every day after and before my working hours. When I turn back, now I see what did that turn into, THE LONGEST ONE DAY SERIES EVER on any SQL Server topic. Can’t describe more about how I feel.

Now here is the complete list of One DMV a Day series that you can read, review, share and learn.

Day 1 – sys.dm_db_index_physical_stats
Day 2 – sys.dm_db_index_usage_stats
Day 3 – sys.dm_db_missing_index_details
Day 4 – sys.dm_io_cluster_shared_drives
Day 5 – sys.dm_db_index_operational_stats
Day 6 – sys.dm_io_pending_io_requests
Day 7 – sys.dm_io_virtual_file_stats
Day 8 – sys.dm_db_file_space_usage
Day 9 – sys.dm_db_session_space_usage
Day 10 – sys.dm_db_task_space_usage
Day 11 – sys.dm_os_performance_counters
Day 12 – sys.dm_os_cluster_nodes
Day 13 – sys.dm_os_tasks
Day 14 – sys.dm_os_workers
Day 15 – sys.dm_os_threads
Day 16 – sys.dm_os_schedulers
Day 17 – sys.dm_os_wait_stats
Day 18 – sys.dm_os_waiting_tasks
Day 19 – sys.dm_os_process_memory
Day 20 – sys.dm_os_memory_clerks
Day 21 – sys.dm_os_memory_objects
Day 22 – sys.dm_os_memory_pools
Day 23 – sys.dm_os_memory_cache_counters
Day 24 – sys.dm_os_memory_cache_entries
Day 25 – sys.dm_os_memory_cache_hash_tables
Day 26 – sys.dm_os_memory_brokers
Day 27 – sys.dm_os_memory_cache_clock_hands
Day 28 – sys.dm_os_buffer_descriptors
Day 29 – sys.dm_exec_connections
Day 30 – sys.dm_exec_sessions
Day 31 – sys.dm_exec_requests
Day 32 – sys.dm_exec_sql_text
Day 33 – sys.dm_exec_query_plan
Day 34 – sys.dm_exec_text_query_plan
Day 35 – sys.dm_exec_procedure_stats
Day 36 – sys.dm_exec_query_stats
Day 37 – sys.dm_exec_trigger_stats
Day 38 – sys.dm_exec_cursors
Day 39 – sys.dm_exec_background_job_queue
Day 40 – sys.dm_exec_background_job_queue_stats
Day 41 – sys.dm_exec_cached_plans
Day 42 – sys.dm_exec_plan_attributes
Day 43 – sys.dm_exec_cached_plan_dependent_objects
Day 44 – sys.dm_exec_query_memory_grants
Day 45 – sys.dm_exec_resource_semaphores
Day 46 – sys.dm_exec_describe_first_result_set
Day 47 – sys.dm_tran_locks
Day 48 – sys.dm_tran_database_transactions
Day 49 – sys.dm_tran_session_transactions
Day 50 – sys.dm_tran_active_transactions
Day 51 – sys.dm_tran_current_transactions
Day 52 – sys.dm_tran_version_store
Day 53 – sys.dm_tran_top_version_generators
Day 54 – sys.dm_repl_articles
Day 55 – sys.dm_xe_packages
Day 56 – sys.dm_xe_objects
Day 57 – sys.dm_xe_object_columns
Day 58 – sys.dm_xe_map_values
Day 59 – sys.dm_xe_sessions
Day 60 – sys.dm_xe_session_object_columns
Day 61 – sys.dm_xe_session_tragets
Day 62 – sys.dm_xe_session_events
Day 63 – sys.dm_xe_session_event_actions
Day 64 – sys.dm_db_xtp_memory_consumers
Day 65 – sys.dm_db_xtp_transactions
Day 66 – sys.dm_xtp_transaction_stats
Day 67 – sys.dm_db_xtp_checkpoint_files
Day 68 – sys.dm_db_xtp_checkpoint_stats
Day 69 – sys.dm_db_xtp_object_stats
Day 70 – sys.dm_db_xtp_hash_index_stats
Day 71 – sys.dm_db_xtp_merge_requests
Day 72 – sys.dm_xtp_gc_stats
Day 73 – sys.dm_xtp_gc_queue_stats
Day 74 – sys.dm_db_xtp_gc_cycle_stats
Day 75 – sys.dm_db_xtp_table_memory_stats
Day 76 – sys.dm_db_xtp_nonclustered_index_stats
Day 77 – sys.dm_db_xtp_index_stats
Day 78 – Consolidated DMV Scripts – Part 1
Day 79 – Consolidated DMV Scripts – Part 2
Day 80 – Consolidated DMV series – Final Part

Hope you enjoy the series.

Happy Learning
Manu

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

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.

Room

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.

PASS Pass

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.

Regards,
Manu

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.

Regards,
Manu
Vice President

SQLServerGeeks
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…

Regards,
Manu

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

 

A day with SQL Gurus and a Legend

Welcome to ManoharPunna.com. 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. 🙂

Fun

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.

PeopleBehindTheEvent

Regards,
Manu

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