DEVCON-2012 by BDOTNET (4th August 2012)

                   Its a privilege and am honoured being a member of the BDOTNET group. We meet every fortnight and discuss about latest technology, meet the technology expert, learn from the sessions by speakers & best part is the networking with great and innovative minds while sharing information. The interest for community attracts many folks to forum like BDOTNET. The funda is simple  “Lets grow together” Smile.

After a couple of regular UG MEET this year we got this opportunity to experience a technology extravaganza DEVCON-2012. I attended the #devcon12 this Saturday at Microsoft Building, Bangalore. Some of the tips , tricks and learning I was interested to share goes like this.

Let me clarify few things…If you have missed devcon12, may be you have  missed

 

some funny moments with technology, some great learning,  some goodies, some books , you missed the opportunity to meet speakers , great products demo, technology enthusiast and above all some great authors.

bdotnet5162834458_18a2f69045Intel_LogoPluralsight_colortelerik

After the keynote by Ranjan Bhattacharjee (Group Manager, India Global Technical Support Centre, Microsoft) the great technology events begins with lots of enthusiasm and passion. I remember Ranjan saying “With a little tweak you can take this technology to any device and keep working on your skill be it C# or it is HTML5, you can still develop great product with Windows 8”. He deliver a nice and a quick intro on windows 8 and welcome everybody to the devco2012.

Fortunately/unfortunately I attended some great sessions and missed some very great toSad smile.

 

ASP.NET MVC4 + Web API by Chaitra Nagaraj

Just before the session Chaitra asked me “How many??” , I told her “Housefull Smile” and it was a housefull session. The love for web brings everyone to session like ASP.NET MVC .

You can create new APIs using this new ASP.NET Web API framework. She displayed some really cool demo and put emphasis on how to cover a larger audience starting from web to mobile devices by designing HTTP services using ASP.NET Web API.

You can install the mvc4 RC from  http://www.asp.net/mvc/mvc4 and start learning it from http://www.asp.net/web-api . If you need some documents on the same visit http://go.microsoft.com/fwlink/?LinkID=243043. Just for HTML5 lovers check what you can do with MVC using the html5 & JQUERY datepicker

Query composition, Code-based configuration, Content negotiation and so many other cool features are there in the ASP.NET web API. Chaitra has promised she will be coming back with some other cool demos in future UG Meet.

 

Building Applications for Intel Ultrabook Platform and Windows* 8 by Rajagopal A

Rajagopal is a Intel Ultrabook Technology Champion and travel more than 80KM everyday to build his passion and provide a shape to it. He demonstrated the new UltraBook the slimmest ever model I have ever seen. After the first view itself I was “Inspired by Intel”.

Once you have this Ultrabook in your hand “Suddenly everything else seems old-fashioned”

Its true when Intel says “Intel® Rapid Start Technology returns your Ultrabook to full operational power within seconds, so you can jump right back into everything you were doing.”

He displayed the beauty of ultabook with Windows 8 and gave some tips and tricks to develop the touch based , gesture based, sensor based and others on the Windows 8 platform with APIs from Microsoft. The best thing is he promised a half day meeting if we can come up with some apps for ULTRABOOK and need some help/suggestion on the same.

 

Ignite the Leader within you by Vinod Kumar

Vinod ~ “Let me ask you couple of questions”

What is leadership to you?

Are leaders born or made?

These are very common questions , but if you can answer these in uncommon way you get it.

When you watch movies like LAAGAN , whether it really motivates you or just for the sake of entertainment you loved it. You may recall  the scene where Amir Khan convinced the management (sarpanch) and the team players to include “Kachra (was treated as untouchable)” in the cricket team telling “The team is efficient but the best part is what we don’t have or what we are missing will be fulfilled by Kachra”. Amir Khan has displayed the real Leadership attitude and managed to bring Kachra into the team.

Real leadership is being the person others will gladly and confidently follow.

Its always good to follow leaders but at the same time find out the leader inside you

“The first person you lead is YOU.”

Some keywords that focus on the “Leadership Aspect” are Self Confidence, Accountability, Focus on the whole, courage etc. Just try to cultivate this and define yourself.

Emotional Quotient controls you many time, before you flow with this – control your Emotional Quotient. People are attached to leaders and not managers. Being a manager doesn’t make you a leader.

Vinod Kumar , a all time favourite speaker of mine presented a different topic and try to ignite the mind of the young and talented professionals to start thinking different as they can. We have never missed a session from Vinod, because of his guidance. He is guru for me & Sudeepta.

He suggested to some good books: 7 habits of highly effective people, Start with Why by Simon Sinek,  Lets get real or let’s not play by Mahan Khalsa

He delivered more than what we have expected for the day. The session is not the end , he has open his teaching through his blogs on the no-technical aspect of a highly technical professional. http://blogs.extremeexperts.com/

SQL Server Tips and Tricks for Web Developers by Pinal Dave 

People consider most of the SQL session as dry. Ask them to attend a session by Pinal Dave. I don’t want to praise him because he presented a nice session and people enjoyed a lot, but I should praise him because every single morning he teaches me a new concept in SQL Server and I love the way he does it. I want to congratulate him because in last 5 years  @pinaldave has completed 2200 blog post at @sqlauthority & 22 Episode of SQL in Sixty Seconds. I heard Vinod telling “Pinal works very hard and prepares a lot”. That hard work is his key to success and his energy and passion he gathers during each and every presentations he delivers.

This time also it was LOL SmileSmile session. This time he taught some fundamental but nice concepts for performance using keywords IN, EXISTS and JOIN. Scalar Functions help you to give a tough time to the DBAs Smile. (Do not try it in your production but )

 

Visual Studio 2012 – Tips & Tricks by Lohith G N

A much awaited speaker for the day with his cool “Tips & Tricks” for speeding up development with Visual Studio. Love to use the keyboard Smile

Every shortcut he spells the audience used to say “WOW”. Visual Studio 2012 is the latest offering from Microsoft in the Integrated Development Editor segment.

Check some of the shortcut provided by MSDN

Lohith is a true BDTONETTER by heart , the best part is in each of his presentation he proudly claim that. This entire devcon12 was smoothly organised because of his hard work and dedication to the details.

HTML5 – what you NEED to know by Amar Nithyananda

This session was to clear the confusion , whether to go for the much hyped HTML5 or not and how are the Microsoft tools and technology are related to HTML5.

Amar demonstrated some cool demos with Visual Studio , MVC using HTML5. He told bits & Bytes on using different websites to check compatibility of HTML5. Which browsers supports the maximum features. He spoke about different new features on HTML5 and how its gong to impact the web.

Amar will be sharing the slides of his talk in FB for all.

Closing Notes

 

Finally Vinod presented the vote of thanks to everyone including the audience, the speakers, the volunteers and last but not the least the companies who made this day, the sponsors TELERIK, Microsoft, Pluralsight and INTEL.

I met the author of one of my favorite book 3Lives Srinic.

Everyone who walked out from the room got a Pluralsight Subscription coupn worth $29 and keychain from Telerik. Couple of them got books from SQLAuthority, T shirts from Telerik and almost all of them with great learning from the day.

Intel also announced a contest for which Lohith says

exopc-hands-idf-2010-09-1319-15-36-rm-eng If you did not attend the DevCon 2012 event. Intel one of the sponsors of the event has announced "EXO PC" as a giveaway to the best blog article on the event. So those of you who attended the event – hurry and write what you felt about DevCon 2012 as a blog post. paste the link to the blog post on BDotNet facebook wall….. so whos gonna win the EXO PC"

Be a BDTONET member today check the image links. bdotnet imagestwitter

Like every time this time also I got couple of followers in twitter Smile

I write for BeyondRelational also. Please provide your feedback to make this blog more readable.

Till next time “Keep Smiling”

UG Meet by BDOTNET & BITPro on 7th April 2012

Bitpro1

Reliving TechEd 2012 with Vinod Kumar 1

bdotnet

Being a UG member I always try my best to write my learning about each and every UG meet I attend, hence I never thought of missing this one also 🙂 . I wrote about the topic and about the speaker here. This post will provide links to so many URLs where you will find more about the topics covered as well as you can go through some of the blog written by other members about the topic and about Vinod Kumar.

As decided the UG meet was on 7th April and I was there at Microsoft Building by 10AM. To my surprise already people were there and they were discussing with Vinod Kumar and Lohith, me and Sudeepta(@skganguly) joined the conversation. I met Pinal Dave (@pinaldave), Lohith(@kashyapa), VijayRaj(@msigeek) ,Sudeepta(@skganguly), Dr.Pavanaja(@pavanaja), Balmukund(@blakhani) , AmalDev (@amaldevv)  , Kamlesh Rao(@kamleshrao ), Praveen (@stpraveen1 ), Sandeep Pani(@sandippani),  Rajesh Patel (@PatelRajeshK ) , Gopal Debta and …. at #ReLiveTechEdIn

Vinod Kumar During the session. A complete DEMO based sessions.

556125_3749185171535_1333515319_33612885_191408406_n 532834_3749219412391_1333515319_33612947_1999688312_n (1)

Pinal Dave gave a small presentation on “Who is Vinod” and we all got to know about the achievements and contribution by Vinod for the community till date. Kamlesh Rao twitted saying “A presentation about SQL Server Agent Vinod Kumar by Pinal Dave” :). Vinod is more than a Brother, Friend, Philosopher, Sensei, motivator and guru for all.

305938_3749205132034_1333515319_33612916_551685971_n Pinal_pavanaja

Lohith addressing the audience

Sharing TECHED experience

532447_3749225972555_1333515319_33612965_2146055826_n 540602_3749198731874_1333515319_33612903_1663076959_n

Kaun hai udhar??

Jokes and networking

538380_3749224772525_1333515319_33612960_1593092088_n528030_3749226772575_1333515319_33612971_839973522_n 522491_3749227172585_1333515319_33612972_424511810_n529357_3749223932504_1333515319_33612958_948387244_n

Goodies

Goodies

The session was very much interactive and everyone from audience participated in the discussion. There were lots of Q&A and everyone who gave correct answer got goodies from #Telerik and #Pluralsight. Also Pinal Dave distributed SQL Poster from SQLAuthority to everyone present in the room.

There were lots of goodies and excitement but without much delay Vinod started his session on the topic Sys Internals. Here are some points from the session:

  • A full demo on sysinternal tool like PAL, LogMan, VMMap, Process Explorer, Resource monitor.
  • It was all about Tools to manage, troubleshoot and diagnose your windows systems.
  • Disadvantage of PerfMon is that its difficult to decipher, PAL is an alternative.
  • Powershell is used behind the screen to run PAL.
  • Logman can convert from one format to another.
  • Each process has 4GB and 2GB of that is taken by kernel.
  • WOW is Windows on Windows.
  • If you see an yellow color in Proc Explorer means its running a .net code.
  • Virtual memory is low because the system commit limit (RAM+ page files) has been reached.
  • Virtual allocation will happen before physical memory allocation
  • GPU Usage
  • To know about the processor family on your pc/laptop Goto Run. Type msinfo32 to know about your processor family.

image GpuusageKamlesh

 

SQL server 2012 changes on Storage, Security, Checkpoint & memory.

 

Ask Vinod on SQLServer, Intel Architecture and Memory Internals I bet you will be satisfied with the answers. Some point from the session were

  • How to change the target recovery time of a SQL Server database in SQL Server 2012 and the default target recovery time is 0
  • A checkpoint creates a known good point from which the SQL Server Database Engine can start applying changes contained in the log during recovery after an unexpected shutdown or crash(as told in MSDN).
  • Internal checkpoint is different from Indirect Checkpoint

QUIZ Time

  1. what is the different between Virtual Size, Private Bytes and Working Set on Process Explorer tool
  2. what is virtual address & physical address?
  3. what is cluster and sector?
  4. What is transaction log used for? Is that get corrupted?
  5. Can you have more than 8K pages in the buffer pool?
  6. Is the max. memory setting on your SQL Server accurate?
  7. What’s a 3GB switch ?
    Links
    Photographs , Vinod’s Blog, Sudeepta’s Blog, Praveen’s Blog, Nakul’s Blog, BDOTNET, BITPRO

    There was a 128bit joke came out from the session. If you have missed it …you have missed it. Don’t miss next time because….

     

    UG Meet teen cheeso se chalta hai  Share, Learn and Network  ya phir Knowledge, Goodies aur demo.

    Be helpful.When you see a person without a smile ,Give him yours.

    ~zig zigler

    http://beyondrelational.com/members/simplymanas/default.aspx

    #JustLearned : Checking the Job Schedule status of a SQL job

    We check daily and weekly jobs schedule status that has been scheduled in SQL server in many servers for different projects. I wrote some queries to get the status as below.(if you have better solution please comment)

    We can use a readymade solution SPHELP_JOBSCHEDULE store procedure which takes jobid, jobname, schedulename, scheduleid and schedule descirption. But this will return multiple columns and what if we have to query only the enabled status of a schedule.

    So the other approach may be to query the MSDB table DBO.SYSSCHEDULES which will give us the ‘enabled’ column from which we can get the Schedule status of the job. For more information we can join the dbo.sysjobschedules and dbo.SYSJOBS.

    SELECT enabled as JobScheuduledStatus FROM DBO.SYSSCHEDULES WHERE [NAME]=’JSCH_HR600d’

    *this one is already published in BeyondRelational.com

    Reliving TechEd India 2012 with Vinod Kumar

    bdotnetBitpro1  together are presenting a UG Meet where you will undergo the experience of TECHED2012 again(Two of the great sessions). Also its a chance for those who missed it during TechEdIn. You can have a chance to meet MVPs, UG Leads and community members. Chances to win some cool #goodies and #educational materials.

    Reliving TechEd 2012 with Vinod Kumar 1

    1. Understanding Windows

    with SysInternals Tools

     

    2. Peeling the Onion:

    SQL Server Internals Demystified.

     Key-points of discussion

    • Memory is one of the key parameters for having a healthy SQL Server performance.
    • Recovery time is important and not your backup time.
    • Disk, Security, Checkpoint and memory are the key for SQL Server internals.
    • Performance, scalability and more worst how does OS work.
    • Where is my memory gone, why does Windows behave in this way?
    • On performance monitoring and insights into performance tuning.
    • The platform of Windows has many hidden gems, lesser known and lesser understood.
    • Simple tools and identify performance tuning gems.
    • Take your experience on Windows to the next level.

    Date: Saturday, April 7, 2012 (10:30am until 1:30pm)

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

    Event Details: https://www.facebook.com/events/139444029517882/

    PS: Session is FREE for all.

     

    Teched31 026

    Holds 26+ Microsoft Certification on various technologies till date

    Was Microsoft MVP – SQL Server for more than 3 years.

    Speaker at Technical conferences like Microsoft TechEd, MSDN, TechNet, GIDS.

    More than 13+ years in computers and database systems

    Site and blog at: http://blogs.ExtremeExperts.com

    Twitter – @vinodk_sql

    Author – SQL Server Interview Questions and Answers

    http://beyondrelational.com/members/simplymanas/default.aspx

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

    Keynote

    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

    http://beyondrelational.com/members/simplymanas/default.aspx

    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.

    Keynote

    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 https://india.msteched.com/#photogallery

    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 http://www.get-exchange.info). 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

    Keynote

    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
    • EOMONTH(GETDATE())
    • FORMAT
    • Error Handling
      • THROW
      • For Pagination
      • OFFSET and FETCHNEXT
      • LAST_VALUE, FIRST_VALUE, LEAD, LAG

      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.

     

    http://beyondrelational.com/members/simplymanas/default.aspx

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

     

    image

    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

    msp-ashishh-khadse-entry-teched-2012

    By Amit Banerjee (troubleshootingsql.com)

    teched-india-2012-session

    By Vinod Kumar (Blog home), extremeexperts.com

    Teched-india-2012-sql-content-extravaganza

    Teched-india-2012-online-indexing-enhancements

    Teched-india-2012-sql-server-internals

    By Pinal Dave (SQL Authority)

    sql-server-teched-india-2012-content-speakers-and-a-lots-of-fun

    sql-server-sql-server-misconceptions-and-resolution-a-practical-perspective-teched-2012-india/

     By  Aviraj Ajgekar

    microsoft-teched-india-2012-post-3-we-have-updated-agenda-amp-voting

     By Dr. Pavanaja (http://pavanaja.com/)

    teched-india-2012 

    By Anoop Mannur (http://anoopmannur.wordpress.com)

    configmgr-2012-teched-india-2012-voting-request 

    By windowsphonerocks

    windows-phone-sessions-microsoft-teched-india-2012

     By Jebarson

    teched-india-2012-integrating-windows-azure-windows-phone-windows-8-metro-and-kinect

     Powered By sqlserverpedia (Qwest Software)

    teched-india-2012-content-speakers-and-a-lots-of-fun

     

    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, simplymanas@gmail.com

    My blog: http://beyondrelational.com/members/simplymanas/default.aspx

    SQLSaturday #116… Bangalore. ~ A note on my learning and experience.

    SQLSaturday #116 is a training event for SQL Server professionals and those wanting to learn about SQL Server.

    IMG302

    7th January 2012 at the tick of 0900Hrs IST , the registration process begins, with @kamleshrao and @skganguly. @vinodk_sql  was guiding us on the same. We saw the waitlisted candidates were waiting eagerly for a chance to witness the mega event. They made it and also the first twenty of them got some goodies from Vinod for there interest to learn and share.

    One SQL Server Clinic, Two Tracks, Nine Speaker, Ten sessions, free books, Hundreds of prizes, Hundreds of tweets,  Two Hundred people, Thousand GB of information and super fun ….all these were candidate keys for Twitter handle for this great event. But as it was decided the primary key was #sqlsat116.

    After a welcome note on both the tracks (one in Signature Building and other in Embassy of Microsoft), the first session was kick started by Lohith (@kashyapa ) on SQL Server Dev Tools -  Code Name Juneau and on the other track on BI in Denali by Karan Gulati.

    I was attending the developer track and here goes some of the learning from the event.

    Lohith took us through his mind-blowing presentation (which he does every time with an animated touch to the slide transition) and was informing us about the ease of use on JUNEAU. Every time he was changing his slide…a WOW moment was coming into the picture. He told us we as a application developer can carry out all our database design work for any SQL Server platform within Visual Studio. At one point of time we heard a sound “Ohhhhhhhhh”, when he just declared that “You can debug your Store Proc in JUNEAU”  which was like a relaxed moment for many of us.

    Avoid Errors On Errors by Rick Morelan ~ “Aap sab kese hain????”…”Aati kya khandala”…Rick started with a lovely introduction and he presented some of the topics from his book (Joes2Pros series) to handle error. Scope Abortion, Batch termination, Error, Information, XACT Abort On are some of the keywords to learn to know about errors in SQL server. All of we are familiar to the below line, but Rick gave us a close view to the Error Level.

    Server: Msg 547, Level 16, State 1, Procedure demo, Line 4

    On his second session on Basic performance Tips and Gotchas , Rick showed some really cool examples on Indexes, Fill Factors and also he informed that “Updates can cause Page split too” and “seeking is faster than scan”. His dramatic expression and presentation makes him a great speaker.

    SQL Server Performance Tricks and Tips by Pinal Dave ~ The much awaited speaker for the day, started firing question to the audience. Index-harmful or helpful? A good debate on Indexes between Pinal and audience left us with a clear idea on how to use Clustered and Non-Clustered indexes. NULL – Which you can not figure out says Pinal. The entire hall was laughing out loud when different answers were coming out from audience and Pinal was using his sense of humor to his level best. SQL server engine knows what to do , if required provide some hints. The next SQL server will have some interesting things like COLUMN STORE INDEX. He gave away couple of goodies to those who answered his questions or asked him a difficult one.

    Security with SQL Server -  Discovering Pitfalls by Vinod Kumar ~ The mastermind behind the first such event in India, who took care of everything from logistics to arranging gifts and guiding all the audience on different notes of SQL. A down to earth person..Vinod started his session with a quick introduction and started asking about the security features of 2008. After getting the answers from the audience he described that concepts briefly. Also he told about Authentication and authorization with a live demo of everything on SQL Server. One of his question goes like this….

    What is the permission checks done with SQL Server for the sysadmin account?

    He gave some quick tips on SQL Server security and warned everyone not use the SA user for any application logins.

    Keeping Database always Available (Always On Unplugged by Balmukund Lakhani ~ @blakhani a Technical Lead from Microsoft SQL Server Support Team, Bangalore showed us the real “Katrina” and took us through a full practical session on creating cluster and demonstrated the Always On feature. This feature enhances the capabilities of Database Mirroring and ensure availability of application databases. He took a challenge of creating the cluster in 2 minutes and he did it. Only one mirror per database is possible said Lakhani. Also he displayed the use of automate deployment using AlwaysOn PowerShell cmdlets which provides a powerful scripting option.

    On the other track Kolaveri Di was a super hit and all the session were presented by Karan Gulati, Amit Banerjee, Pranab Mazumdar and Tejas Shah. The session covered are BI in Denali, Demystifying SQL Server Memory Dumps, A Whirlwind Tour of Contained Databases and a real clinic on SQL Server.

    Web Links.

    http://www.sqlsaturday.com/116/schedule.aspx

    http://blog.sqlauthority.com/

    http://www.extremeexperts.com/General/Home/Homepage.aspx

    http://www.kashyapas.com/

    http://joes2pros.com/

    http://sqlserver-help.com/

    http://www.pluralsight-training.net/microsoft/

    http://www.telerik.com/

    http://msdn.microsoft.com/en-us/data/gg427686

    Twitter

    #sqlsat116

    Thank you all for such a eventful session and request others to add there notes if I have missed out anything.

    My next set of articles will be on the basic algorithms and programs that we have studied during our High School or College days(kind of back to basics). I will be using C# to write the code and hopefully “A program a day” will be my tag line. Till then “Keep Sharing”.

     

    If you want to go fast, go alone.If you want to go far, go together. ~ Proverb

    IMG303