Microsoft Technologies, ASP.NET & SQL SERVER Tips with Rajat Jaiswal

Utility

Although , It is out of box but I would like to share here. I am very choosy in food. When my mother/wife cooked food and I didn’t like the taste then I explicitly said I didn’t like but when food taste was awesome then I didn’t say a word.

My mother taught me “You should appreciate every thing which is good.” Your single appreciation word do things

1. You yourself feel better

2. The person who did the good thing will be motivated to do more good things (in my case more tasty food wow )

This lesson of my mother is now one of the rule life.

So here I would like to say one of the best tools I came across is “SQL Sentry plan Explorer”. There are various great features of this tool but I would like to share few things which attract me more

1) It comes in two versions (Basic & professional ) .Basic version is absolutely free free free.

Most of the time when you write code for a web application you need to test it again and again. You have to run a whole flow of positive or negative test cases to check whether your application is working or not.

Now suppose your application have 20 pages and you need to traverse each individual page and may be perform some operation and on each change of your development you need to perform same thing.

sometimes, this thing will irritate you and you will skip testing which may be harmful because most of the time it happens when you skipped something you took a deep breath and at that moment your application crashed .

So , as a responsible developer we do not have to skip any test scenario but next question is how to reduce this effort which you feel boring sometime.

I can say we can reduce this effort by a installing a simple Firefox add-in which is absolutely free. The add in “Selenium add in”

once you have installed this you will find the selenium icon near by search bar as shown below

when you click this icon you will get a selenium interface as shown below

The basic concept of this tool is what ever you will run in browser it has capability of recording those steps so it is just play button and pause button game, no rocket science. You can easily run and use this.

I am sure it will reduce your testing effort and when when selenium ide will play your test cases you can take a deep breath and enjoy your coffee and snacks.

Happy New Year 2014. It give me immense pleasure to introduce new Windows phone App which is QuickAccess. You can use this utility app i am pretty much sure it will help you in many ways. You can instantly send SMS, E-mail with pre decided template to a group. so download and enjoy.

Many times we require XSD from XML which we can utilize in our code. so to achieve this we need to run a simple command which will create your XML in XSD. Now you are thinking what is that command so here we go

Dear Friends,
Sometimes you stuck in situation where you need to run same set of queries on different servers.
Sometimes it is a real pan when you need to fetch records from all the server then basic approach you follow run query on different instance once by one.

I would like to share here one important facility provided in SQL Server management studio which is

“Register Servers”

With the help of Register Servers option you can run same query for the entire servers which you have registered.
You can access the “Register Servers” option from View ==> Register servers OR by pressing “CTRL + ALT + G” keys.

As shown below fig

Once you press the menu or follow above keys then you will get Register Servers option screen as shown in below fig.

You can right click on Local Server Groups and can create your own group also

Once the group is created you can move your Registered servers on which you want to run query in that group with right click move option on Group Folder

As you did this job your database server will come in the particular group folder as shown in below fig

Now right click on your group folder and go for option New Query
As you go for option new query a new query window will be open there
Now write proper query which you want to run on same database at different servers and execute it with F5 option
You will find when you will execute the result will show in query result window which is just below the query with starting column server name.

Now you have option whether you want merge result or Individual result.
To check that option you need to go Tool –> Option then Query Result option as shown below fig

This trick will help you in many ways to get the results from different server as well as to find results from different servers.

Dear All,
Today I am going to share one of the interesting options of SQL Server Management studio which may be unknown to most of us.
Now you are thinking what it is? So the cool feature is you can

run DOS command in your SQL Server Management studio

.
I know your next question is how?
My answer is just follow below step
Go To Tool –> Option
After option window open you need to select Query Execution tree and Select checkbox for

“By default, Open new queries in SQLCMD Mode”

Now open new Query window and write following command!! Dir C:\
And hit F5
You will find below in the query result you have directory & files of your current C drive.
Just check below fig to understand.

In this way you can run various DOS commands.!! SSMS
!! Dir C:\New Folder