Posts Tagged ‘Events’

GIDS 2014 – 5 Tech session Scheduled April 21st, 2014

Vinod Kumar

It has become a custom for me to talk at this premier event year-on-year and this will be my 5th year partnering with the Great Indian Developer Summit (GIDS 2014) folks. I am excited as ever because we get to meet a different set of audience and the expectations are completely different. I generally get exhausted by end of the day and this year I am super excited as I will be delivering close to 5 different sessions at different timings. If you are attending the event, you don’t want to miss my sessions for sure :) …

If you are wondering where this event happens every single year –

Event Location: J. N. Tata Auditorium
National Science Symposium Complex (NSSC)
Sir C.V.Raman Avenue, Bangalore, India

The complete schedule is published here.

GIDS .NET Day – April 22nd

This day I am doing three sessions.

Time: 10:35 – 11:35

SQL Server Management Studio – Tips and Tricks

If you are a SQL Server developer or DBA there is no way you can hide away from working with SQL Server Management Studio from your daily life. This tool which was introduced with SQL Server 2005 replacing the old Enterprise Manager has come a long way in making productivity of our developers and DBA’s to the next level. In this DEMO ONLY session we will look at this amazing tool and find out how this tool can be used effectively. There are a number of features like Object Explorer, Explorer Details, Template Explorer, Activity Monitor, Solution Explorer, Debugging, Tool bar and command enhancements that go unnoticed. We will look at each of these sections with loads of shortcut keys to play with SQL Server Management Studio. We assure you will go away with atleast 10 new things to do with the tool end of the sessions. 60+ tips in less than 60 mins.

Time: 11:45 – 12:45

Understanding Windows Better Using SysInternals

The Sysinternals utilities are vital tools for any computer professional on the Windows platform. This session focuses primarily on the utilities themselves, deep-diving into as many features as time will allow. Some of the popular utilities include Process Explorer, Process Monitor, Autoruns, VMMaps, PageDefrag, Desktops, Blue Screens and many more. It is humanly impossible to walk through each of these utilities at length with the tons of features loaded onto each one of them. We will take some of these lesser known tools to look at some common scenarios which everyone wants to use to troubleshoot in their daily life. This session will have a lot of demos and will question our very understanding of how Windows, Processes and threads work. Most of the session will dwell on the new and improved Sysinternals tool set. There is loads to learn and learning the basics can never be this much fun.

Time: 14:45 – 15:45

Architecting SQL Server HA and DR Solutions on Windows Azure

In the real life scenarios, SQL Server high-availability (HA) and disaster recovery (DR) solutions are not simply cloud-based, on-premises solutions, internally facing or external solutions. They are mix of a little bit everything. This session is highlighted for blending two state-of-the-art technologies with key learning’s: SQL Server AlwaysOn and Windows Azure. SQL Server AlwaysOn offers better availability, higher ROI and simplicity. With easy integration of SQL Server and Windows Azure technologies, customers can easily increase the efficiency and effectiveness of their solutions. SQL Server and Windows Azure can easily become the best HA & DR offering for customers on different segments for multiple aspects. The session highlights product capabilities, limitations, and trade-offs for various customer needs such as complex HA & DR scenarios. Cloud is the perfect solution to minimize CAPEX, why they are important to customers, how to implement them, and considerations to take. This session covers cloud, on premises and hybrid distributed geography solutions from technical perspective including lessons learned from real world deployments.

GIDS DATA Day – April 25th

This will be a marathon day sorts for me I think and the most anticipated as I will be doing a tango session with my friends.

Time: 14:05 – 14:50

Introduction to Microsoft Power BI

We use office tools in a number of ways and our day job involves in playing around with these tools. In this session we will focus on Microsoft Office Excel 2013 version and look at some of the new features introduced with Excel 2013. At the same time we will also look at some of the tips of using Excel for our daily use. Did you know the visual formatting, PowerPivot, Excel FlashFills introduced inside Excel? Did you know the tricks used for identifying invalid data using Excel as a powerful tool? Did you know the basic shortcuts to use when working with Microsoft Office Excel 2013? All these are interesting yet unexplored features of Excel. We will dwell deep into each of these features and will show how to use them effectively. It is a completely demo filled session with lot of interesting trivia in store for the attendees.

Time: 15:00 – 17:45

Hidden Secrets and Gems of SQL Server We Bet You Never Knew

It really amazes us every time when someone says SQL Server is an easy tool to handle and work with. Microsoft has done an amazing work in making working with complex relational database a breeze for developers and administrators alike. Though it looks like child’s play for some, the realities are far away from this notion. The basics and fundamentals though are simple and uniform across databases, the behaviour and understanding the nuts and bolts of SQL Server is something we need to master over a period of time. With a collective experience of more than 30+ years amongst the speakers on databases, we will try to take a unique tour of various aspects of SQL Server and bring to you life lessons learnt from working with SQL Server. We will share some of the trade secrets of performance, configuration, new features, tuning, behaviours, T-SQL practices, common pitfalls, productivity tips on tools and more.
This is a highly demo filled session for practical use if you are a SQL Server developer or Administrator. The speakers will be able to stump you and give you answers on almost everything inside the Relational database called SQL Server.

Apart from this my good friend Pinal is also doing a number of sessions and a must go if you are interested in some serious fun filled learning. He also wrote a detailed post on his sessions. I will be meeting a number of friends on these two days as many are coming as speakers too at this event. So if you are around at the event – dont forget to say a “Hi“ to me :).

Continue reading...


TechEd India 2013: SQL Server and Architecture March 13th, 2013

Vinod Kumar


This time of the year that I get heads-down to bring some cool demo for TechEd and the exploration never stops. This year TechEd India 2013 happens in two cities – Bangalore and Pune. This time next week the Bangalore event would have got over and I am sure we will be in exhausted state to relive the past two days and staring at Pune to execute the same. There is always extra care, attention and preparation that goes behind for every TechEd. This year is no different. I am also excited because this will mark my 10th Year of TechEd on stage. The memories of doing this in 2003 is still fresh and the excitement never dies every single year.

The twitter hashtag to follow for this year TechEd is: #TechEdIn.

What is special about TechEd?

If you ask me there are a number of reasons to be at TechEd personally. My drivers for you will be:

  1. It is a place to socialize and at the same time feel alone. If you attend the tech sessions, you might feel there is so much more to learn and this sometimes alienates people in a good way. Get motivated and get to see what the future of technology is.
  2. Two days of pure learning and no work is something we will never get :). I know it is not a nice thing to say but I couldn’t resist from mentioning. Let me reiterate, it is not vacation time but learning time.
  3. It is a hub for networking. This is one of the key and most important reason to attend. Meet peers, speakers from Redmond, local speakers and many more.
  4. With close to 6+ tracks, HOLs – the choice of sessions are too many. It is always fun !!!
  5. It is also a place to make business contacts, find mentors, make new friends and all these will help you to make your future.

SQL Server – Security Session

For the past two years I have talked around Security in SQL Server. Each year I try to bring some unique perspective and what I find useful from a security point of view. This year it will be new additions to Security with SQL Server 2012. You will get to see:

  1. What has changed in Security
  2. How to use User Defined Roles and Default schema
  3. How to keep DBA out of database (access)
  4. Enhancements to Auditing
  5. Audit filtering and Audit resilience
  6. Contained Databases basics
  7. Using Logon Triggers with Contained Databases
  8. SQL Server 2012 – Service account changes
  9. and if time permits few more demo’s are available …

So don’t miss the action. I have infact given away what to expect out of my 1 hour session. Lots of demo and lots of detailing on how to use SQL Server security effectively.

SQL Server – Transaction Logs Session

Going back to the basics is important. So every TechEd there is one topic that I talk about which is about going back to basics. One question that I get back from customers almost every other session is around Transaction Logs functioning. I think it will be great to have a session around that.

  1. What is Transaction Logs? Why do we need them?
  2. Understanding what VLF’s are
  3. Creation of Logs and the basics
  4. Cyclic Logs and how they function
  5. What is written to Logs and how are they written
  6. What happens when Page Split happens with Logs
  7. How does minimal Logging work and what should we know
  8. Finally if time permits, how does recovery work …

This is just a teaser to what is in store for the session. We have many more interesting concepts to discuss and learn during the session – so don’t miss out.

Architecture Track – Evaluating Availability Options

This is going to be an interesting topic. As part of MTC I discuss about scale out to almost every single customer. Most of the times the discussion boils down to when to use what. We have solutions from Log shipping, Mirroring, Clustering, Replication and now with SQL Server 2012 – AlwaysOn. So the session is around:

  1. Why Scale out? Cant I just scale up?
  2. What changes do I need to do in my application?
  3. When to use what technology – Pre SQL 2012
  4. With SQL 2012 – What is AlwaysOn
  5. What are the 12+ different ways to deploy AlwaysOn for my environment?
  6. How do I decide and what will be the RPO and RTO for each?

This is a pure whiteboarding diagram based discussion. You will learn the theory and the possibilities when working with SQL Server 2012.


As I said, if you are in Bangalore or Pune – don’t forget to attend my session. Most importantly don’t forget to pass me a “Hi” after the session. I will be walking around and it will always great to make a new friend.

PS: If you are in Bangalore or Pune – the Usergroups have given some amazing discounts that you don’t want to miss. It is still not late, check out the Bangalore .NET and SQL Usergroup announcements.

Continue reading...


Year 2012–a quick recap December 31st, 2012

Vinod Kumar

Looking back

It has been an exciting long year with loads of learning and sharing. I thought to share what is in my mind in general as we close this year. In this blog post I plan to share the various things we have done in this blog. I am amazed of the fact that we took some new initiatives and I am glad to see some great responses from each readers like you. This is a moment to say thanks to each and every one out here reading this post. I get inspired because of your positive comments. So please keep showing the love you have given me till date in the years to come too.

SQL Saturday 116–Thanks ALL

We started the year with the first ever SQL Saturday in India at our Bangalore UG. This was something we planned for more than 3+ months and was glad to execute this first thing in Year 2012. I am sure you are about to ask me when is the next one. We surely are thinking about this with various stakeholders. We don’t have concrete plans yet, but something is on the cards and minds of people – trust me :).

Management topics

I started writing regularly on Management related topics and this year I have started sharing much more openly on some of the views I carry strongly. This was a bold but a cautious move personally because I was not sure how my readers will react. I am happy with the results and I am glad you folks liked these topics and you have supported me much more openly via your constructive comments. I think this trend will continue even in year 2013 and I plan to write many more topics that I feel are worth a thought. I have consolidated the some of these posts in my Popular Posts section.

SQL Server 2012 Release

This was a the simplest thing and the easiest thing when it comes to writing blogs on a technical topic. This release meant I had loads of fun exploring new things and then sharing with readers. I think we shared some really good content on some really cool new features this year. As I explore more of SQL 2012, they will surely get featured here in this blog. Trust me :). Some of the posts for reference are:

Upgrading to SQL Server 2012

Contained Databases inside SQL Server 2012

Page Restore Dialog in SQL Server 2012

SQL Server 2012: THROW your errors

SQL Server 2012: ColumnStore Characteristics

SQL Server 2012: Offline Logs viewing

Monitor High CPU with Extended Events in SQL Server 2012

SQL Server 2012: Using SEQUENCE

SQL Server 2012: Finding Sequence of backup taken

SQL Server 2012: Offline Documentation

SQL Server: Database Recovery Advisor

SQL Server 2012 : SSMS Tips

SQL Server 2012 – Too many VLF and Performance

TechEd India 2012

It has been now 9 years that I have been part of TechEd in India and I eagerly look forward to TechEd 2013 as it would mark my 10 years association with this brand. Over the years I have been very happy that deep technical content have been discussed and we have been able to excite the crowd year-after-year with new content. So here are the posts around TechEd 2012.

TechEd India 2012: Online Indexing Enhancements

TechEd India 2012: SQL Content Extravaganza

TechEd 2012: MTC India @ TechEd

TechEd India 2012: SQL Server Internals

TechEd India 2012: Architecture Track

Picture Posts

This was a humble try in doing something different. I didn’t know I will be able to take it longer than I expected. But the fact remains, I have loads of ideas that you have provided that are worth mentioning via a picture. These are mini-posts in my opinion but driving some powerful message. It is tough to create a crisp compelling concept via pictures. If you haven’t seen these posts, well feel free to check my Picture Post section for past posts. Would love to hear your feedbacks and suggestions and I will try to incorporate the same. I already have more than 15+ posts done on various topics.

SQL Server Basics Topics

Most of the times I love to explore to what SQL Server has to give me. And many of my posts in the past 1 year have been on explaining some core concept in an detailed way when it comes to SQL Server 2012. Having said that, I have been quizzed by many about the basics and this triggered the concept of “Basics series”. In the last one quarter, I have seen the most viewed topics have been my Basics series. I am happy to write many more in the coming year and look forward for your support.

SQL Server: Database Basics

SQL Server: Database Page Basics

Concurrency basics

SQL Server: Locking basics

SQL Server: Storage Engine Basics

SQL Server: Transaction Logs and Recovery

SQL Server: Basics of Database Snapshot

SQL Server: TempDB Basics

Bangalore UG started

One of the biggest announcement which is worth mentioning over this blog is that, we started the Bangalore SQL Server UG officially and we have had two UG meets so far with great turn over. If you are interested in knowing about our group – Join SQLBangalore over facebook. There is so much to share and learn and this group has some finest of people from GTSC, PFE, MCS and community. Thanks again for supporting, contributing, sharing and engaging in the groups page. Join the group, I can assure you loads of learning for sure.

Personal SLA

What has been my SLA? Well, it was not a new year resolution but more of a self control to see if I can write 2 blog post every week in a consistent way. Must thank Pinal for the continuous source of inspiration even till date. I think since April atleast 90% of the time I have written 8 or more blog posts every month till date. In order to keep myself busy with topics, I have used various techniques as mentioned above. If you have any specific series that you want me to take a stab – well, drop your comments and I will try to write about them.

Finally, thanks for reading this far !!! Feel free to subscribe to my blog via email, and thanks to the 200+ people who have already subscribed. Thanks to all my followers and readers via RSS and Twitter. Last but not the least – I take this opportunity to wish each and every one a fun filled safe happy New Year 2013.

Continue reading...


Reliving #TechEdIn at Blr UG April 3rd, 2012

Vinod Kumar

Reliving TechEd 2012 with Vinod Kumar 1TechEd India 2012 has been an event to remember and we take great pride in bringing this event every year from Microsoft. As I posted before on my other blog post around recap it takes a lot of preparation and execution to do sessions at the TechEd. This time I was tweeting almost live at the event using the #TechEdIn tag and everyone following me will vouch for the same. Having said that, there are many out there who really want to relive the experience of TechEd again. So here we go again – I will be doing a session on April 1st (Saturday). and Brings you

The Bangalore Usergroups are a bunch of bubbling individuals who bring so much joy to the members by conducting regular Usergroup meets. If you are in Bangalore then I strongly urge you to join these groups to get an update on an constant basis.

  1. – Bangalore .NET Usergroup
  2. – Bangalore ITPro Usergroup
  3. SQLBangalore – Bangalore SQL User Group

Not strange, being in this city for close to 12 years, I have had the opportunity to talk and be part of both the UG’s since they started. Still nostalgic !!!

Reliving TechEd Sessions

TechEd2012Switching gears, yes – if you want to hear to my sessions delivered at #TechEdIn now in a much more relaxed manner. This is the chance again. For folks who are wondering when it will happen in their UG – don’t worry. If I travel to your town, I promise to do them for sure. This UG meeting we plan to have 2 sessions (back-to-back) on Internals.

1. Understanding Windows with SysInternals Tools
2. Peeling the Onion: SQL Server Internals Demystified

I can assure you one thing for sure – it will be a learning and sharing experience for me in a free flow format :).

Feel free to comment if you want any specific area to be covered as part of the UG event. I will be more than happy to expand the scope to include them :). For it is reliving the experience and get great content – right?

Venue: Microsoft Corporation, Krishna Hall, Embassy Building, 3rd Floor, Domlur.

Register at our FB page :!/events/139444029517882/

PS: Feel free to walk in too – it is your group and the session is completely FREE. Entry on a first-come-first-serve basis only.

Community talk: Manas Blogged on this event. Wonderful Community Networking opportunity. Track us via #ReLiveTechEdIn over twitter.

Continue reading...


#TechEdIn 2012: Vinodk_SQL Recap March 30th, 2012

Vinod Kumar

With exactly one week gone past, I am yet to recover from the mega event TechEd India 2012. Same time last week, we were partying after a successful event and the very thought we pulled it off yet another year is so refreshing. My TechEd journey started in the Year 2003 and there has been no turning back since then. The fact remains, the way TechEd is run has changed quite a bit and the content selection process is also more stringent when compared to what we had 8 years back. Just the availability of the resources on the internet makes speakers run for the money. Personally, it is close to 2+ months for nailing the session content – not to forget the reviews, rehearsals and more.

These are my perspectives – For me Microsoft TechEd is such a premier event and privilege that I want to give my best and prepare something nice and interesting that is so difficult to get via any search engines. Doing so, we add value to the event and in the process learn a lot. This year has been no different and I think people who attended my session will vouch for the same.

SQL Server Misconceptions and Resolutions

Pinal Dave has been pushing me hard every year to have this kind of session and I have resisted personally. Any two-speaker session requires tons of preparation and that has to land perfectly. The content for this session went to-and-fro for close to 20 days between us. We add a demo and scrap it immediately. We had to balance out simple concepts with compelling demo’s to our Misconceptions sessions. I think it landed well finally. We still await the final verdict (via feedbacks) from the audience but were confident we pulled this off with all the preparations behind us.

I will not try to rehash the content here. But Dhananjay Kumar did a live blogging of this session here. That gives you a quick list of what we discussed.

Peeling SQL Server like an Onion: Internals Demystified

Personally, this was the toughest session for me to prepare – trust me. I wrote a teaser on what to expect from the session before. As the name suggests it is tough to talk about the internals (as theory) with almost no demo’s around the concepts. The audiences were surely in for a surprise and the hall started to fill in from 10:30AM while the keynote was still going on – and the session scheduled for 11:15. I talked about Advanced Disk formats, SQL Server 2012 Security changes, Memory changes, Indirect CheckPoint and more.

Again the community notes were awesome, atleast it is saving me time to write all of them :). Sahal did a great job on his blog in summary.

Again, I look forward for some serious feedbacks if you want these kinda session in the future TechEd’s too? Or you don’t want these internals session and more practical sessions? Based on your shout I will plan accordingly for next year. Each and every vote count :).

Tools to manage, troubleshoot and diagnose your Windows systems

This was an unconventional session for me. I generally have a tendency to play around with OS, Office, IIS, Azure and other tools and learn some of the fundamentals. So in this session my task was simple – show people how you can use SysInternals tools and learn Windows better. From usage of Memory, x86 architecture, x64, WOW mode, Page faults, Virtual Memory mapping, OOM scenario, Perf Tool, PAL tool, Logman and more. About 10 mins into the talk, realized the session had so much of theory that it is better to showcase the same via tools rather than talk in an abstract manner. This was my first time at TechEd to talk on a topic other than SQL Server.

If you have feedbacks to give me on this very session, I will be more than happy to get them. I would love to bring more of these maybe for next year too. Keep those comments flowing.

Apart from these, there were couple of other sessions in which I had my participation. But that was under the Architect Track. Will write on it separately some other time. The full roster of sessions we had in that track is available on my previous blog post.

There is also an event on April 7th in Bangalore which the Bangalore .NET Usergroup and the Bangalore ITPro Usergroup are hosting where I will talk two of the above sessions. Here is the Facebook page which you can use to come to the event.

If you did attend any of my sessions at TechEd, please take a moment to comment on your feedbacks.

Continue reading...