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,

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

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.


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. Brent,Β Jeremiah, 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