Day 3(23rd March) @ TECHED India 2012

Teched31 002 Teched31 025Teched3Teched2 040Teched31 036

I reached earlier (no traffic due to UGADI) at the venue for Day3 and started roaming around with Sudeepta Ganguly (@skganguly) and met Vinod Kumar(@vinodk_sql) at the MTC glass room. After visiting the showcase area and checking some of the cool products and software we moved to the Kalinga for the Keynote session. The two best thing of the day was we met a gentleman and down to earth person Kaliyan.S (@kaliyans), the UG Lead of BITPro and took some photographs with him and second lots of SQL sessions. During the day I met ravikanth (@ravikanth), HarishV(@harishv), Aaron Skonnard (@skonnard) of Pluralsight. Meeting great people getting tips and tricks are the most important part of my experience at TECHED. Also I managed to receive an award for my tweets and blogs, thanks to all those who re-twitted my tweets :).

image Video

and the experience of the day goes like this……….


By Chakrapani Gollapali, General Manager – Consumer Channels Group,Microsoft India

A speaker to watch for.. He gave us some statistics of Microsoft Technologies users across worldwide and he praised the rock star saying “you are inspiration for us”. He also focused on consumers, developers , partners and showed some "Innovations” at Microsoft.

Gerard Rego, Director Ecosystem and Developer Experience (EDX) – Nokia India Pvt. Ltd.

Gerard focused on the mobile technology and said “If you have an idea on technology, Nokia and Microsoft are ready to support you with the infrastructure and convert your ideas into reality”.

Peeling SQL Server like an Onion: Internals Debunked and Tools to manage, troubleshoot and diagnose your Windows systems

Memory is one of the key parameters for having a healthy SQL Server performance. Vinod Kumar(@vinodk_sql) gave away some of his books for correct answers before presenting the technical session. some of the key points during the sessions are

  • Recovery time is important and not your backup time.
  • Disk, Security, Checkpoint and memory are the key for SQL Server internals.
  • some of the concept like LSN, CLR, MPA, DWH, TS and the checkpoints were elaborated during the session.
  • Can we have more than 8K in the buffer tool? and the result of PI + NULL ….if you want to know tweet him.
  • In his second session Vinod told CPU, memory, storage and Network are key features for the Windows internals. We came to know about various technique to use the SysInternals tools like Logman, ETW, PAL, VMMap, ProcExp etc.

Speed Up! – Parallel Processes and Unparalleled Performance

“More CPU More Performance” – do you think so??? you could have attended the session by Pinal Dave to know the aspects of the parallel process. He started with LOL session and introduced the Amdahl’s Law of Parallelism and proved that  if you use the CX_PACKET wait types, MAXDOP, parallelism threshold and various other concepts properly Parallelism will be achieved. Some of the key points were

  • Distribute, Repartition, Gather
  • Query hints
  • How a Thread0 manages the other threads in Parallelism
  • he finished with a quote “confused or convinced!!!”.

Two other great session on SQL were

Keeping Your Database Available – ‘AlwaysOn’

SQL Server 2012 AlwaysOn technology by Balmukund Lakhani (@blakhani). He described

  • how to combine Failover Cluster Instances with Availability Groups to provide a complete HA and DR solution.
  • how to use Availability Groups Multiple Secondary to replace existing database mirroring
  • Readable Secondaries, backup on secondaries
  • He displayed real life examples by putting the pictures on low and high availability on his slides ( its better you ask him for the slides :))

Lesser Known Facts of SQL Server Backup and Restore

I am not a DBA, just an application developer/support guy who uses SQL, but no idea I enjoy the session by these SQL rock stars, may be its there way of presenting the topic.

Backup and restore are considered the most common tasks and most of the time the knowledge does not go beyond memorizing the syntax of backup and restore. "

Amit Banerjee (@banerjeeamit) uncovered all this hidden facts on SQL Server Backup and Restore and to more about this you may have to wait for SK’s blog on all these. He offered couple of books (Coauthor of SQL Server Backup Simulator) for correct answers and asked some questions like If I have 100 database files, will the default buffercount and maxtransfersize change?

But one of his slide he proved “GOBIG” putting some COLGATE moments with lightening white tooth 🙂

Using HTML5 to enhance your web applications today

This was a nice session by fritzonion(@fritzonion) of Pluralsight for HTML5 where he displayed the power of plugins without the plugin. Though I attended this session bit late but I will watch the video traning at Pluralsight as I got one subscription free from them.


Closing Note

It was all started with surprise Kolaveri dance by none other than Moorthy Uppaluri, General Manager, Academia, Microsoft Corporation and presenting “seize the opportunity”. He took the stage for the entire slot assgined to the closing note. “This one was the biggest ever techedin” said Moorthy. Data Scientist is a new profession and Social Computing is not far behind with IT democratization. He disstributed awards to the developers and the contest winners (I am one of them :)) and during all this time he was enjoying a lot and was allowing the audience to scream a lot. Hope we will meet you on the next TECHED2013 with the next trendy song of the next year 🙂 aage aage dekho hota hai kya

As Moorthy said that say hi to the person seating to your left and to your right, he does mean that go for “Strong Networking” in IT world.

DSCN1616 Teched31 018Teched31 020Teched31 014

Some of theSpeaker’s at TECHED who influenced the audience

Teched2 050Teched2 015 Teched2 039Teched31 040 Teched2 056

For more speakers and videos TECHED Videos

And last but not the least hey I really enjoyed my time at the TECHED with Lohith from BDOTNET who also was a winner of the Tweet Award at TechEdIn. IMG_1436

Champions aren´t made in the gyms. Champions are made from something they have deep inside them – a desire, a dream, a vision.  ~Muhammed Ali

Day 2 (22nd March) @ TECHED India 2012

Teched2 008 Teched2 025Teched2 061 Teched2 018

This complete day I was just LOL with tech jokes (specially the SQL Premier League) with Nakul Vachhrajani (@nakulv_sql) , Tejas Shah (@tejasnshah), Sudeepta Ganguly (@skganguly) and TEP with @GetExchange. Before the keynotes we roam around with Pinal Dave (@pinaldave) and Vinod Kumar(@vinodk_sql) and took some cool photographs… oops BIG Photographs!!!!!

Today Getting a chance to enter into the room was difficult, forget about the seat and  thanks to the crowd at the Visual Studio 2011 session for that. But I somehow manage to attend one session on VS2011 and couple of sessions on Windows 8. I am going to grab a seat before the show starts tomorrw 🙂 its SQL Day tomorrow.

I met Abhishek Sur (@abhi2434),  Abhijit Jana (@AbhijitJana), Steve Woolley (@stwool) of plural sight near the stalls and event area.

Teched2 014  Teched2 034

Let me take you through my learning and experience on this 2nd day of TECHED India 2012.


One thing about the keynote is to expect some big notes on Microsoft or how they love technology. Today the keynote was presented by Amit Chatterjee, Managing Director, Microsoft India Research and Development Pvt Ltd. He took us through all the recent technologies and advancement at Microsoft with some cool demos on Win8. He has spent 23 years in Microsoft and was a key member of the Windows team that shipped Windows 2.1, 3.0, 3.1 and Windows 95. He was recently conferred the IIT Kharagpur Distinguished Alumnus Award 2010. 

Working on an agile team with Visual Studio 11 and Team Foundation Server 11

The session was about the agile usage and how VS11 fits into the demand also some more stuff on TFS. Praveen Srevastsa narrated the topic so nicely that more than half of the audience fell in love with agile , other with Scrum. This was the magic of the templates in VS11. But he clearly mentioned Agile is a best practice  where as scrum is an implementation. The 10 thing to take away from the session were

1)Define done, 2)Fail Test, 3)Understand your team’s velocity, 4)Finish what you start, 5)Bugs are real bugs, 6)Write unit tests always, 7)Autonomy mastery purpose, 8)Do the right things at the right time, 9)Plan until you need to learn and 10)Quality is not acceptable. This was in fact one of the informative session from process and VS11 point of view I have attended so far.

How and When Metro Style Apps Run

This session was all about windows programming and some topics on discussion was BackgroundTransfer API and the Lock Screen Apps. If you want to know the cooler side of the Win8 developers tool and related things spot & stop guys from Microsoft and speak to them near the stalls. Read More 

Bring your Apps to life with Tile and Notifications

Aditee Rele( @aditeerele) described the Windows.UI.Notification namespace and its usage. She gave demo on Live tile, Square Tile and Wide Tile. There was some Toast notifications , PUSH notifications and also she gave demo on the Request channel URI. Read more


Transforming PC experience


This session was from Intel and they showcased some of their new product like the ULTRABOOK and IA in VS2011. They told us about the sensor based technology and displayed some cool video.


Expecting the TECHED Day 3 to be BIG!!! We want more!!!! Yes a lots of SQL sessions are lined up.


Check the photo gallery

DAY 1 (21st March) @TECHED INDIA 2012

IMG_1432 IMG_1430

I reached at the venue of TECHED at around 8AM with my dear friend Sudeepta Ganguly (@skganguly). I got excited to see so many people over there. We register ourselves and got the TAG (yeah 🙂 ..took some photograph in front of the big poster).

The first person we met was @GetExchange (Sahal Omer from While discussing I saw one of my Guru Jacob Sebastian (@jacobsebastian)SQL Server MVP, Author, Speaker and Trainer from beyondrelational. We had a nice time with Jacob, such a nice person he is. We spent around 30 minutes in discussing about life and technology and that was a really cool discussion. Let me tell you that he has given me a chance to write in Beyondrelational website. During the discussion Nakul Vachhrajani (@nakulv_sql) joined us with Tejas Shah (@tejasnshah).

Just after sometime Pinal Dave (@pinaldave) and Balmukund Lakhani(@blakhani) joined us with Dhananjay Kumar (@debug_mode). These people have there own blogs and they write regularly on MS Technologies. On some jokes we all were laughing out loud and suddenly the announcement was made for attending the keynote session.

Here goes the session detail what I attended today


By Sanket Akerkar and  Bernardo Caldas. They took us through multiple slides and display how Microsoft is passionate towards technology. They told 4000 participants are here and more than a lakh are watching it online. Sanket invited Abhijit Jana (@AbhijitJana) and Jebarson Jebamony and they displayed some glances of home security with Windows Azure meets Kinect.Speaker :

T-SQL Rediscovered with SQL Server 2012

Jacob Sebastian started the technical session and introduced some cool T-SQL functionalities of SQL 2012. some of them are

  • CONCAT() which avoids additional conversion and checks is null automatically.
  • IIF
  • Error Handling
    • THROW
    • For Pagination

    Catapult you data with SQL Server 2012 Integration Service

    Praveen Srivatsa introduced the new Master Data Service(MDS) along with DQS and the CDC. He focused on the Data Cleansing, Expression Table, Tracking Table, VSTA scripting environment.  Check this for more

    Processing Big Data with SQL Server 2012 and Hadoop

    Stephen Forte is a real rock star from Telerik. He gave some rocking performance with the song “I wants to be an engineer” 🙂 . He told Bigdata means Velocity, Volume and Variety. He took us through a full demo session on Hadoop, Bigdata.

SQL Server Misconceptions and Resolution – A Practical Perspective

“Vinod I am going to defeat you. Guys are you with me?????” and Pinal started firing question to Vinod Kumar M (@vinodk_sql). Yes the session was about to know what day to day myths you have on SQL Server and how to avoid it and work smart. They showed some nice demo on SMALLDATETIME, Clustered Index and a lot more. you can read this BLOG  from Dhananjay Kumar. This was a much awaited session and the room was full packed.

Building Metro style apps with XAML: What .NET developers need to know

Rajasekharan Vengalil presented on the WIN RT and Async programming using C#. He gave a nice demo on the above concept and answers few of the queries of audience. to know more

The DEMO EXTRAVAGANJA session initiated by HarishV (@harishv), Vinod Kumar and multiple other people from Microsoft was just super and they gave away nice gifts to the audience. I managed to get a Pen Drive :). The small tips and tricks makes sense.

GO BIG tomorrow and will meet so many other persons also.

Microsoft TechEd India 2012 (Bangalore) …Blogs and expectation so far..



I am really excited to be a part of TECHED INDIA 2012 where I am going to experience a great learning and opportunity to meet the MVPS, Tech Gurus, Microsoft Technologies SMEs and will be able to collect loads of information. Learning and Knowledge sharing is the motto so look at the below links where people of same fraternity have already blogged there expectation for this big event.


An opportunity for MSP Ashishh Khadse Entry TechEd 2012


By Amit Banerjee (


By Vinod Kumar (Blog home),




By Pinal Dave (SQL Authority)



 By  Aviraj Ajgekar


 By Dr. Pavanaja (


By Anoop Mannur (


By windowsphonerocks


 By Jebarson


 Powered By sqlserverpedia (Qwest Software)



If you want to experience the event live then register and …

Catch TECHED live

Get information through twitter, search for Twitter handle: #TechEdIn

Last but not the least for all information visit TECHED INDIA 2012


Lets meet there at The Lalit Ashok (Kumara Krupa High Grounds, Bengaluru)

Note: If anyone from the above mentioned think that the link I mentioned should be removed , let me know and I will be happy to remove the same. @simplymanas,

My blog:

Windows Service Installation with a Service User Account

While installing a windows service I wrote this command in my installation script (not using the installutil.exe) and used a service user account.


SC.EXE create MyService binPath= "%CD%MyService.exe" start= auto obj= "domainMyserviceuser" Password= "AbcD12345" DisplayName= "My Service"

SC.EXE DESCRIPTION MyService  "My Alert Service"



During installation I got the below error and the service failed to start though it got installed.

System error 1069 has occurred.

The  service  did not start due to a logon failure.

logon failed due to missing ntrights

When I added the username and password manually to the service and started it manually it worked fine.

Then I modified the installation script and added the following command before creating the service which worked fine in installing and starting the service from the package itself.

ntrights.exe -u Myserviceuser +r SeServiceLogonRight


The command ntrights grants the Logon as a service rights to the user.


You can find this article in the link BeyondRelational