Happy Teacher’s Day: Remembering all my Teachers

 

Those who educate children well are more to be honored than they who produce them; for these only gave them life, those the art of living well. – Aristotle

 

Dr. Sarvepalli Radhakrishnan

 

Born to a Brahmin family in Tiruttani in Tamil Nadu state, education from

Primary Board High School at Tirutani., Hermansburg Evangelical Lutheral Mission School in Tirupati, Voorhees’s College in Vellore , Madras Christian College , Professor of Philosophy in the University of Mysore, the Vice-Chancellor of Andhra University, Vice-Chancellor of Banaras Hindu University , Ambassador of India to the Soviet Union,  also elected to the Constituent Assembly of India, the first Vice-President of India , the second President of India, Professor of Eastern Religions and Ethics at Oxford University, fellow of the British Academy, awarded the Bharat Ratna ,  the Order of Merit ,  received the Peace Prize of the German Book Trade , the Templeton Prize , donated the entire amount of the Templeton Prize to Oxford University, the Oxford University instituted the Radhakrishnan Scholarships in his memory ( "Radhakrishna Chevening Scholarships"). Lets remember the great teacher on TEACHER’S DAY.   {Source: http://en.wikipedia.org/wiki/Sarvepalli_Radhakrishnan}

 

My Teachers and few moments of my life with them

 

MY First Teacher: My Father Late Sudam Ch. Dash was my first teacher, he taught me the basic values of life and how to respect to talent irrespective of cast and status. Till class four he was teaching us from 6 to 8 PM everyday (after that we went to some tuition classes). He taught us some Sanskrit slokas which I still remember …it goes like "Paropkaraya phalanti brukhsya, paropkarya bahanti nadya, paropkaraya dudhanti gava, paropkaraya idam sariram". Also my mother Late Sureshwari Dash taught me to face the struggle of life by "Stay cool and keep walking". If I will not listen to her and skip my evening hours for studies then she used to say "Kahari kichi jiba nahi to bana budiba gosain"…….

During one of my friend’s wedding(Ramesh) in Bargarh last year in June, I met our UP school Head Master Sri TulasiRam Pradhan(Recipient of Rashtrapati Award). He is very old now but still came in his bi-cycle and attended the reception and blessed the couple. He was standing  in a corner with "Jyshobanti Guruma" and was discussing something. I saw them and went there and as usual I said "Angya Namaskar". Jyshobanti Guruma asked Tulasi Angya.."Do you remember him?" , Suddenly a humbled eyes said "Because of these people I got award from President and am recognised as a good Teacher everywhere"…"Emane mor chua aan"…"eeta aamar Manas aaye". "Kenta aachu bo babu…Bhagwan tate bhal bhabe rakhitaun..Tor Bapara na ke sarthak karbu..sabku sabubele khushi debu".. Jyshobanti guruma said "bhall chkari kalana".. Tulasi Aangya said "Karba nai, Hatpada School ra chua aaye, aamar aashirwad sabubele tar sange aache". I thank them and  got a great feeling because still my teachers remember me and all my activities, and not to forget that we are just like the old school kids for them. Now a days we are getting busy in professional life and occupied with family responsibilities and may be not remembering our teachers, who had placed us in a respectful position in the society. But still they have the same love and affection for us and are blessing us everyday to reach the future goals.

I still remember the Teacher’s Day celebration. We used to prepare for debate and songs and on that day we will stand in a line to take the blessings of our teacher….Can’t we go back to those days??????

During my High School days once Our teacher Sri Susil Dash said "Tume gadha jadi phel heba …khali tumar handwriting lagi phel heba". I was disappointed for a few days…then he called me once again and said "eehade bhi time aache ..practice kara…mor tumar upre pura biswas aache je tume bahut bhal karba". I tried a lot for so many days and still trying also for a better handwriting(now somewhat manageable). Now a days I am not writing that much (due to computerised work culture) but still I remember him whenever i write something.That one statement that they believe us & our talent , takes us to the next level.

Those who stood first in school events(Town High School) they can participate in block level OSTA competitions. I stood 2nd in QUIZ so was not selected. One of the boy’s name appeared twice in the list (in QUIZ and in Essay), but he can only participate in one. That day while I was roaming around the school field, one of our High School Teacher Sri Khageswar Meher(popularly know as Meher Aangya) called me and told come to the Head Master’s room. I went there and our Head Master Sri Narsingh Bishi asked me "why do you stood second in QUIZ?". I kept quite ..he scolded me for that and then they told  "don’t worry …we called you to inform that you will be representing our school in the OSTA quiz completions, go and practice hard and remember don’t come back with empty hand". I felt very happy and participated in that block level competition and stood First in the QUIZ competition and again represented our block in Sambalpur. Here I learned that you know less about your potential and your teacher knows that you can. They have already discovered you through your potential so obey their advice and work on them. We had a small "QUIZ Society", under the mentorship of Sri Sushil Dash and we used to practice during the last period of the day.

During  my college days I attained a NSS camp in a near by village(I was the team leader). After working very hard for some 10 days we decided to give away the best Volunteer Award. Our guide Shri Prahallad Dora (Professor, History Dept) came to me and asked "whom do you think is suitable for it". I promptly replied "Bharat". He was quite for some time and said "You know I have always kept a  little soft corner in my heart for you, and today I am proud of you for your decision". After a couple of years I met him near Main Road, Bargarh and he spent around 20 minutes and asked me about my job , life , health and everything and said "I remember those NSS days and hopefully now also you must be doing the good work for the society with same spirit and motive".

"Basics are important for a person to excel in every sphere of life. Concentrate on your basics and never ask for spoon feeding" said Lalit sir …Sri Lalit Kumar Barik (My Mentor, Guru, Guide of my life’s journey in all the way). Even today also if I face any kind of difficulties either relating to professional or personal life… I used to call him and he will solve that within minutes. He is the one who changed my attitude towards life and forced me to think about the broader aspect of life also advice me to do something that he always dreamed of. Even I remember the time when I have some issues in my career or studies and if I will ask my parents .."what to do?". They will advice me "Speak to your Lalit sir and check if he has something for you". Now my parents are no more but I can connect to them through the advices of Lalit sir.

After coming to Bangalore I started attending different session and joined so many User Groups.In this journey I met Vinod Kumar M a technical and leadership Guru and started following his advice and guidelines to be a better human being and helping the tech community. Vinod knows that we can do it , he just put us on the track and will tell us “its all yours, keep moving”.

I salute all my teachers including Santanu sir (a philospher with his own way of analysing life), Mishra sir of Patharla UP School, Sri Annada Bishi, Shatni Guruma, Snehalata guruma, Sujata Guruma, Tapaswini guruma, Basanti Guruma, Hota sir, Manas Sir, Dilip Sir, Mahendra Sir, Sri Arvind Mishra . Surendra sir, Late Shri Bipin Dash, Sri Chitta Ranjan Pradhan, Ranjan Sir, Ganesh Sir, Sushree Madam and last but not the least Jiten Sir(who gave a professional touch to my career). (All these teachers are  from Hatpada UP School, Town High School, Panchayat College, MCA ,NIIT and my professional days).

NB. I might have missed some of my teachers name but still if I close my eyes …I can see them.

I like a teacher who gives you something to take home to think about besides homework.  ~Lily Tomlin

 

(I blogged this in the year 2010, this time its a little modification)

HTML5 : Where to start

HYPER TEXT is a known term amongst the Internet User Community. Every single time they visit a website, the most common thing they do is click a link that is a hyper text. The best thing is it is hyper because it can take you from “Anywhere to Anywhere”.

The most commonly studied language by all, the most widely used language among web developers and is the publishing language of the World Wide Web. Who ever had attended a computer class and knows a little about web are very much familiar to the term HTML. So its not a rocket science as its easy to write also doesn’t need a great tool, a Notepad is enough. World Wide Consortium(W3C) is the organisation which provides the specifications on HTML.

The first version of HTML was described in late 1991. The current W3C Recommendation for HTML is HTML 4.01, published in December 1999. World Wide Web Consortium & WHATWG  started working on the HTML5 in 2007 and they published a working draft in 2008, since then this version is under development tag. Instead of me telling you the complete storey , better visit this site and take journey to the history of HTML5.

To the consumer, this means an easy life with finding, viewing and downloading stuffs such as videos. Searching locally will become more reliable as HTML5’s geolocation feature becomes the standard.

Tags, Element and attributes  are knows as the Markup in HTML

<element attribute=value>content></element>

Some of the new stuffs in HTML5 elements are

• New API
  • 2D using Canvas
  • Media support (Audio, Video)
  • Offline storage
  • Drag N Drop
• Enhanced Mark-up elements
• Geolocation
• Web Storage
• Error Handling (If you do not support just ignore)
• Auto Focus
• Input Types Enhancement
• Multiple File Upload
• Offline Application Caching
• Now you can use the power of HTML5 with CSS3 and JQUERY to write mobile apps also with a few changes that will work in web browsers.

The main intention of writing this article is to let you know about the various learning materials available on the web to know more detail on HTML5.

 

A best graphic way of representing the history of html5 is here http://mashable.com/2012/07/17/history-html5/

Video Tutorials

http://thenewboston.org/list.php?cat=43

http://www.youtube.com/watch?v=mzPxo7Y6JyA

http://blogs.msdn.com/b/dorischen/archive/2012/01/31/html5-webcamp-training-video-available.aspx

http://pluralsight.com/training

Tutorials

http://www.1stwebdesigner.com/tutorials/30-html5-tutorials/

http://www.html-5-tutorial.com/

http://www.cartoonsmart.com/html5_basics_tutorial_videos.php5

http://www.w3schools.com/html5/default.asp

Web Standard (From The Creator)

http://www.w3.org/2011/02/htmlwg-pr.htmlhttp://www.whatwg.org/

http://www.w3.org/TR/html5-diff/

http://www.whatwg.org/specs/web-apps/current-work/multipage//

http://html5.org/

http://www.w3.org/html/logo/#swag

http://www.w3.org/community/webed/wiki/HTML/Elements

http://www.w3.org/community/webed/wiki/HTML/Training

Blogs

http://www.html5blog.org/http://html5center.sourceforge.net/blog/

http://gamasutra.com/blogs/AustinHallock/20120715/174150/Why_HTML5_will_succeed_for_gaming.php

http://www.zeewe.com/blog/

Free Template

http://www.1stwebdesigner.com/css/fresh-free-html5-and-css3-templates/

http://www.smashingapps.com/2012/01/23/50-beautiful-free-html5-and-css3-templates.html

http://www.noupe.com/design/40-beautiful-free-html5-css3-templates.html

http://speckyboy.com/2011/09/25/15-free-html5-and-css-templates/

Mobile Development

http://www.html5rocks.com/en/mobile

http://mobile.dzone.com/news/html5-mobile-web-development

Websites that uses HTML5

http://evolutionofweb.appspot.com/?hl=en-gb

http://madhuridixit-nene.com/

http://www.ebizmba.com/articles/best-html5-websites

http://html5websites.net/

http://www.windowsazure.com/en-us/

http://101besthtml5sites.com/

http://www.apple.com/html5/

Test your browser for HTML5 compatibility

http://html5test.com/

Links you must visit and experience HTML5

http://blogs.msdn.com/b/cdnwebdevs/archive/2012/03/19/top-10-resources-for-html5-developers.aspx

http://www.slideshare.net/cheilmann/html5-and-the-future-of-the-web-dr-seuss-style

http://validator.nu/

http://blog.whatwg.org/

http://www.w3.org/community/webed/wiki/HTML

http://www.html5labs.com/

http://www.brucelawson.co.uk/2011/html5-gurus-on-twitter/

http://line25.com/articles/handy-tutorials-tools-for-embedding-html5-video

http://www.noupe.com/design/html5-tutorials.html

so get ready and write

<element attribute=value>content></element>

Till next time “Keep Smiling”

My Favorite Quote

Be helpful.

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

                                                                                                                                                                                                                   ~zig zigler

 

Clicked By : Lohith

A smile cost less than electricity but gives more light

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

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.

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

 

ASP.NET MVC4 + Web API by Chaitra Nagaraj

Just before the session Chaitra asked me “How many??” , I told her “Housefull ” 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 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 . (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

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

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.  

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

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

Till next time “Keep Smiling”

3 Lives….In search of bliss

http://3lives.srinic.in/

Bliss!!!!

After two of the biggest pause in my life, I started searching for bliss. Yes in search of bliss, I started the journey of my life. I asked every human being I met, I read every book came in my way. I saw every happy human and will try my best to find out the reason behind it. And on a fine day I saw kids playing near my home. They were fighting amongst each other, but every time they fight one of them will stood up and say “Just let go”, and again they will continue the game happily.

Just couple of days back I got this book “3Lives” and the first couple of pages were interesting(but one thing let me tell you in very few occasion only I choose a book on fiction). But any way I continued reading the book. Every page I was reading, I tried to relate this learning with my life; In what all occasion I have found happiness and in what way I have spread it.

Believe me happiness is not something that is always yours, but you have to play the role of a catalyst in getting it and sharing it.

With a great passion and interest I completed the book and was happy and tried all the way to thank the author of such a masterpiece Mr. Srini Chandra. He has shown me the way of happiness. I got it, it’s with me. After really a great interval of time I read such a good book and each of the lives described in the book are searching happiness and are teaching you the way. Srini has chosen the words very carefully so that each word contributes to a line are becoming a world of wisdom.

The struggle of happiness through various lives is making the book more interesting.

Every single page of the book will make you feel happy and will teach you that…..

“you are the source of your happiness”.

A few lines of wisdom I collected from the book goes this way. Amongst all the lines I can say this is the best one……

Be content to ask for nothing and willing to give everything.

• Do we really know the difference between Good & Bad?
• Is love greater than life itself? If you love her why do you miss her?
• Accept without conditions …good …or…bad
• Don’t judge others by their actions.
• Hatred is too big a burden to carry.
• The measure of our lives lies indeed not just in what we have chosen to remember and celebrate but also in what we have chosen to forget.
• You cannot have it all, to have it all, you have to want nothing.
• A troubled mind has no time for the soul. A mind with no time for the soul is troubled.

So dear friends keep this line in your mind and stay happy.

Everything that arises must pass.

During the time I spent on this book I was listening to the line from the most popular Bollywood number “jindsgi hasne gane ke liye hai pal do pal” by Kishore kumar

“tere girne me bhi teri haar nahi, ke tu aadmi hai avtar nahi “

The book had taught me to search happiness everywhere, and it’s there.

“The spirit of the universe dances to its own tune, it connects everything, so how can I be missed”

One of the best conversation inside the book goes like this….

Vivek: “How would you feel about spending a lifetime with me?”

Jill: “Just one life time? That’s’ easy. I was afraid that you were going to ask for eternity.”

Vivek: “I would have asked for an eternity. But that would mean killing time”.

Be happy and always believe that “Love for God is the greatest of our romances”.

At the end I would like to put this question on to you

Is one life enough for this love? Is sharing what you have is true happiness?

I can remember some Sanskrit lines, my father used to tell me when I was a kid (it may not be properly written in Sanskrit)

Paropkaram phalanti brukhsya, paropkaram bahanti nadya, paropkaram dudhanti gava, paropkaram idam sariram

Let Go….Be Happy

Thank you Srini for such a lovely book and thanks Vinod  & Pinal Dave for the book reference.

BDOTNET UG MEET: 26th May 2012 (WindowsAzure & SQLServer)

 

Today we had a UG meet at Microsoft Building,Bangalore. UG Meet means guaranteed technical learning, a great networking opportunity, feedback from masters, unlimited fun, lots of tweets and the count goes on.

The audience experienced two very informative session by two masters 1)Windows Azure by Niraj Bhat(FB|T) & 2)SQL Server Execution Plan by Pinal Dave(B|T) from SQLAuthority. This time also we had a houseful audience like every time and each one went back with some new thoughts , some new ideas and some new concepts. One thing I must say that from today onwards every one who attended the session will “Ask SQL Server” for their doubts , rather then assuming anything:)

Vinod Kumar(B|T) introduced the speakers and said a few words on Windows Azure. He asked multiple questions to audience and gave them a feel of what’s coming up. Also if you know the answers , you can tweet him or put the same on #BDOTNET FB page.

Here goes some points covered in the sessions.

Windows Azure: Big Talk

Windows Azure is an open and flexible cloud platform and used to build , deploy and manage applications across global Microsoft managed Data Centers. It provides you a great application hosting environment.

Niraj told us about the Open Source Apache™ Hadoop which is used to develop open-source software for reliable, scalable, distributed computing.

Microsoft says ~ A Hadoop based service on Azure will offer broader access to Hadoop through easy setup and configuration, simplified programming with JavaScript integration, and integration with familiar tools such as Excel.

Apache Hadoop is a powerful, scalable, distributed computing framework designed to handle the extreme volumes of these unstructured and structured data. The Developer Preview for the Apache Hadoop- based Services for Windows Azure is available at https://www.hadooponazure.com/. Its a software framework to process vast amounts of data scheduling, monitoring, re-execution of processing tasks.

You can follow the steps below for Hadoop On Azure.

1. workflow
2. create gather data
3. copy data to hdfs/asv
4. mapreduce functions
5. output to hdfs/asv

Niraj also spoke about Google’s initiative of Parallel Programming MapReduce. MapReduce is a programming model used to process large amount of raw data.

 

SQL Server Execution Plan

How to use petrol efficiently?  Should I sale my car? Should I go for a Bi-Cycle?

Pinal Dave started his session and triggered the current petrol issue which gave a big question mark to everybody. In what way this problem is related to SQL Server execution? Actually he was trying to clear the idea that “to be efficient , you need to use your resource properly”.

Why is my query running so slow?

Is there a problem with the way I use my select statement?

Is my index not proper?

Does the where clause make sense in the performance?

Less resources better performance. Is this true?

Pinal Dave took a session on one of the most discussed topic of SQL server i.e. Execution Plan. He explained the best practices and gave some nice suggestion with a couple of Q&A on execution plan. The demos added flavor and clear the confusion with the execution plan described through the SSMS. When to use indexes and whether the select and where statement make sense in performance tuning or not was the main discussion on the day.

Some of the points need to be considered are

• What are the indexes we have?
• Adding columns doesn’t change the execution plan its the where clause that change the plan, (But you need to consider the columns)
• Nonclustered index already have clustered index in the selection.
• Order of the index also matters.
• When you want to tune always compare the execution plans.
• Check the actual vrs estimated plans
• Conversion of datatype matters
• Put N before varchar to make it nvarchar (plain english )

In SSMS Shortcut for Display Estimated Execution Plan : CTRL + L
Shortcut for Include Actual Execution Plan : CTRL + M

Pinal also touched the SQL Server 2012 keyword SEQUENCE and Vinod pitch in to clear some doubt on Pinal’s request. Vinod has dedicated a complete article for SEQUENCE.

• You will not be able to change the datatype of a sequence with alter sequence statements.
• IDENTITY is different because even the IDENTITY can get reset using the TRUNCATE command, but SEQUENCE has to be reinitialized using the ALTER for the same.
• Sequence can be used inside a  Insert , Select , Update statement, with Over and Order By and With Default.
• If you need a unique sequence number to be generated across a single database then sequence can be of great help. IDENTITY can be used to generate a unique number for a given table and not across tables.

QUIZ Time

1. What is bits  in Windows 7?
2. What are the different Optimization level? (trivial, full)
3. What are the difference between WCF and windows service?

Useful Links

https://www.facebook.com/groups/BDotNet/

http://blogs.extremeexperts.com/

http://blog.sqlauthority.com/2010/01/22/sql-server-execution-plan-estimated-io-cost-estimated-cpu-cost-no-unit/

http://ranjandotnet.blogspot.in/2012/05/wcf-servicesvs-windows-service-this.html

Check http://beyondrelational.com/ for my articles, Interview Questions and Just Learned sections.

Till next time Keep Sharing Smile , its free

Oh My Green

I was part of the green initiative in Tesco and got this appreciation.