Real time savers in SQL Server 2008 & a personal advice :)

Its disheartening to see that we developers are eventhough unwillingly ready to work for hours in the night but not ready to learn the things which can actually save lots of time and allowing ourselves to enjoy other parts of life too. I am not sure who to blame for this - developers or leads like us who has the responsibility to get the work done, keep the project core - the product, the solution, the code of software we are developing, of high quality, keep informed the developers the innovative ways, new developments, new tools using which they can save time and write code which would be useful for future as well as efficient, thus giving high quality end product. But in any case we all should own collective responsibility for it and everybody should work to improve the situation.

Take some time out to see what's happening in the programming world, learn new technologies and get certified,  learn better programming practices, read great programming books, motivate upgradaton in the technologies, become MVC :)  , share with everybody, and apply it on all the work you do. With my personal experience I can say that companies always supports the new ideas but you need to work to convince its fruitfulness. Let's take a break, ponder, and start doing something about it!
Anyway, let me now share with you couple of time saving features SQL 2008 has in addition to  in-built intellisense and others.  Using T-sql debugging shipped with SQL server 2008 is very simple . Also another time saving feature is searching objects in the database.

T-SQL Debugger
In SQL Server 2000, there was debugging a routine in Query Analyzer, as a debugger tool was available with it. Starting with SQL Server 2005, Query Analyzer and Enterprise Manager had been clubbed together as SQL Server Management Studio (SSMS). Though this single interface has simplified working with SQL Server, one major drawback was, it does not allow you to debug a routine from there. For that purpose you needed Visual Studio (Enterprise and Professional) edition installed, on your development machine, which allowed you to debug a routine. But very few of the people cared to use this and rather resorted to methods like putting "print @parameter" in queries, the shortcut method in short run :). And due to this manyatimes I have seen developers forgetting it and allowing print to go on production.

Debugging capability in SSMS was a long sought feature by users and finally the Microsoft SQL Server team decided to provide this feature in SQL Server 2008. With this feature you can navigate through your code, line by line, watch the current state of variables in the program, an output window where you can observe what the code is doing, error windows, the ability to navigate backward and forward through each line, observe system objects such as the call stack and threads, not only this you can even place "breakpoints" and then tell the debugger to run the code up to that point and then stop.
Debugging SQL server is in steps:
  • Right click Procedure>Script stored procedure as>Execute To>New Query Window
  • In the opened window, put the parameters you want to pass.
  • Set a breakpoint on exec
  • Press Alt + F5 to start the debugging and here you go debugging of the procedure starts
  • Go on pressing the F11 and it will step into each line of the procedures, for which you can see the values, quickwatch everything.

Object Search
At the top of the Object Explorer Details (OED) panel, which you can show by pressing F7 in SQL Server Management Studio, you'll find a "Search" text box. If you want to find an object in a particular database, just click on any database object in the Object Explorer (OE). Then enter the name of the object you want to find. If you want to search all databases, click on the "Databases" node in OE and then enter the text string.

If you want to find an exact match on an object name, just enter the text you want (it isn't case-sensitive unless your database is). If you want a partial match, then use the standard T-SQL wildcards. For instance, Account% finds all objects that start with "Account". %Account% finds all of the objects that have "Buck" in the name. Once you find the object, you can right-click them to perform certain actions on them. If you want the full range of right-click options, then right-click the object and select "Synchronize" to find the object in OE, where you'll have all of the options.

This is it for now.Your valuable feedbacks please :) !


Keep Believing in Yourself!

There may be days when you get up in the morning and things aren’t the way you had hoped they would be.
That’s when you have to tell yourself that things will get better.

There are times when people disappoint you and let you down.
But those are the times when you must remind yourself to trust your own judgments and opinions, to keep your life focused on believing in yourself.

There will be challenges to face and changes to make in your life, and it is up to you to accept them.
Constantly keep yourself headed in the right direction for you. It may not be easy at times, but in those times of struggle you will find a stronger sense of who you are.

So when the days come that are filled with frustration and unexpected responsibilities, remember to believe in yourself and all you want your life to be.
Because the challenges and changes will only help you to find the goals that you know are meant to come true for you.

Keep Believing in Yourself, No matter what!!!

Some life time Lessons from "3 Idiots"

1. Never Try To Be Successful
Success is the bye-product. Excellence always creates success. So, never run after the success, let it happen automatically in the life.

2. Freedom To Life
Don’t die before actual death. Live every moment to the fullest as you are going to Die today night. Life is gifted to humankind to live, live & live @ happiness.

3. Passion Leads To Excellence
When your hobby becomes your passion and passion becomes your profession. You will be able to lead up to excellence in the life. Satisfaction, pleasure, joy and love will be the outcome of following passion. Following your passion for years, you will surely become something one day.

4. Learning Is Very Simple
Teachers do fail. Learners never fail. Learning is never complicated or difficult. Learning is always possible whatever rule you apply.

5. Pressure At Head
Current education system is developing pressures on students’ head. University intelligence is useful and making some impact on the life but it cannot be at the cost of the life.

6. Life Is Emotion Management Not Intelligence Optimization
Memory and regular studies have definite value and it always helps you in leading a life. You are able to survive even if you can make some mark in the path of the life. With artificial intelligence, you can survive and win but you cannot prove yourself genius. Therefore, in this process genius dies in you.

7. Necessity Is The Mother Of Invention
Necessity creates pressure and forces you to invent something or to make it happen or to use your potentiality. Aamir Khan in this film, 3 idiots, is able to prove in the film by using aqua guard pump at the last moment.

8. Simplicity is Life
Life is need based and never want based. Desires have no ends. Simplicity is way of life and Indian culture highly stresses on simple living and high thinking, and this is the way of life: ‘Legs down to earth and eyes looking beyond the sky’

9. Industrial Leadership
Dean of the institute in 3 idiots is showing very typical leadership. He has his own principles, values and ideology, and he leads the whole institute accordingly. This is an example of current institutional leadership. In the present scenario, most of the institutes are fixed in a block or Squarish thinking.

10. Importance Of One Word In Communication
If communication dies, everything dies. Each word has impact and value in communication. One word if used wrongly or emphasized wrongly or paused at a wrong place in communication what effect it creates and how is it affected is demonstrated very well in this movie.

11. Mediocrity Is Penalized
Middle class family or average talent or average institute is going to suffer and has to pay maximum price in the life if they do not upgrade their living standards. To be born poor or as an average person is not a crime but to die as an average person with middle class talent is miserable and if you are unable to optimize your potentiality and die with unused potentiality then that is your shameful truth. One should not die as a mediocre. He/she has to bring out genius inside him/her and has to use his/her potentiality to the optimum level.

Let’s create a learning environment…..