How to find all running SQL Server Instance on a machine

Hello friends,

Many times it happened with me I forgot the instance name of SQL Server.

So here is a small trick which will help you in determining the entire running SQL Server instance on your machine.

You just need to run a simple command on Command prompt.

 C:\>SQLcmd -L

This simple command will provide entire running instance on your machine.

Enjoy this Trick.

Happy weekend.

Thanks & Best Regards,

 Rajat Jaiswal

Where is “SQL server Surface Area configuration” in SQL Server 2008 R2 ?

Hello friends,

Many times you need to do SQL Server related configuration like, CLR enable, Xp_cmdShell, Remote Access etc.

 I am able to set this configuration in SQL server 2005 using “SQL server Surface Area configuration”. But I was surprised when I did not find this exe in SQL Server 2008 R2.

After little research I found how to get this “SQL Server Surface Area Configuration” in SQL server 2008 R2.

Step 1:- Right click the SQL Server 2008 Server in SQL Server Management Studio.

 Step 2:- Choose option “Facets”

 Step 3:- You will get below screen. You just need to select “Surface Area Configuration” option from dropdown.

Step 4:- Once you have selected the “Surface Area Configuration “ then you will get following screen.

 

So now it is good to go and configure your setting.

Thanks & Best Regards

Rajat Jaiswal

 

How to incorporate word press theme in my Razor Blog

Hello friends,
As you know currently I am working on Razor. So I am trying to make a WordPress blog with Razor.Net.
Now the challenging task for me is design. I am not so good in designing so it’s a big deal for me. I just thought to download the WordPress theme and incorporate in My Blog work. So thanks to  free word press theme( http://www.freewordpressthemes4u.com/category/technology) I just downloaded the technology themes from there you can visit and see the other design.I like Mac Doc wordpress theme so here is the steps which I followed which help you also.
1) Just downloaded  the theme from any free wordpress theme sites
2) Copy all the images in your image folder of site
3) Copy CSS file in your Style folder.
4) Now open your site Layout page
5) Replace the body part of your site layout with default preview page of word press theme which you are looking currently. In my Case (free Mac theme page)
6) Then try make pieces of your design like  in my case on the default page there is a header part, footer part,  Search Box part, Archive Part, Center part (Where we will see post),Tag part, Category part.
7) So what I did I created all this part as a separate page like header.cshtml, footer.cshtml, SearchBox.cshtml, Archive.cshtml, Deafult.cshtml, TagSearch.cshtml, CategorySearch.cshtml.
8) Just cut the part from your site layout for specific items like header, site bar, content, category etc.
9) In SiteLayout page only call this pages. This is the simplest way.
10) Now if I need to incorporate any other Word press theme then I just needs to copy the theme and just need to replay site layout. This is the simplest way I found with Razor.

11) The best part is I just need to create a page cshtml and can place anywhere according to need and it will work like a word press functionality.

I hope you got some idea.
Soon I am going to upload the Blog which will help you to understand the concept of Razor more. It’s a simplest blog creation.
Thanks
Rajat Jaiswal

Simpletest way to fetch database records in Razor

Hello friends,
Today we are discussing how to fetch data from database in Razor.
You can connect with database using database.open() method.
This will return you database object.
For example
Database dbCon = Database.Open(“MyBlog”);

Now to fetch records from database you have mainly three methods which are
1) dbCon.Query() :- This method return IEnumeration object. You can use this method. Or in the other words it will return no of record sets which are available after running the specific query.
2) dbCon.QuerySingle():- By the name it will return single record set or single object. You can use it when you are sure the query will return single result set.
3) dbCon.QueryValue() :-
  This method is like your scalar method in ADONET. It will return scalar value or single value.

Here I am taking example of fetching multiple rows from a table.
Suppose I have a tag table and I need to fetch records from database and display it in a tabular html format. Then below are the steps.
1) Create database object
Database dbCon = Database.Open("MyBlog");
2) Get IEnumerable object  by query
var TagListRecords = dbCon.Query("SELECT * FROM lkuTag");
3) Run for loop on IEnumerable object  and print the columns of table result set
@foreach (var tagrecord in TagListRecords) {
<TR>
<TD>@tagrecord["lngId"]</TD>
<td>&nbsp;</td>
<TD>@tagrecord["Tag"]</TD>
</TR>
}
You will get following screen after running it.

I hope it is simplest way to fetch records.

In next topic we will discuss how to insert records in database in razor.

Till than thanks a lot.

Take care
Rajat Jaiswal

Learn Razor.NET A new tool

Hello friends,

Today we are going to discuss Razor.NET (ASP.NET Razor). It is like a wrapper on .NET very useful easy to learn.

Before going further as you know I am big fan of WWH so we will use WWH (What, why, how) questionnaires What is Asp.net Razor (Razor.net)?

Razor is a free tool by Microsoft by which you can write your Server side code using either VB.NET or C# syntax or you can say Asp.net Razor is new technique for writing code.

It just likes your classic ASP & PHP code. You need to write code in design page and server side code start with @ symbol.

So it will be easier for you if you have some hand over classic ASP or PHP.

 Why Razor?

As you know in the near future everything is on Mobile, PDA, and touchpad and most probably on HTML5. So great news is as per my thought Razor is developed just because of that goal. It is simple and easy to use. It helps in Mobile web development.

How to use it?

To use Razor you have to download a new tool which is called Web Matrix. Web Matrix is new IDE for developing Razor Application, which provide various utility which help you in develop a Razor application. You can download IDE from http://www.microsoft.com/web/downloads/platform.aspx

What is CSHTML & VBHTML Extension?

CSHTML & VBHTML are new file extension in Razor. The CSHTML file denotes that code is written in C# language and VBHTML denotes that code is written in VB.NET.

What is @RenderPage () function in Razor?

If you are ASP or PHP developer than you are aware of how to include a file. Render page function is used for reusable content. For example suppose you define a layout in which you have header page, footer page and content page and header page & footer page you required in all the content page then  you have to write just a simple line to include that file

 @RenderPage(“_header.cshtml”);

Other than this there are so many useful function like IsPost , @RenderSection(), @RenderBody Etc

which we will discuss in our next post.

Thanks for Reading

Enjoy weekend with Razor,

Rajat Jaiswal

How to resolve “AJAXControlToolKit required Ajax 4.0 script.”

Hello friends,

Recently my college got problem in AJAX file upload control which is “AJAXControlToolKit required Ajax4.0 script”

see the error detail in below snap.

 So the reason behind this he is using AJAX script manager not AJAX toolkit script manager. Now you have question when to use script manager and when to use AJAX toolkit script manager so my suggestion is always use AJAX toolkit script manager because it is faster than script manager in many ways and if you try to find difference between AJAX script Manager & AJAX Toolkit script manager then you will find AJAX toolkit script manager is best option for enhancement of your web app performance also.

(If you have not downloaded AJAX toolkit Script Manager then you can download latest  AJAX toolkit and install on your machine)

 So Enjoy weekend.

 Happy Makar sakranti (Indian New Year)

Thanks & Best Regards,

 Rajat Jaiswal

AJAXminifier a tool for website performance enhancement

Dear Friends,
Today I am going to share one more interesting utility provided by Microsoft which is called “Microsoft Ajax Minifier”.
Microsoft Ajax Minifier is a utility which will help you in minimizing the size of your Java script and CSS.
You can download this utility from http://www.asp.net/ajaxLibrary/Download.ashx
You can use this by command prompt.
For example I want to minimize the default.css of my project then I will follow following steps
Step 1: Run  ajaxmin command as shown in below fig

 
Step 2: if command is successful then you will get following screen

In this way after successful execution if you see the size of CSS file it significantly reduced as shown in below fig.

You have seen all the steps and utility now you are thinking why we have to use this and how it will work. So the answer is if your JS & CSS file size is less then it will take less time in load and your website will be faster. The working is as simple as you thought

AJAXMinifier remove all the unwanted white space, curly braces and use short hand in declaration and many more techniques for reducing the size.

I hope this will help you and me also in performance boost.
Keep enjoying Microsoft tools.

Thanks & best regards,
Rajat Jaiswal