Make your site dynamic! “What do you mean by a dynamic website?” – A website integrated with the database to generate information that visitors see is called a dynamic website. The antonym of dynamic website is a static website, which means that information displayed on the web pages is hard coded in them.

There are many benefits of having a dynamic website – the webmaster can make easy updates to information without fiddling with the source code of the website, generating different forms of information depending upon the visitor or input without creating separate pages for each possible output, give flexibility of adding as many pages as required without manually generating pages and uploading on the server, consistency while displaying information through out the website can be maintained, can offer different features for different type of users to avail services from the website respective to there domain, and the list goes on……

“How can a website be made dynamic?” – Embedding database related codes of any server side scripting language to the pages of website makes the website dynamic. Possible options for the server side scripting language you can use for your website depends on the operating system of the server on which your site is hosted. For Windows based server commonly used languages include PHP, ASP, ASP.NET, C#, Cold fusion etc., and for the Linux based server the options are PHP, Perl, Python, etc.

A considerable number of server side scripting languages are available to choose from but I am found of PHP (Hypertext Preprocessor) and always suggest it as the scripting language, the reasons for this liking are: -

a)First it runs on Linux as well as Windows server.
bIt’s a freeware so no cost of purchasing
c)The syntax is easy to learn and get used to.
d)It has a wide range of in-built features
e)Offers connectivity with most of the available database servers
f)Easy installation on server and easy configuration with other third party components
g)Is an object oriented programming language
h)It does not require any plug-in on client’s machine to get executed, it is complied on the server end and outputs the result in the form of HTML.

There are many such features which makes PHP not just my favorite but is a preferred language of many web developers.

“How to check if your server support PHP or not?” – Copy the piece of code below in a text editor and save the file as phpinfo.php, now upload it on your web server in the folder where you upload HTML pages. If it’s root of the server then type the URL http://www.yourdomainname.com/phpinfo.php in the address bar. If the output is a configuration then it means your server supports PHP and if it prompts to save the file then your server does not support PHP, you will have to ask your ISP to enable it for your domain.

Go to http://www.php.net/ to find more, learn and download PHP. Give it a try and you will realize how easy it is to use and to what extent it gives you the flexibility to make your website interactive and feature rich.

About the Author
Maneet Puri having an extensive experience of web based applications has assisted him to implement various knowledge driven process for his clients, and at the same time he provides consultancy to his clients for their website maintenance. With this expertise he has successfully added KPO and website maintenance as verticals to the Web Development company he is heading.

(1) Reporting services:-In SQL Server Reporting Services increase there benefit to customers. These include centralized report storage and management, control over how reports are processed or administered, and also have ability to fastest changing reports formats (HTML, Excel, PDF, etc.). This entire capabilities make reporting Services is valuable. So Web-based reporting has ability to make up-to-date information available to a distributed group of users. Reporting Services provides a impressive way to find and view reports, the Reporting Services interface may not be the most appropriate one for all report users.

(2) Partitioned Tables and Indexes:-Sql Server 2005 has ability to partition tables and indexes have always been a design to improve performance and manageability in larger databases. Microsoft SQL Server 2005 has many new features that simplify the design of using this feature.

(3) Xml Web services: - SQL Server 2005 provides a standard method for getting the database engine by using SOAP via HTTP. With the help of this methods, we can send SOAP/HTTP requests to SQL Server to execute stored procedures, extended stored procedures, T-SQL batch statements and scalar-valued user-defined functions which can have with or without parameters .When we use SQL Server as a Web Service that can for HTTP SOAP requests requires must create an HTTP endpoint and defining the methods that the endpoint exposes. When we create HTTP endpoint, that endpoint must be created with a unique URL that we uses to listen for incoming HTTP requests.

(4) Database Mirroring: - Database mirroring provides solution to provide high availability at the database level where all things depends upon the database. In Sql Server we can maintained synchronized copies of a database on two separate servers allows switching between them. And its plays its role on failure of primary server.

(5) CLR Integration: - Microsoft SQL Server 2005 has adopt the database programming model hosting by the Microsoft .NET Framework 2.0 Common Language Runtime (CLR). .Net CLR hosted inside SQL Server to improve performance, security and reliability. This helps developers to write procedures, triggers, and functions in any of the CLR languages.

To know more about Sql Server Interview Questions visit dotnetquestion.info and learn all interview questions related to sql server which is very helpful in interviews for you.

About the Author
Adam Sturo provide you the best and latest questions on Xml File Validation which also contains some other interview questions. You can find Jobs in Gurgaon, Delhi, Noida or NCR easily after reading these questions.